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
GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table

28 Jan 2026 · Excel Functions A–Z · 1 min read

GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table

GETPIVOTDATA pulls a value from a pivot by field names, not by cell position — so your report keeps working when the pivot grows or reorders. Excel writes it for you when you click a pivot cell.

Read article →
ISERR Function in Excel: Any Error Except #N/A

27 Jan 2026 · Excel Functions A–Z · 1 min read

ISERR Function in Excel: Any Error Except #N/A

ISERR is TRUE for every error except #N/A. That lets you treat “not found” as normal while still catching real breakages like #DIV/0! or #REF!.

Read article →
NA Function in Excel: Return #N/A on Purpose

26 Jan 2026 · Excel Functions A–Z · 1 min read

NA Function in Excel: Return #N/A on Purpose

NA produces #N/A deliberately. Charts skip #N/A points instead of plotting them as zero.

Read article →
TRIMRANGE Function in Excel: Cut Empty Edges Off a Range

26 Jan 2026 · Excel Functions A–Z · 1 min read

TRIMRANGE Function in Excel: Cut Empty Edges Off a Range

TRIMRANGE removes empty rows and columns from the outside of a range, so formulas can point at whole columns without processing a million blanks.

Read article →
CUBEMEMBER Function in Excel: A Label From the Data Model

25 Jan 2026 · Cube · 1 min read

CUBEMEMBER Function in Excel: A Label From the Data Model

CUBEMEMBER returns a member (like a year or product) from the Data Model, which CUBEVALUE can then reference.

Read article →
MATCH Function in Excel: Find the Position of a Value

25 Jan 2026 · Excel Functions A–Z · 1 min read

MATCH Function in Excel: Find the Position of a Value

MATCH returns the position of a value in a list — the “where is it?” half of INDEX/MATCH.

Read article →
XMATCH Function in Excel: MATCH With Better Defaults

24 Jan 2026 · Excel Functions A–Z · 1 min read

XMATCH Function in Excel: MATCH With Better Defaults

XMATCH returns the position of an item, defaulting to exact match, and can search from the end or use wildcards.

Read article →
DGET Function in Excel: Get the One Matching Value

24 Jan 2026 · Database · 1 min read

DGET Function in Excel: Get the One Matching Value

DGET returns a single value from the row that matches — and, usefully, refuses to guess when more than one row matches.

Read article →
GROUPBY Function in Excel: A Pivot-Style Summary in One Formula

21 Jan 2026 · Excel 365 & Dynamic Arrays · 1 min read

GROUPBY Function in Excel: A Pivot-Style Summary in One Formula

GROUPBY groups rows by one or more columns and aggregates values — a live summary table that updates as data changes, without refreshing a pivot.

Read article →
TEXTSPLIT Function in Excel: Split Text Into Cells

19 Jan 2026 · Excel Functions A–Z · 1 min read

TEXTSPLIT Function in Excel: Split Text Into Cells

TEXTSPLIT splits text by a delimiter into columns and/or rows — a formula version of Text to Columns that updates automatically.

Read article →
IFNA Function in Excel: Handle “Not Found” Only

19 Jan 2026 · Excel Functions A–Z · 1 min read

IFNA Function in Excel: Handle “Not Found” Only

IFNA replaces only #N/A — the “not found” result of lookups — and lets real errors show.

Read article →
CONCATENATE Function in Excel: The Old Way to Join Text

18 Jan 2026 · Excel Functions A–Z · 1 min read

CONCATENATE Function in Excel: The Old Way to Join Text

CONCATENATE joins text pieces. It still works for compatibility, but it cannot take a range — CONCAT and TEXTJOIN replaced it.

Read article →
Older posts
Newer posts
← Previous Page1 … Page35 Page36 Page37 … 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? →