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 Lesson 18: Final Project — Build a Monthly Sales Report

12 Dec 2024 · Excel Formulas · 3 min read

Excel Lesson 18: Final Project — Build a Monthly Sales Report

Put the whole course together: turn raw orders into a one-page quarterly sales report with KPIs, region vs target with Met/Missed, a monthly chart, a product pivot, conditional formatting and print-ready layout.

Read article →
Excel Lesson 15: Data Validation and Drop-Down Lists

9 Dec 2024 · Excel Formulas · 3 min read

Excel Lesson 15: Data Validation and Drop-Down Lists

Stop typing mistakes before they happen: drop-down lists from a range or Table, whole-number and date limits, custom rules for PAN and mobile numbers, input messages, error alerts and circling invalid data.

Read article →
GAMMA Function in Excel: The Gamma Function

9 Dec 2024 · Excel Functions A–Z · 1 min read

GAMMA Function in Excel: The Gamma Function

StatisticsLevel: ExpertAvailable in: Excel 2013+GAMMA extends factorials to non-whole numbers: GAMMA(n) = (n-1)! for whole.

Read article →
Excel Lesson 14: Lookups — VLOOKUP and XLOOKUP

8 Dec 2024 · Excel Formulas · 3 min read

Excel Lesson 14: Lookups — VLOOKUP and XLOOKUP

Fetch a price, name or rate from another table: VLOOKUP exact match step by step, XLOOKUP (easier and more flexible), handling codes that aren’t found, looking up to the left, and approximate match for slabs.

Read article →
Google Search Operators Cheat Sheet: Find Anything Faster

8 Dec 2024 · Internet & Browser · 2 min read

Google Search Operators Cheat Sheet: Find Anything Faster

Search operators that make Google far more precise: exact phrases, site search, excluding words, file types, OR, number ranges and more — with practical examples.

Read article →
Excel Lesson 13: Dates — TODAY, EOMONTH, DATEDIF and Date Maths

7 Dec 2024 · Excel Formulas · 3 min read

Excel Lesson 13: Dates — TODAY, EOMONTH, DATEDIF and Date Maths

How Excel stores dates, adding days and months, due dates, month-end with EOMONTH, age and service with DATEDIF, working days with NETWORKDAYS, YEAR/MONTH/WEEKDAY, and the Indian financial year.

Read article →
Excel Lesson 12: Text Functions — LEFT, RIGHT, MID, TRIM, PROPER and More

6 Dec 2024 · Excel Formulas · 3 min read

Excel Lesson 12: Text Functions — LEFT, RIGHT, MID, TRIM, PROPER and More

Clean and split messy text: TRIM extra spaces, fix case with PROPER/UPPER/LOWER, cut pieces with LEFT, RIGHT and MID, find positions with FIND, replace with SUBSTITUTE, count with LEN and join with &.

Read article →
Excel Lesson 11: Absolute vs Relative References ($)

5 Dec 2024 · Excel Formulas · 3 min read

Excel Lesson 11: Absolute vs Relative References ($)

Why formulas break when copied, and how the $ sign fixes it: relative, absolute ($B$8) and mixed ($A2, B$1) references, the F4 shortcut, named cells, and a multiplication-table exercise that makes it click.

Read article →
Excel Lesson 10: Printing and Page Setup

4 Dec 2024 · Excel Formulas · 3 min read

Excel Lesson 10: Printing and Page Setup

Print Excel sheets that fit: Print Preview, orientation, Fit to page width, print area, repeating header rows, headers and footers with page numbers, page breaks and saving as PDF.

Read article →
MINA Function in Excel: Minimum Counting Text and TRUE/FALSE

4 Dec 2024 · Excel Functions A–Z · 1 min read

MINA Function in Excel: Minimum Counting Text and TRUE/FALSE

StatisticsLevel: IntermediateAvailable in: Excel 2007+MINA is MIN that also counts text as 0 and TRUE as 1, FALSE as 0.Syntax=MINA(value1, [value2].

Read article →
CALL Function in Excel: Call a DLL Procedure

2 Dec 2024 · Excel Functions A–Z · 1 min read

CALL Function in Excel: Call a DLL Procedure

CALL calls a procedure in a DLL or code resource. It is an old Excel 4.0 macro-era function, disabled by default for security and not usable from a normal worksheet cell in modern Excel.

Read article →
Excel Lesson 7: Sorting and Filtering Data

1 Dec 2024 · Excel Formulas · 4 min read

Excel Lesson 7: Sorting and Filtering Data

Sort by one or several columns, sort by date or a custom order, filter by values, numbers, dates, text and colour, read totals of filtered rows, and avoid the sort that scrambles your data.

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