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
MIRR Function in Excel: IRR With Realistic Reinvestment

22 Jun 2024 · Excel Functions A–Z · 1 min read

MIRR Function in Excel: IRR With Realistic Reinvestment

MIRR fixes IRR's optimistic assumption that cash is reinvested at the IRR itself, using separate finance and reinvestment rates.

Read article →
SUMIFS Between Two Dates and With OR Conditions in Excel

21 Jun 2024 · Formula Combos · 2 min read

SUMIFS Between Two Dates and With OR Conditions in Excel

Total sales between two dates, for this month, or for “North OR East”: SUMIFS with date operators, array constants, SUMPRODUCT and FILTER, with the classic date mistakes fixed.

Read article →
Outlook Intermediate Lesson 4: Email Productivity with Quick Steps, Quick Parts and Templates

21 Jun 2024 · Outlook · 2 min read

Outlook Intermediate Lesson 4: Email Productivity with Quick Steps, Quick Parts and Templates

Stop retyping the same emails: save .oft templates, insert Quick Parts paragraphs, use My Templates in new Outlook and fill-in placeholders for payment reminders and follow-ups.

Read article →
Outlook Intermediate Lesson 3: Custom Views and Conditional Color Formatting

20 Jun 2024 · Outlook · 2 min read

Outlook Intermediate Lesson 3: Custom Views and Conditional Color Formatting

Make important mail stand out: colour mail from your manager, show attachment size and category columns, group by conversation or sender, and save custom views.

Read article →
Outlook Intermediate Lesson 2: Advanced Search Operators and Persistent Search Folders

19 Jun 2024 · Outlook · 2 min read

Outlook Intermediate Lesson 2: Advanced Search Operators and Persistent Search Folders

Find any mail in seconds with from:, hasattachments:, received: and AND/OR/NOT, and save repeated searches as Search Folders that update themselves.

Read article →
Outlook Intermediate Lesson 1: Rules That Work – Conditions, Exceptions and Order

18 Jun 2024 · Outlook · 2 min read

Outlook Intermediate Lesson 1: Rules That Work – Conditions, Exceptions and Order

Design Outlook rules that don't fight each other: conditions and exceptions, rule order, "stop processing more rules", and server-side vs client-only rules.

Read article →
XIRR Function in Excel: Real Return on SIPs and Irregular Cash Flows

18 Jun 2024 · Excel Functions A–Z · 1 min read

XIRR Function in Excel: Real Return on SIPs and Irregular Cash Flows

XIRR returns the annualised return for cash flows on specific dates — the right way to measure SIP and mutual-fund returns.

Read article →
Get the Latest Record for Each Customer in Excel (Last Price, Last Order, Last Status)

12 Jun 2024 · Formula Combos · 2 min read

Get the Latest Record for Each Customer in Excel (Last Price, Last Order, Last Status)

Find each customer’s most recent order date, last price paid or latest status with MAXIFS, XLOOKUP search-from-last, SORTBY+UNIQUE and LOOKUP(2,1/…) — so duplicates show only the newest row.

Read article →
Copy Text from Any Image or Screenshot on Windows

7 Jun 2024 · Windows · 1 min read

Copy Text from Any Image or Screenshot on Windows

Grab text from screenshots, scanned PDFs, videos or error dialogs on Windows — using the Snipping Tool’s text actions or Microsoft PowerToys Text Extractor.

Read article →
Why Is the “Save” Icon a Floppy Disk? A Short History

6 Jun 2024 · Fun Facts · 2 min read

Why Is the “Save” Icon a Floppy Disk? A Short History

The floppy disk save icon outlived the floppy disk by decades. Where the 3.5-inch disk came from, why it became the save symbol, and why it will probably never change.

Read article →
SAP Basics Lesson 8: SAP S/4HANA and Fiori Basics

2 Jun 2024 · SAP · 2 min read

SAP Basics Lesson 8: SAP S/4HANA and Fiori Basics

What changes with S/4HANA: the Universal Journal, Business Partner, Fiori launchpad apps, analytical apps, personalisation, and how classic GUI and Fiori coexist.

Read article →
Windows 11: 12 Hidden Features Worth Turning On

1 Jun 2024 · Windows · 3 min read

Windows 11: 12 Hidden Features Worth Turning On

Snap layouts, clipboard history, Focus sessions, voice typing, Live Captions and more — twelve Windows 11 features that save time every day.

Read article →
Older posts
Newer posts
← Previous Page1 … Page55 Page56 Page57 … 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? →