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 for Finance Lesson 8: Financial Ratios From the P&L and Balance Sheet

16 Aug 2024 · Excel for Finance · 2 min read

Excel for Finance Lesson 8: Financial Ratios From the P&L and Balance Sheet

Calculate and read the key ratios in Excel: gross and net margin, current and quick ratio, debt-equity, interest coverage, debtor and inventory days, ROE and growth, with a two-year comparison.

Read article →
Excel for Finance Lesson 7: Fixed Asset Register and Depreciation

15 Aug 2024 · Excel for Finance · 2 min read

Excel for Finance Lesson 7: Fixed Asset Register and Depreciation

Keep a fixed asset register in Excel: SLM depreciation with SLN, WDV at block rates, months of use in the first year, the half-rate idea for assets used under 180 days, and closing WDV.

Read article →
Excel for Finance Lesson 6: Budget vs Actual With Variances

14 Aug 2024 · Excel for Finance · 2 min read

Excel for Finance Lesson 6: Budget vs Actual With Variances

Build a budget vs actual report: variance and variance %, favourable/adverse logic that differs for income and costs, conditional formatting, largest variances, and a short commentary layout.

Read article →
Excel for Finance Lesson 5: 13-Week Cash Flow Forecast

13 Aug 2024 · Excel for Finance · 2 min read

Excel for Finance Lesson 5: 13-Week Cash Flow Forecast

Build a rolling 13-week cash flow forecast in Excel: weekly collections and payments, running closing balance, minimum-cash alerts, the lowest point, and how to roll it forward each week.

Read article →
RECEIVED Function in Excel: Amount Received at Maturity

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

RECEIVED Function in Excel: Amount Received at Maturity

FinancialLevel: ExpertAvailable in: Excel 2007+RECEIVED calculates what you get back at maturity for a discounted security.Syntax=RECEIVED(settlement.

Read article →
PDURATION Function in Excel: Years Needed to Reach a Target

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

PDURATION Function in Excel: Years Needed to Reach a Target

PDURATION returns how many periods an investment needs to grow to a target at a given rate (lump sum, no regular payments).

Read article →
HARMEAN Function in Excel: The Right Average for Rates

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

HARMEAN Function in Excel: The Right Average for Rates

HARMEAN averages rates properly. Drive 60 km/h one way and 40 km/h back, and your average speed is 48, not 50.

Read article →
SEC Function in Excel: Secant

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

SEC Function in Excel: Secant

Maths & trigLevel: ExpertAvailable in: Excel 2013+SEC returns 1/COS(x).Syntax=SEC(number)ArgumentWhat it meansnumberValue (angles in.

Read article →
GEOMEAN Function in Excel: Average Growth Rate

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

GEOMEAN Function in Excel: Average Growth Rate

GEOMEAN multiplies values and takes the n-th root. For growth rates it gives the honest average: +50% followed by −50% is not an average of 0%, you lost a quarter.

Read article →
Remove Duplicates in Excel: 3 Quick Ways (and Which to Use)

14 Jul 2024 · Excel Formulas · 3 min read

Remove Duplicates in Excel: 3 Quick Ways (and Which to Use)

Remove or find duplicates in Excel three ways: the Remove Duplicates button, Advanced Filter unique records, and UNIQUE/COUNTIF formulas. Which to use when, how to keep the original data, and why spaces and case fool them.

Read article →
INTRATE Function in Excel: Interest Rate of a Fully Invested Security

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

INTRATE Function in Excel: Interest Rate of a Fully Invested Security

INTRATE returns the annualised return when you invest an amount and receive a larger amount at maturity, with nothing in between.

Read article →
NPER Function in Excel: How Many Payments Until Paid Off

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

NPER Function in Excel: How Many Payments Until Paid Off

NPER returns the number of periods needed to repay a loan or reach a savings goal.

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