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
Look Up the 2nd, 3rd or Nth Match in Excel

10 Jul 2024 · Formula Combos · 2 min read

Look Up the 2nd, 3rd or Nth Match in Excel

VLOOKUP only finds the first match. Return a customer’s Nth order, the first N rows, the last match or the Nth largest per group with FILTER+INDEX, SMALL+IF, AGGREGATE and a helper-column method.

Read article →
PV Function in Excel: What a Future Amount Is Worth Today

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

PV Function in Excel: What a Future Amount Is Worth Today

PV returns today's value of future payments at a discount rate — how much loan an EMI can support, or what an annuity is worth.

Read article →
RRI Function in Excel: Equivalent Annual Growth Rate (CAGR)

8 Jul 2024 · Excel Functions A–Z · 1 min read

RRI Function in Excel: Equivalent Annual Growth Rate (CAGR)

RRI returns the constant growth rate needed to go from a start value to an end value — i.e. CAGR in one function.

Read article →
FVSCHEDULE Function in Excel: Growth at Changing Rates

7 Jul 2024 · Excel Functions A–Z · 1 min read

FVSCHEDULE Function in Excel: Growth at Changing Rates

FVSCHEDULE compounds an amount through a list of different rates — FD renewals, varying annual returns.

Read article →
XNPV Function in Excel: NPV for Cash Flows on Specific Dates

6 Jul 2024 · Excel Functions A–Z · 1 min read

XNPV Function in Excel: NPV for Cash Flows on Specific Dates

XNPV discounts cash flows that happen on irregular dates — more accurate than NPV for real projects.

Read article →
SAP as Business Suite

6 Jul 2024 · SAP · 4 min read

SAP as Business Suite

SAP Business Suite is a collection of fully integrated applications such as SAP CRM, ERP, PLM, SRM, and SCM modules.

Read article →
FV Function in Excel: Future Value of Savings or SIPs

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

FV Function in Excel: Future Value of Savings or SIPs

FinancialLevel: IntermediateAvailable in: Excel 2007+FV returns what regular investments (like a SIP or RD) grow to at a fixed rate.Syntax=FV(rate, nper.

Read article →
Outlook Intermediate Lesson 8: Power Automate Flows for Email

25 Jun 2024 · Outlook · 1 min read

Outlook Intermediate Lesson 8: Power Automate Flows for Email

Save invoice attachments to OneDrive automatically, get a Teams message for VIP mail and log orders to Excel with Power Automate cloud flows: no macros, works when your PC is off.

Read article →
IRR Function in Excel: Return of Regular (Periodic) Cash Flows

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

IRR Function in Excel: Return of Regular (Periodic) Cash Flows

IRR returns the rate at which the NPV of regular, equally spaced cash flows is zero. For irregular dates use XIRR.

Read article →
Outlook Intermediate Lesson 7: Safe VBA Macros – Save Attachments, Unread Report, Template Replies

24 Jun 2024 · Outlook · 2 min read

Outlook Intermediate Lesson 7: Safe VBA Macros – Save Attachments, Unread Report, Template Replies

Three Outlook VBA macros that only read and save: save attachments of selected mails with the date in the file name, an unread-mail report and a template reply.

Read article →
Outlook Intermediate Lesson 6: Calendar Skills for Teams

23 Jun 2024 · Outlook · 1 min read

Outlook Intermediate Lesson 6: Calendar Skills for Teams

Scheduling Assistant and room finder, shared and delegated calendars, time zones for overseas calls, Bookings pages and meeting habits that save time.

Read article →
Outlook Intermediate Lesson 5: The 4D Inbox System and Category Color Management

22 Jun 2024 · Outlook · 2 min read

Outlook Intermediate Lesson 5: The 4D Inbox System and Category Color Management

Set up a simple system with five colour categories and flag dates, Quick Steps and the daily and weekly routine that keeps the inbox near zero.

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