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
Excel Intermediate Lesson 8: LET for Readable, Faster Formulas

14 Jan 2025 · Excel · 1 min read

Excel Intermediate Lesson 8: LET for Readable, Faster Formulas

Name the parts of a long formula with LET so it is readable and calculates once. Worked examples: GST, share of total, top rep and paid ratio.

Read article →
Excel Lesson 3: Formatting Cells So Reports Read Well

14 Jan 2025 · Excel Formulas · 3 min read

Excel Lesson 3: Formatting Cells So Reports Read Well

Number, currency, percentage and date formats, custom formats like 000 and lakhs, alignment and wrap text, borders, Format Painter, cell styles — and why formatting never changes the value underneath.

Read article →
Excel Intermediate Lesson 7: Logic With IFS, SWITCH, AND and OR

13 Jan 2025 · Excel · 2 min read

Excel Intermediate Lesson 7: Logic With IFS, SWITCH, AND and OR

Replace long nested IFs with IFS and SWITCH, combine conditions with AND/OR, and count with AND/OR logic in COUNTIFS. Grades, commissions and follow-up flags.

Read article →
Excel Intermediate Lesson 6: Business Dates (WORKDAY, NETWORKDAYS, EOMONTH, FY Quarters)

12 Jan 2025 · Excel · 2 min read

Excel Intermediate Lesson 6: Business Dates (WORKDAY, NETWORKDAYS, EOMONTH, FY Quarters)

Due dates, delivery dates with holidays, working days in a month, Indian financial-year quarters and FY labels, all with formulas you can copy.

Read article →
Excel Intermediate Lesson 5: Cleaning Text With TEXTSPLIT, TEXTBEFORE and TEXTAFTER

11 Jan 2025 · Excel · 2 min read

Excel Intermediate Lesson 5: Cleaning Text With TEXTSPLIT, TEXTBEFORE and TEXTAFTER

Clean messy ERP and bank exports: split pipe-separated text, fix case and spaces, pull invoice numbers and names with TEXTBEFORE, TEXTAFTER, TEXTSPLIT, TRIM and SUBSTITUTE.

Read article →
Excel Intermediate Lesson 4: Dynamic Arrays (FILTER, SORT, UNIQUE, SEQUENCE)

10 Jan 2025 · Excel · 2 min read

Excel Intermediate Lesson 4: Dynamic Arrays (FILTER, SORT, UNIQUE, SEQUENCE)

One formula, many results: FILTER, SORT, SORTBY, UNIQUE and SEQUENCE spill whole lists that update themselves. With real examples from a sales register.

Read article →
Excel Intermediate Lesson 3: INDEX/MATCH and Advanced XLOOKUP

9 Jan 2025 · Excel · 2 min read

Excel Intermediate Lesson 3: INDEX/MATCH and Advanced XLOOKUP

Two-way lookups, lookups to the left, last-match searches and not-found defaults with INDEX/MATCH and XLOOKUP, with a regional targets grid.

Read article →
Excel Intermediate Lesson 2: SUMIFS, COUNTIFS and AVERAGEIFS Reports

8 Jan 2025 · Excel · 2 min read

Excel Intermediate Lesson 2: SUMIFS, COUNTIFS and AVERAGEIFS Reports

Build region, month and status reports from a raw sales register with SUMIFS, COUNTIFS and AVERAGEIFS, including date ranges, wildcards and not-equal criteria.

Read article →
Running Total and Running Count in Excel (Classic, Table and SCAN Methods)

7 Jan 2025 · Formula Combos · 3 min read

Running Total and Running Count in Excel (Classic, Table and SCAN Methods)

Cumulative totals, running counts, running totals by category and month-to-date sums — with expanding ranges, SUMIFS, Excel Table formulas and the new SCAN function — plus the slow-down mistakes to avoid on big sheets.

Read article →
Excel Intermediate Lesson 1: Named Ranges and Structured References

7 Jan 2025 · Excel · 2 min read

Excel Intermediate Lesson 1: Named Ranges and Structured References

Stop writing Sales!K2:K81 everywhere. Name your ranges or turn data into an Excel Table so formulas read like =SUM(Amount) and grow with new rows.

Read article →
Excel TEXT Function: 20 Format Codes You Will Actually Use

4 Jan 2025 · Excel Formulas · 3 min read

Excel TEXT Function: 20 Format Codes You Will Actually Use

The TEXT function turns numbers and dates into exactly the text you want: dd-mmm-yyyy, day names, leading zeros, lakh/crore commas, percentages and times. 20 format codes with examples and the traps.

Read article →
Power BI Intermediate Lesson 10: Project – Sales Performance vs Target

25 Dec 2024 · Power BI & DAX · 2 min read

Power BI Intermediate Lesson 10: Project – Sales Performance vs Target

Final project: targets without a relationship via TREATAS, % of target with status, months above average, FYTD trend and an RLS-ready one-page report.

Read article →
Older posts
Newer posts
← Previous Page1 … Page48 Page49 Page50 … 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? →