Skip to content

AJ's Techie & Wacky World

  • ✨ 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
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 →
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 →
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 →
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 →
Word Wildcard Find & Replace: 8 Patterns That Save Hours

18 Mar 2017 · Word · 1 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…

Read article →
COUNTBLANK Function in Excel: Count Empty Cells featured illustration

7 Feb 2017 · Excel Functions A–Z · 1 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 →
MEDIAN Function in Excel: The Middle Value featured illustration

31 Jan 2017 · Excel Functions A–Z · 1 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 →
MOD Function in Excel: Remainder After Division featured illustration

15 Nov 2016 · Excel Functions A–Z · 1 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 →
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 →
Word Styles and an Automatic Table of Contents (Step by Step)

4 Oct 2016 · Word · 1 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…

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

12 Jul 2016 · Excel Functions A–Z · 1 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 →
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 →
Advertisement
Older posts
Newer posts
← Previous Page1 … Page99 Page100 Page101 Page102 Next →

Popular topics

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

Recent posts

  • Basics of VBA / Macros Chapter – 82 (Userform Part-3)
  • 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)

🤯 Wacky fact of the day · Human Body

Fingerprints form in the womb and never change.

Fingerprint ridges form by around the 17th week of pregnancy. Even identical twins have different fingerprints.

Why? How? →Source ↗

© 2026 AJ's Techie & Wacky World • Built with GeneratePress
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →