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

BITAND Function in Excel: Bitwise AND

BITAND Function in Excel: Bitwise AND featured illustration

9 Dec 2020 Β· Engineering Β· 1 min read

BITAND Function in Excel: Bitwise AND

BITAND compares numbers bit by bit. Useful for decoding status flags stored as one number.

Read article β†’
9 December 2020 by Atul Vij Engineering, Excel Functions A–Z

Google Workspace Lesson 1: Google Sheets for Excel Users

Google Workspace Lesson 1: Google Sheets for Excel Users featured illustration

5 Dec 2020 Β· Google Workspace Β· 2 min read

Google Workspace Lesson 1: Google Sheets for Excel Users

Move from Excel to Google Sheets without frustration: what works the same, what differs (shortcuts, menus, file types, recalculation), importing and exporting .xlsx, version…

Read article β†’
5 December 2020 by Atul Vij Google Workspace

DOLLARDE Function in Excel: Fractional Prices to Decimals

DOLLARDE Function in Excel: Fractional Prices to Decimals featured illustration

4 Dec 2020 Β· Excel Functions A–Z Β· 1 min read

DOLLARDE Function in Excel: Fractional Prices to Decimals

DOLLARDE converts prices quoted in fractions (like 1 and 2/16) into decimals β€” still seen in some bond and commodity feeds.

Read article β†’
4 December 2020 by Atul Vij Excel Functions A–Z, Financial

Indian Financial Year and Quarter From a Date in Excel (FY 2026-27, Q1–Q4)

Indian Financial Year and Quarter From a Date in Excel (FY 2026-27, Q1–Q4) featured illustration

30 Nov 2020 Β· Formula Combos Β· 2 min read

Indian Financial Year and Quarter From a Date in Excel (FY 2026-27, Q1–Q4)

Turn any date into the Indian financial year (April–March) like "FY 2026-27" or "FY27", the fiscal quarter Q1–Q4, the fiscal month number and FY…

Read article β†’
30 November 2020 by Atul Vij Formula Combos

ISPMT Function in Excel: Interest on Equal-Principal Loans

ISPMT Function in Excel: Interest on Equal-Principal Loans featured illustration

29 Nov 2020 Β· Excel Functions A–Z Β· 1 min read

ISPMT Function in Excel: Interest on Equal-Principal Loans

ISPMT calculates interest for a loan where the principal is repaid in equal parts (not an EMI). Note the period argument starts at 0.

Read article β†’
29 November 2020 by Atul Vij Excel Functions A–Z, Financial

LENB Function in Excel: Length in Bytes

LENB Function in Excel: Length in Bytes featured illustration

25 Nov 2020 Β· Excel Functions A–Z Β· 1 min read

LENB Function in Excel: Length in Bytes

LENB returns the number of bytes; identical to LEN in English setups, double for East Asian characters when a DBCS language is set.

Read article β†’
25 November 2020 by Atul Vij Excel Functions A–Z, Text

DURATION Function in Excel: How Sensitive a Bond Is to Rates

DURATION Function in Excel: How Sensitive a Bond Is to Rates featured illustration

24 Nov 2020 Β· Excel Functions A–Z Β· 1 min read

DURATION Function in Excel: How Sensitive a Bond Is to Rates

DURATION returns Macaulay duration in years. Roughly, a bond with duration 7 loses about 7% in price if rates rise 1% β€” which is…

Read article β†’
24 November 2020 by Atul Vij Excel Functions A–Z, Financial

Google Workspace Lesson 2: Google Docs Essentials

Google Workspace Lesson 2: Google Docs Essentials featured illustration

16 Nov 2020 Β· Google Workspace Β· 2 min read

Google Workspace Lesson 2: Google Docs Essentials

Use Google Docs well: headings and outline, suggesting mode instead of track changes, comments and assignments, smart chips, templates, voice typing, and exporting to…

Read article β†’
16 November 2020 by Atul Vij Google Workspace

NOMINAL Function in Excel: Effective Rate Back to Nominal

NOMINAL Function in Excel: Effective Rate Back to Nominal featured illustration

14 Nov 2020 Β· Excel Functions A–Z Β· 1 min read

NOMINAL Function in Excel: Effective Rate Back to Nominal

NOMINAL reverses EFFECT: it tells you the quoted annual rate behind an effective yield.

Read article β†’
14 November 2020 by Atul Vij Excel Functions A–Z, Financial

Slow Laptop? A 30-Minute Checklist Before You Buy a New One

Slow Laptop? A 30-Minute Checklist Before You Buy a New One featured illustration

10 Nov 2020 Β· Tech Tips Β· 3 min read

Slow Laptop? A 30-Minute Checklist Before You Buy a New One

A practical order of checks for a slow Windows laptop: startup apps, disk space, storage type, RAM use, browser tabs, updates and overheating —…

Read article β†’
10 November 2020 by Atul Vij Tech Tips

Protect Excel Sheets and Workbooks the Right Way

Protect Excel Sheets and Workbooks the Right Way

30 Oct 2020 Β· Excel Formulas Β· 3 min read

Protect Excel Sheets and Workbooks the Right Way

Lock formulas and leave inputs editable: unlock input cells, protect the sheet with the right options, hide formulas, protect workbook structure, allow ranges for…

Read article β†’
30 October 2020 by Atul Vij Excel Formulas

MDETERM Function in Excel: Determinant of a Matrix

MDETERM Function in Excel: Determinant of a Matrix featured illustration

20 Oct 2020 Β· Excel Functions A–Z Β· 1 min read

MDETERM Function in Excel: Determinant of a Matrix

MDETERM returns the determinant. Zero means the equations have no unique solution.

Read article β†’
20 October 2020 by Atul Vij Excel Functions A–Z, Math & Trig

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? β†’