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

NOT Function in Excel: Reverse TRUE and FALSE

NOT Function in Excel: Reverse TRUE and FALSE featured illustration

7 Nov 2017 · Excel Functions A–Z · 1 min read

NOT Function in Excel: Reverse TRUE and FALSE

LogicalLevel: BeginnerAvailable in: Excel 2007+NOT flips TRUE to FALSE and back — useful for “everything except”.

Read article →
7 November 2017 by Atul Vij Excel Functions A–Z, Logical

Git for Beginners: Save Versions of Your Work Without “final_v7”

Git for Beginners: Save Versions of Your Work Without “final_v7” featured illustration

10 Oct 2017 · Dev Tools · 2 min read

Git for Beginners: Save Versions of Your Work Without “final_v7”

Understand Git in plain English — repository, commit, branch, merge — and learn the eight commands that cover almost everything, with a first project…

Read article →
10 October 2017 by Atul Vij Dev Tools

R for Excel Users: Your First Data Summary in 15 Lines

R for Excel Users: Your First Data Summary in 15 Lines

2 Sep 2017 · R · 2 min read

R for Excel Users: Your First Data Summary in 15 Lines

Start with R using a task you know from Excel: import a spreadsheet, summarise it by group, and draw a chart — in about…

Read article →
2 September 2017 by Atul Vij R

Recording the Sap Macro

Recording the Sap Macro

20 Aug 2017 · SAP GUI Scripting · 5 min read

Recording the Sap Macro

When you are ready to perform the recording, be sure you know the transaction you want to execute and the data that you can…

Read article →
20 August 2017 by Atul Vij SAP GUI Scripting

FINDB Function in Excel: Find Position in Bytes

FINDB Function in Excel: Find Position in Bytes featured illustration

16 Aug 2017 · Excel Functions A–Z · 1 min read

FINDB Function in Excel: Find Position in Bytes

TextLevel: ExpertAvailable in: Excel 2007+FINDB is the byte-based version of FIND.Syntax=FINDB("b",text)ArgumentWhat it meanstextText to work.

Read article →
16 August 2017 by Atul Vij Excel Functions A–Z, Text

ISBLANK Function in Excel: Is the Cell Truly Empty?

ISBLANK Function in Excel: Is the Cell Truly Empty? featured illustration

11 Aug 2017 · Excel Functions A–Z · 1 min read

ISBLANK Function in Excel: Is the Cell Truly Empty?

ISBLANK returns TRUE only for truly empty cells. A formula returning "" is not blank to ISBLANK — a common surprise.

Read article →
11 August 2017 by Atul Vij Excel Functions A–Z, Information

LEFTB Function in Excel: Leftmost Bytes

LEFTB Function in Excel: Leftmost Bytes featured illustration

9 Aug 2017 · Excel Functions A–Z · 1 min read

LEFTB Function in Excel: Leftmost Bytes

LEFTB returns the first characters based on bytes. In English (single-byte) setups it behaves exactly like LEFT; it differs only when a double-byte language…

Read article →
9 August 2017 by Atul Vij Excel Functions A–Z, Text

RIGHTB Function in Excel: Rightmost Bytes

RIGHTB Function in Excel: Rightmost Bytes featured illustration

8 Aug 2017 · Excel Functions A–Z · 1 min read

RIGHTB Function in Excel: Rightmost Bytes

RIGHTB is the byte-based version of RIGHT; identical to RIGHT in English setups.

Read article →
8 August 2017 by Atul Vij Excel Functions A–Z, Text

FIND Function in Excel: Position of Text (Case-Sensitive)

FIND Function in Excel: Position of Text (Case-Sensitive) featured illustration

3 Aug 2017 · Excel Functions A–Z · 1 min read

FIND Function in Excel: Position of Text (Case-Sensitive)

FIND returns where one text starts inside another. It is case-sensitive and does not allow wildcards — use SEARCH for that.

Read article →
3 August 2017 by Atul Vij Excel Functions A–Z, Text

MID Function in Excel: Extract Text From the Middle

MID Function in Excel: Extract Text From the Middle featured illustration

1 Aug 2017 · Excel Functions A–Z · 1 min read

MID Function in Excel: Extract Text From the Middle

MID returns characters from the middle of a text, starting at a position you choose.

Read article →
1 August 2017 by Atul Vij Excel Functions A–Z, Text

RIGHT Function in Excel: Take Characters From the End of Text

RIGHT Function in Excel: Take Characters From the End of Text featured illustration

23 Jul 2017 · Excel Functions A–Z · 1 min read

RIGHT Function in Excel: Take Characters From the End of Text

TextLevel: BeginnerAvailable in: Excel 2007+RIGHT returns the last characters of a text value.Syntax=RIGHT(text, [num_chars])ArgumentWhat it meanstextThe.

Read article →
23 July 2017 by Atul Vij Excel Functions A–Z, Text

LEN Function in Excel: Count Characters in Text

LEN Function in Excel: Count Characters in Text featured illustration

22 Jul 2017 · Excel Functions A–Z · 1 min read

LEN Function in Excel: Count Characters in Text

TextLevel: BeginnerAvailable in: Excel 2007+LEN returns the number of characters, including spaces.Syntax=LEN(text)ArgumentWhat it meanstextText or a.

Read article →
22 July 2017 by Atul Vij Excel Functions A–Z, Text

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? →