Skip to content

Popular topics

ExcelExcel VBAPower Query & PivotsExcel for FinanceAutomationSAP & OracleCodingAI & MLTech tipsWacky World

Recent posts

  • Basics of VBA / Macros Chapter – 81 (Userform Part-2)
  • Basics of VBA / Macros Chapter – 80 (Userform Part-1)
  • Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
  • Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
  • Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
  • Loan Amortization Schedule in Excel with Extra Payments: Step-by-Step Template & Formulas

🀯 Wacky fact of the day · Human Body

You blink around 15–20 times a minute.

Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry…

Why? How? β†’Source β†—

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips β€” plus wacky facts

Skip to content
  • ✨ AI Helper
  • πŸŽ“ Courses
  • Excel & Office
    • Charts & Dashboards
    • Excel 365 & Dynamic Arrays
    • Excel for Finance
    • Excel for India
    • Excel Formulas
    • Excel Functions A–Z
    • Excel VBA
    • Formula Combos
    • Power BI & DAX
    • Power Query & Pivots
    • Python in Excel
    • Google Workspace
    • Outlook
    • PowerPoint
    • Word
  • Coding
    • Cloud & Servers
    • Dev Tools
    • Java
    • JavaScript
    • PowerShell
    • Python
    • R
    • Rust
    • SQL
    • VBA to Python Migration
  • Automation
    • AutoHotkey
    • Automation Basics
    • Office Scripts
    • Power Automate
    • Python Automation
    • SAP GUI Scripting
  • AI & ML
    • AI Agents & RAG
    • AI Agents & Workflows
    • AI Tools
    • Build Your Own LLM
    • Deep Learning
    • LLMs
    • Machine Learning
    • Prompt Engineering
    • Vibe Coding
  • ERP
    • Essbase
    • Oracle EPM Cloud
    • Oracle Smart View
    • SAP
    • Tally & Busy
    • Tax & Compliance
  • Tech Tips
    • Internet & Browser
    • Phone
    • Security & Privacy
    • Windows
    • Work Smarter
  • Wacky World
    • Fun Facts
    • History
    • Science
    • All Wacky Facts
  • Tools
    • Formula Lab
    • VBA Playground
    • Macro Recorder
    • VBA Challenges
    • SQL Playground
    • Shortcut Trainer
    • Date & Workday Calculator
    • EMI & SIP Calculator
    • Income Tax: Old vs New
    • GST Calculator
    • Regex Tester
  • About
    • Projects
    • Contact

Atul Vij

ISEVEN Function in Excel: Is the Number Even?

ISEVEN Function in Excel: Is the Number Even? featured illustration

19 Jun 2018 Β· Excel Functions A–Z Β· 1 min read

ISEVEN Function in Excel: Is the Number Even?

ISEVEN returns TRUE for even numbers; ISODD for odd ones. Decimals are truncated first.

Read article β†’
19 June 2018 by Atul Vij Excel Functions A–Z, Information

XOR Function in Excel: Exactly One Condition True

XOR Function in Excel: Exactly One Condition True featured illustration

5 Jun 2018 Β· Excel Functions A–Z Β· 1 min read

XOR Function in Excel: Exactly One Condition True

XOR returns TRUE when an odd number of conditions are TRUE β€” with two conditions, β€œone or the other but not both”.

Read article β†’
5 June 2018 by Atul Vij Excel Functions A–Z, Logical

FORMULATEXT Function in Excel: Show a Formula as Text

FORMULATEXT Function in Excel: Show a Formula as Text featured illustration

8 May 2018 Β· Excel Functions A–Z Β· 1 min read

FORMULATEXT Function in Excel: Show a Formula as Text

FORMULATEXT displays the formula of another cell β€” perfect for documenting models and training sheets.

Read article β†’
8 May 2018 by Atul Vij Excel Functions A–Z, Lookup & Reference

Read and Write Excel Files in Java with Apache POI

Read and Write Excel Files in Java with Apache POI

21 Apr 2018 Β· Java Β· 2 min read

