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

LEFT Function in Excel: Take Characters From the Start of Text

LEFT Function in Excel: Take Characters From the Start of Text featured illustration

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

LEFT Function in Excel: Take Characters From the Start of Text

TextLevel: BeginnerAvailable in: Excel 2007+LEFT returns the first characters of a text. RIGHT takes them from the end.Syntax=LEFT(text.

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

NPV Function in Excel: Net Present Value of Future Cash Flows

NPV Function in Excel: Net Present Value of Future Cash Flows featured illustration

13 Jun 2017 · Excel Functions A–Z · 1 min read

NPV Function in Excel: Net Present Value of Future Cash Flows

NPV discounts future cash flows to today’s value at a given rate — the core of investment appraisal.

Read article →
13 June 2017 by Atul Vij Excel Functions A–Z, Financial

PMT Function in Excel: Loan EMI in One Formula

PMT Function in Excel: Loan EMI in One Formula featured illustration

6 Jun 2017 · Excel Functions A–Z · 1 min read

PMT Function in Excel: Loan EMI in One Formula

PMT calculates the fixed periodic payment for a loan — the EMI on home, car and personal loans.

Read article →
6 June 2017 by Atul Vij Excel Functions A–Z, Financial

Word Wildcard Find & Replace: 8 Patterns That Save Hours

Word Wildcard Find & Replace: 8 Patterns That Save Hours

18 Mar 2017 · Word · 2 min read

Word Wildcard Find & Replace: 8 Patterns That Save Hours

Word’s wildcard search is a hidden power tool. Eight ready-to-use patterns to fix spaces, dates, phone numbers, brackets and formatting in long documents.

Read article →
18 March 2017 by Atul Vij Word

COUNTBLANK Function in Excel: Count Empty Cells

COUNTBLANK Function in Excel: Count Empty Cells featured illustration

7 Feb 2017 · Excel Functions A–Z · 2 min read

COUNTBLANK Function in Excel: Count Empty Cells

Count the number of empty cells in a range, essential for identifying missing records, incomplete audit checklists, and data hygiene gaps.

Read article →
7 February 2017 by Atul Vij Excel Functions A–Z, Statistical

MEDIAN Function in Excel: The Middle Value

MEDIAN Function in Excel: The Middle Value featured illustration

31 Jan 2017 · Excel Functions A–Z · 2 min read

MEDIAN Function in Excel: The Middle Value

Calculate the statistical median (exact middle value) of a numeric dataset, providing a realistic baseline unaffected by extreme outliers.

Read article →
31 January 2017 by Atul Vij Excel Functions A–Z, Statistical

MOD Function in Excel: Remainder After Division

MOD Function in Excel: Remainder After Division featured illustration

15 Nov 2016 · Excel Functions A–Z · 2 min read

MOD Function in Excel: Remainder After Division

Calculate the remainder after dividing a number by a divisor, powering alternating row formatting, time calculations, and cyclic patterns.

Read article →
15 November 2016 by Atul Vij Excel Functions A–Z, Math & Trig

MROUND Function in Excel: Round to the Nearest Multiple

MROUND Function in Excel: Round to the Nearest Multiple featured illustration

8 Nov 2016 · Excel Functions A–Z · 1 min read

MROUND Function in Excel: Round to the Nearest Multiple

MROUND rounds to the nearest multiple you choose — prices to ₹5, times to 15 minutes.

Read article →
8 November 2016 by Atul Vij Excel Functions A–Z, Math & Trig

Word Styles and an Automatic Table of Contents (Step by Step)

Word Styles and an Automatic Table of Contents (Step by Step)

4 Oct 2016 · Word · 2 min read

Word Styles and an Automatic Table of Contents (Step by Step)

Use Word’s Heading styles to format long documents consistently, build an automatic table of contents, number headings and navigate with the Navigation Pane.

Read article →
4 October 2016 by Atul Vij Word

SUMIF Function in Excel: Sum Values That Meet One Condition

SUMIF Function in Excel: Sum Values That Meet One Condition featured illustration

12 Jul 2016 · Excel Functions A–Z · 2 min read

SUMIF Function in Excel: Sum Values That Meet One Condition

Calculate the total of numbers in a range that meet a specific condition, text match, date criteria, or logical comparison.

Read article →
12 July 2016 by Atul Vij Excel Functions A–Z, Math & Trig

Stop Crossing Oceans for People

Stop Crossing Oceans for People

3 Jul 2016 · Fun Facts · 1 min read

Stop Crossing Oceans for People

There comes a time when you have to stop crossing oceans for people who would not even jump puddles for you.

Read article →
3 July 2016 by Atul Vij Fun Facts

Laughter is Panic Response to Tickling

Laughter is Panic Response to Tickling

18 Jun 2016 · Fun Facts · 4 min read

Laughter is Panic Response to Tickling

Most of us have a ticklish spot somewhere on our bodies, and it is usually pretty easy to find. Laughing when another person tickles…

Read article →
18 June 2016 by Atul Vij Fun Facts

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