Skip to content

Popular topics

ExcelExcel VBAPower Query & PivotsExcel for FinanceAutomationSAP & OracleCodingAI & MLTech tipsWacky World

Recent posts

  • Basics of VBA / Macros Chapter – 81 (Userform Part-2)
  • Basics of VBA / Macros Chapter – 80 (Userform Part-1)
  • Basics of VBA / Macros Chapter – 79 (ActiveX Controls Part-8)
  • Basics of VBA / Macros Chapter – 68 (Application Object Part-1)
  • Basics of VBA / Macros Chapter – 51 (Time and Date Part-8)
  • Loan Amortization Schedule in Excel with Extra Payments: Step-by-Step Template & Formulas

🤯 Wacky fact of the day · Human Body

You blink around 15–20 times a minute.

Blinking spreads tears across the eye to keep it moist and clean. People blink much less when staring at screens, which can cause dry…

Why? How? →Source ↗

AJ's Techie & Wacky World

Excel, SAP, Oracle & automation tips — plus wacky facts

Skip to content
  • ✨ 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

Atul Vij

TRIM Function in Excel: Remove Extra Spaces

TRIM Function in Excel: Remove Extra Spaces featured illustration

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 →
18 February 2020 by Atul Vij Excel Functions A–Z, Text

Decision Trees in Python: A Model You Can Actually Read

Decision Trees in Python: A Model You Can Actually Read featured illustration

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…

Read article →
18 February 2020 by Atul Vij Machine Learning

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

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,…

Read article →
16 February 2020 by Atul Vij Automation

VDB Function in Excel: Depreciation for Any Span

VDB Function in Excel: Depreciation for Any Span featured illustration

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 →
12 February 2020 by Atul Vij Excel Functions A–Z, Financial

PI Function in Excel: The Value of π

PI Function in Excel: The Value of π featured illustration

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 →
9 February 2020 by Atul Vij Excel Functions A–Z, Math & Trig

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

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

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 →
6 February 2020 by Atul Vij Excel Functions A–Z, Financial

DDB Function in Excel: Double-Declining Depreciation

DDB Function in Excel: Double-Declining Depreciation featured illustration

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 →
31 January 2020 by Atul Vij Excel Functions A–Z, Financial

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

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

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 →
25 January 2020 by Atul Vij Date & Time, Excel Functions A–Z

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

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

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 →
19 January 2020 by Atul Vij Date & Time, Excel Functions A–Z

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

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

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 →
13 January 2020 by Atul Vij Date & Time, Excel Functions A–Z

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

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

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 →
17 December 2019 by Atul Vij Google Workspace

DOLLAR Function in Excel: Number as Currency Text

DOLLAR Function in Excel: Number as Currency Text featured illustration

14 Dec 2019 · Excel Functions A–Z · 1 min read

DOLLAR Function in Excel: Number as Currency Text

DOLLAR formats a number as currency text using your computer’s currency symbol. The name is historic — on an Indian-locale PC it shows ₹.

Read article →
14 December 2019 by Atul Vij Excel Functions A–Z, Text

Post navigation

← Older posts
Newer posts →
Proudly powered by WordPress | Theme: fiore by Caroline Moore.
© 2026 Atul Vij · AJ’s Techie & Wacky World
AboutProjectsFree ToolsContactPrivacyDisclaimerGitHub
Did you know?

Why? →