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
  • 📲 Get App
FACT Function in Excel: Factorial

17 May 2019 · Excel Functions A–Z · 1 min read

FACT Function in Excel: Factorial

FACT returns n! (1 × 2 × … × n). It grows absurdly fast: FACT(20) is already about 2.4 quintillion.

Read article →
DATEDIF Function in Excel: Age and Tenure in Years, Months, Days

16 May 2019 · Date & Time · 1 min read

DATEDIF Function in Excel: Age and Tenure in Years, Months, Days

DATEDIF is a hidden function (not in the autocomplete list) that returns the difference between two dates in completed years, months or days.

Read article →
JSON Explained Simply (for Excel People)

14 May 2019 · Dev Tools · 1 min read

JSON Explained Simply (for Excel People)

What JSON is, how to read it, how it maps to rows and columns, and how to load JSON into Excel with Power Query or Python — explained without jargon.

Read article →
PERMUT Function in Excel: Arrangements Where Order Matters

7 May 2019 · Excel Functions A–Z · 1 min read

PERMUT Function in Excel: Arrangements Where Order Matters

PERMUT counts ordered arrangements — podium positions, codes without repeated digits.

Read article →
EDATE Function in Excel: Add or Subtract Months From a Date

5 May 2019 · Date & Time · 1 min read

EDATE Function in Excel: Add or Subtract Months From a Date

EDATE returns the same day a number of months before or after a date — ideal for due dates, renewals and EMIs.

Read article →
EOMONTH Function in Excel: Last Day of a Month

5 May 2019 · Date & Time · 1 min read

EOMONTH Function in Excel: Last Day of a Month

Date & TimeLevel: IntermediateAvailable in: Excel 2007+EOMONTH returns the last day of the month, a number of months away from a.

Read article →
YEAR Function in Excel: Year From a Date

3 May 2019 · Date & Time · 1 min read

YEAR Function in Excel: Year From a Date

YEAR returns the four-digit year of a date. MONTH and DAY work the same way for the month (1–12) and day (1–31).

Read article →
PowerPoint Slide Master: Fix Every Slide in One Place

2 May 2019 · PowerPoint · 2 min read

PowerPoint Slide Master: Fix Every Slide in One Place

Stop formatting slides one by one. Use PowerPoint’s Slide Master to control fonts, colours, logos and layouts for the whole deck — and rescue messy presentations.

Read article →
COMBIN Function in Excel: How Many Groups Are Possible

30 Apr 2019 · Excel Functions A–Z · 1 min read

COMBIN Function in Excel: How Many Groups Are Possible

COMBIN counts the ways to choose items when order doesn’t matter — teams from a class, lottery tickets, product bundles.

Read article →
MONTH Function in Excel: Month Number From a Date

29 Apr 2019 · Date & Time · 1 min read

MONTH Function in Excel: Month Number From a Date

MONTH returns 1 for January through 12 for December — the building block for monthly reports and fiscal-period logic.

Read article →
REPT Function in Excel: Repeat Text (In-Cell Bar Charts)

26 Apr 2019 · Excel Functions A–Z · 1 min read

REPT Function in Excel: Repeat Text (In-Cell Bar Charts)

REPT repeats text a number of times — best known for quick bar charts inside cells.

Read article →
WEEKDAY Function in Excel: Day of the Week as a Number

25 Apr 2019 · Date & Time · 1 min read

WEEKDAY Function in Excel: Day of the Week as a Number

WEEKDAY returns a number for the day of the week. Type 2 makes Monday = 1 … Sunday = 7, the easiest for weekend checks.

Read article →
Older posts
Newer posts
← Previous Page1 … Page92 Page93 Page94 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →