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
YIELD Function in Excel: Bond Yield From Its Price

24 Feb 2020 · Excel Functions A–Z · 1 min read

YIELD Function in Excel: Bond Yield From Its Price

YIELD is the reverse of PRICE: what annual return you lock in if you buy at today’s price and hold to maturity.

Read article →
TRIM Function in Excel: Remove Extra Spaces

18 Feb 2020 · Excel Functions A–Z · 1 min read

TRIM Function in Excel: Remove Extra Spaces

TRIM removes leading and trailing spaces and reduces multiple spaces between words to one. Essential after copying data from websites and ERPs.

Read article →
Decision Trees in Python: A Model You Can Actually Read

18 Feb 2020 · Machine Learning · 3 min read

Decision Trees in Python: A Model You Can Actually Read

Train a decision tree classifier with scikit-learn, print its rules as plain if/else text, measure accuracy honestly with a test split, and avoid overfitting with max_depth.

Read article →
Which Automation Tool Should You Learn? VBA vs Python vs Power Automate vs SAP Scripting

16 Feb 2020 · Automation · 2 min read

Which Automation Tool Should You Learn? VBA vs Python vs Power Automate vs SAP Scripting

A practical guide to choosing between Excel VBA, Python, Power Automate and SAP GUI scripting for automating office work — based on the task, not the hype.

Read article →
VDB Function in Excel: Depreciation for Any Span

12 Feb 2020 · Excel Functions A–Z · 1 min read

VDB Function in Excel: Depreciation for Any Span

VDB returns declining-balance depreciation between any two periods and, by default, switches to straight-line when that gives more — as many tax rules expect.

Read article →
PI Function in Excel: The Value of π

9 Feb 2020 · Excel Functions A–Z · 1 min read

PI Function in Excel: The Value of π

PI returns 3.14159265358979, accurate to 15 digits. It takes no arguments but still needs the brackets.

Read article →
SYD Function in Excel: Sum-of-Years’ Digits Depreciation

6 Feb 2020 · Excel Functions A–Z · 1 min read

SYD Function in Excel: Sum-of-Years’ Digits Depreciation

SYD is another accelerated method, gentler than DDB. For a 5-year life the fractions are 5/15, 4/15, 3/15 and so on.

Read article →
DDB Function in Excel: Double-Declining Depreciation

31 Jan 2020 · Excel Functions A–Z · 1 min read

DDB Function in Excel: Double-Declining Depreciation

DDB front-loads depreciation: more in early years, less later. It suits laptops and vehicles that lose value fast.

Read article →
WORKDAY.INTL Function in Excel: Due Date With Your Own Weekend

25 Jan 2020 · Date & Time · 1 min read

WORKDAY.INTL Function in Excel: Due Date With Your Own Weekend

WORKDAY.INTL adds working days with a custom weekend — delivery or SLA dates for a six-day operation.

Read article →
NETWORKDAYS.INTL Function in Excel: Working Days With Your Own Weekend

19 Jan 2020 · Date & Time · 1 min read

NETWORKDAYS.INTL Function in Excel: Working Days With Your Own Weekend

NETWORKDAYS.INTL counts working days when your weekend is not Saturday–Sunday — a Sunday-only week, or a Friday–Saturday weekend in the Gulf.

Read article →
DAYS360 Function in Excel: Days on a 360-Day Year

13 Jan 2020 · Date & Time · 1 min read

DAYS360 Function in Excel: Days on a 360-Day Year

DAYS360 counts days as if every month had 30 — the convention some interest and bond calculations use.

Read article →
Google Sheets IMPORTRANGE: Pull Data From Another Sheet (and Filter It)

17 Dec 2019 · Google Workspace · 2 min read

Google Sheets IMPORTRANGE: Pull Data From Another Sheet (and Filter It)

Link Google Sheets files with IMPORTRANGE, grant access once, and combine it with QUERY to pull only the rows and columns you need.

Read article →
Older posts
Newer posts
← Previous Page1 … Page88 Page89 Page90 … 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? →