Read and Write Excel Files in Java with Apache POI

A beginner-friendly guide to reading and writing .xlsx files in Java using Apache POI β€” with complete, working examples and common pitfalls.

Read article β†’
21 April 2018 by Atul Vij Java

EFFECT Function in Excel: Real Annual Rate With Compounding

EFFECT Function in Excel: Real Annual Rate With Compounding featured illustration

7 Apr 2018 Β· Excel Functions A–Z Β· 1 min read

EFFECT Function in Excel: Real Annual Rate With Compounding

EFFECT converts a nominal annual rate into the effective rate after compounding. NOMINAL does the reverse.

Read article β†’
7 April 2018 by Atul Vij Excel Functions A–Z, Financial

RATE Function in Excel: The Interest Rate Hidden in a Loan

RATE Function in Excel: The Interest Rate Hidden in a Loan featured illustration

20 Mar 2018 Β· Excel Functions A–Z Β· 1 min read

RATE Function in Excel: The Interest Rate Hidden in a Loan

RATE works out the interest rate from the loan amount, EMI and term β€” useful for checking β€œ0% EMI” and flat-rate offers.

Read article β†’
20 March 2018 by Atul Vij Excel Functions A–Z, Financial

Notepad++ Tricks for Cleaning Data Before Excel

Notepad++ Tricks for Cleaning Data Before Excel featured illustration

18 Mar 2018 Β· Work Smarter Β· 2 min read

Notepad++ Tricks for Cleaning Data Before Excel

Column mode editing, regex find and replace, removing blank lines and comparing files β€” Notepad++ tricks that clean messy exports before they reach Excel.

Read article β†’
18 March 2018 by Atul Vij Work Smarter

Regex for Office Users: Find and Replace Like a Pro

Regex for Office Users: Find and Replace Like a Pro featured illustration

13 Mar 2018 Β· Dev Tools Β· 3 min read

Regex for Office Users: Find and Replace Like a Pro

Learn regex step by step with ten practical patterns β€” emails, phone numbers, PAN, dates, invoice numbers β€” usable in Notepad++, VBA, Python, SQL…

Read article β†’
13 March 2018 by Atul Vij Dev Tools

Back Up Your Phone Photos Properly (the 3-2-1 Way)

Back Up Your Phone Photos Properly (the 3-2-1 Way) featured illustration

7 Mar 2018 Β· Phone Β· 2 min read

Back Up Your Phone Photos Properly (the 3-2-1 Way)

A simple, reliable way to protect years of phone photos: cloud backup, a local copy and a second place β€” the 3-2-1 rule explained…

Read article β†’
7 March 2018 by Atul Vij Phone, Security & Privacy

R Lesson 6: Project β€” A Sales Analysis Report

R Lesson 6: Project β€” A Sales Analysis Report featured illustration

20 Feb 2018 Β· R Β· 1 min read

R Lesson 6: Project β€” A Sales Analysis Report

Combine reading, dplyr and ggplot2 into a repeatable analysis: KPIs, product summary, charts and output files, plus a pointer to R Markdown/Quarto reports.

Read article β†’
20 February 2018 by Atul Vij R

R Lesson 3: Reading CSV and Excel

R Lesson 3: Reading CSV and Excel featured illustration

17 Feb 2018 Β· R Β· 1 min read

R Lesson 3: Reading CSV and Excel

Load data into R with readr::read_csv and readxl::read_excel, check columns and types, handle dates and missing values, and write results back out.

Read article β†’
17 February 2018 by Atul Vij R

R Lesson 2: Vectors and Data Frames

R Lesson 2: Vectors and Data Frames featured illustration

16 Feb 2018 Β· R Β· 1 min read

R Lesson 2: Vectors and Data Frames

R’s building blocks: vectors and vectorised maths, data frames as tables, selecting rows and columns, and checking structure with str and summary.

Read article β†’
16 February 2018 by Atul Vij R

Post navigation

← Older posts
Newer posts →
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
Β© 2026 Atul Vij Β· AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? β†’