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
SUBTOTAL Function in Excel: Totals That Respect Filters

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 totals never double-count.

Read article →
SQL Window Functions: Running Totals, Rankings and Month-on-Month in One Query

15 Oct 2019 · SQL · 3 min read

SQL Window Functions: Running Totals, Rankings and Month-on-Month in One Query

A practical guide to SQL window functions: OVER and PARTITION BY, ROW_NUMBER, RANK and DENSE_RANK, running totals, moving averages, LAG/LEAD for month-on-month change, and top-N per group.

Read article →
SUMPRODUCT Function in Excel: Multiply Arrays and Add the Results

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

SUMPRODUCT Function in Excel: Multiply Arrays and Add the Results

SUMPRODUCT multiplies ranges row by row and adds the products. Because it handles arrays natively, it doubles as a flexible conditional sum and counter in every version.

Read article →
DAY Function in Excel: Day of the Month

8 Oct 2019 · Date & Time · 1 min read

DAY Function in Excel: Day of the Month

DAY returns 1–31 from a date. Pair it with YEAR and MONTH to rebuild or test dates.

Read article →
SUMIFS Function in Excel: Sum With Multiple Conditions

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

SUMIFS Function in Excel: Sum With Multiple Conditions

SUMIFS adds values where all conditions are true — the backbone of formula-based reports.

Read article →
SHEET Function in Excel: Which Sheet Number?

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

SHEET Function in Excel: Which Sheet Number?

InformationLevel: IntermediateAvailable in: Excel 2013+SHEET returns the position number of a sheet.Syntax=SHEET([value])ArgumentWhat it meansvalueA.

Read article →
ISOWEEKNUM Function in Excel: ISO Week Number

1 Oct 2019 · Date & Time · 1 min read

ISOWEEKNUM Function in Excel: ISO Week Number

ISOWEEKNUM returns the ISO 8601 week (weeks start on Monday; week 1 holds the first Thursday). Use it when European teams or SAP reports say “week 1”, because WEEKNUM can disagree around New Year.

Read article →
CELL Function in Excel: Information About a Cell

24 Sep 2019 · Excel Functions A–Z · 1 min read

CELL Function in Excel: Information About a Cell

CELL reports details such as address, column width, number format or file path. Its best-known use is getting the current sheet name.

Read article →
Docker for Beginners: Run Any App Without Installing It

3 Sep 2019 · Dev Tools · 1 min read

Docker for Beginners: Run Any App Without Installing It

What containers are, why “works on my machine” disappears, and your first Docker commands — run a database, a Jupyter notebook and your own Python script in a container.

Read article →
DEC2HEX Function in Excel: Decimal to Hexadecimal

13 Aug 2019 · Engineering · 1 min read

DEC2HEX Function in Excel: Decimal to Hexadecimal

DEC2HEX converts numbers to hex — the notation behind web colours and memory addresses.

Read article →
BIN2DEC Function in Excel: Binary to Decimal

6 Aug 2019 · Engineering · 1 min read

BIN2DEC Function in Excel: Binary to Decimal

EngineeringLevel: IntermediateAvailable in: Excel 2007+BIN2DEC reads binary text (up to 10 digits) and returns the.

Read article →
DEC2BIN Function in Excel: Decimal to Binary

30 Jul 2019 · Engineering · 1 min read

DEC2BIN Function in Excel: Decimal to Binary

DEC2BIN converts a number to binary text. Good for teaching, flags and subnet masks, but it only handles −512 to 511.

Read article →
Older posts
Newer posts
← Previous Page1 … Page90 Page91 Page92 … 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? →