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

FIXED Function in Excel: Round and Format as Text

FIXED Function in Excel: Round and Format as Text featured illustration

8 Dec 2019 · Excel Functions A–Z · 1 min read

FIXED Function in Excel: Round and Format as Text

FIXED rounds a number and returns it as text with or without thousands separators — good for sentences built from numbers.

Read article →
8 December 2019 by Atul Vij Excel Functions A–Z, Text

Google Sheets QUERY Function for Excel Users

Google Sheets QUERY Function for Excel Users

29 Nov 2019 · Google Workspace · 2 min read

Google Sheets QUERY Function for Excel Users

Google Sheets’ QUERY function lets you filter, group and sort with SQL-like syntax in one formula. Learn it with examples mapped to Excel features…

Read article →
29 November 2019 by Atul Vij Google Workspace, SQL

ISERROR Function in Excel: Does the Formula Return Any Error?

ISERROR Function in Excel: Does the Formula Return Any Error? featured illustration

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

ISERROR Function in Excel: Does the Formula Return Any Error?

ISERROR returns TRUE for any error value. It is mostly used in conditional formatting and checks; for replacing errors, IFERROR is simpler.

Read article →
8 November 2019 by Atul Vij Excel Functions A–Z, Information

DMIN Function in Excel: Smallest Value With a Criteria Table

DMIN Function in Excel: Smallest Value With a Criteria Table featured illustration

8 Nov 2019 · Database · 1 min read

DMIN Function in Excel: Smallest Value With a Criteria Table

DatabaseLevel: ExpertAvailable in: Excel 2007+DMIN is DMAX’s twin: the smallest value among matching rows.Syntax=DMIN(database, field.

Read article →
8 November 2019 by Atul Vij Database, Excel Functions A–Z

DMAX Function in Excel: Largest Value With a Criteria Table

DMAX Function in Excel: Largest Value With a Criteria Table featured illustration

2 Nov 2019 · Database · 1 min read

DMAX Function in Excel: Largest Value With a Criteria Table

DMAX returns the largest value in a column among matching rows. It worked in every Excel version long before MAXIFS existed.

Read article →
2 November 2019 by Atul Vij Database, Excel Functions A–Z

MINIFS Function in Excel: Smallest Value Meeting Conditions

MINIFS Function in Excel: Smallest Value Meeting Conditions featured illustration

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

MINIFS Function in Excel: Smallest Value Meeting Conditions

StatisticalLevel: IntermediateAvailable in: Excel 2019+MINIFS returns the minimum of values where all conditions are true.Syntax=MINIFS(min_range.

Read article →
30 October 2019 by Atul Vij Excel Functions A–Z, Statistical

PRODUCT Function in Excel: Multiply Many Numbers

PRODUCT Function in Excel: Multiply Many Numbers featured illustration

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

PRODUCT Function in Excel: Multiply Many Numbers

MathLevel: BeginnerAvailable in: Excel 2007+PRODUCT multiplies all numbers in its arguments, ignoring text and blanks.Syntax=PRODUCT(number1, [number2].

Read article →
30 October 2019 by Atul Vij Excel Functions A–Z, Math & Trig

Unpivot Monthly Columns into a Clean Table with Power Query

Unpivot Monthly Columns into a Clean Table with Power Query featured illustration

27 Oct 2019 · Power Query & Pivots · 2 min read

Unpivot Monthly Columns into a Clean Table with Power Query

Turn a wide report with Jan–Dec columns into a tidy Month/Value table using Power Query’s Unpivot — so pivot tables, charts and SUMIFS finally…

Read article →
27 October 2019 by Atul Vij Power Query & Pivots

MAXIFS Function in Excel: Largest Value Meeting Conditions

MAXIFS Function in Excel: Largest Value Meeting Conditions featured illustration

23 Oct 2019 · Excel Functions A–Z · 1 min read

MAXIFS Function in Excel: Largest Value Meeting Conditions

MAXIFS returns the maximum of values where all conditions are met; MINIFS returns the minimum.

Read article →
23 October 2019 by Atul Vij Excel Functions A–Z, Statistical

SUMSQ Function in Excel: Sum of Squares

SUMSQ Function in Excel: Sum of Squares featured illustration

21 Oct 2019 · Excel Functions A–Z · 1 min read

SUMSQ Function in Excel: Sum of Squares

SUMSQ squares each value and adds them up — the building block of error measures such as RMSE.

Read article →
21 October 2019 by Atul Vij Excel Functions A–Z, Math & Trig

AGGREGATE Function in Excel: SUBTOTAL That Can Ignore Errors

AGGREGATE Function in Excel: SUBTOTAL That Can Ignore Errors featured illustration

20 Oct 2019 · Excel Functions A–Z · 1 min read

AGGREGATE Function in Excel: SUBTOTAL That Can Ignore Errors

AGGREGATE is like SUBTOTAL with 19 functions and extra options — most usefully, ignoring error values such as #N/A in the range.

Read article →
20 October 2019 by Atul Vij Excel Functions A–Z, Math & Trig

SUBTOTAL Function in Excel: Totals That Respect Filters

SUBTOTAL Function in Excel: Totals That Respect Filters featured illustration

16 Oct 2019 · Excel Functions A–Z · 1 min read

SUBTOTAL Function in Excel: Totals That Respect Filters

SUBTOTAL calculates a sum, count, average and more while ignoring rows hidden by a filter. It also ignores other SUBTOTALs in the range, so…

Read article →
16 October 2019 by Atul Vij Excel Functions A–Z, Math & Trig

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