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

SQL for Excel Users: 10 Queries That Replace Everyday Excel Work

SQL for Excel Users: 10 Queries That Replace Everyday Excel Work

15 Mar 2020 · SQL · 3 min read

SQL for Excel Users: 10 Queries That Replace Everyday Excel Work

Learn SQL through tasks you already do in Excel — filters, sorting, pivot tables, VLOOKUP and remove duplicates — with 10 queries you can…

Read article →
15 March 2020 by Atul Vij SQL

UPPER Function in Excel: Convert Text to Capitals

UPPER Function in Excel: Convert Text to Capitals featured illustration

15 Mar 2020 · Excel Functions A–Z · 1 min read

UPPER Function in Excel: Convert Text to Capitals

UPPER makes text all capitals; LOWER makes it all small letters. Useful for codes, PAN and GSTIN that must be uppercase.

Read article →
15 March 2020 by Atul Vij Excel Functions A–Z, Text

Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)

Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)

13 Mar 2020 · Formula Combos · 3 min read

Return ALL Matches in One Cell: TEXTJOIN + FILTER (the VLOOKUP Upgrade)

VLOOKUP returns only the first match. Combine TEXTJOIN, UNIQUE and FILTER to list every matching value in one cell — plus a version for…

Read article →
13 March 2020 by Atul Vij Formula Combos

REPLACE Function in Excel: Replace Characters by Position

REPLACE Function in Excel: Replace Characters by Position featured illustration

11 Mar 2020 · Excel Functions A–Z · 1 min read

REPLACE Function in Excel: Replace Characters by Position

TextLevel: IntermediateAvailable in: Excel 2007+REPLACE swaps characters at a given position — useful for masking.Syntax=REPLACE(old_text, start_num.

Read article →
11 March 2020 by Atul Vij Excel Functions A–Z, Text

PRICE Function in Excel: Bond Price From Its Yield

PRICE Function in Excel: Bond Price From Its Yield featured illustration

10 Mar 2020 · Excel Functions A–Z · 1 min read

PRICE Function in Excel: Bond Price From Its Yield

PRICE returns a bond’s price per 100 face value. When market yield rises above the coupon, price falls below 100 — the see-saw every…

Read article →
10 March 2020 by Atul Vij Excel Functions A–Z, Financial

CLEAN Function in Excel: Remove Non-Printing Characters

CLEAN Function in Excel: Remove Non-Printing Characters featured illustration

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

CLEAN Function in Excel: Remove Non-Printing Characters

CLEAN removes invisible control characters (like line breaks from system exports) that break lookups and look like spaces.

Read article →
6 March 2020 by Atul Vij Excel Functions A–Z, Text

VLOOKUP Approximate Match: Tax Slabs, Commissions and Grades

VLOOKUP Approximate Match: Tax Slabs, Commissions and Grades featured illustration

4 Mar 2020 · Excel Formulas · 2 min read

VLOOKUP Approximate Match: Tax Slabs, Commissions and Grades

Use approximate-match lookups for slabs and bands: how TRUE/-1 matching works, building a bands table, commission and grade examples, progressive tax slabs with SUMPRODUCT,…

Read article →
4 March 2020 by Atul Vij Excel Formulas

SUBSTITUTE Function in Excel: Replace Specific Text

SUBSTITUTE Function in Excel: Replace Specific Text featured illustration

2 Mar 2020 · Excel Functions A–Z · 1 min read

SUBSTITUTE Function in Excel: Replace Specific Text

SUBSTITUTE replaces existing text with new text — all occurrences or just the n-th one.

Read article →
2 March 2020 by Atul Vij Excel Functions A–Z, Text

ACCRINT Function in Excel: Interest Earned Since Last Coupon

ACCRINT Function in Excel: Interest Earned Since Last Coupon featured illustration

1 Mar 2020 · Excel Functions A–Z · 1 min read

ACCRINT Function in Excel: Interest Earned Since Last Coupon

ACCRINT calculates interest that has built up on a bond — the amount a buyer pays the seller on top of the quoted price.

Read article →
1 March 2020 by Atul Vij Excel Functions A–Z, Financial

PROPER Function in Excel: Capitalise Each Word

PROPER Function in Excel: Capitalise Each Word featured illustration

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

PROPER Function in Excel: Capitalise Each Word

PROPER capitalises the first letter of each word; UPPER and LOWER change the whole text.

Read article →
27 February 2020 by Atul Vij Excel Functions A–Z, Text

CODE Function in Excel: Character Code of the First Letter

CODE Function in Excel: Character Code of the First Letter featured illustration

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

CODE Function in Excel: Character Code of the First Letter

CODE returns the number of the first character. It is the detective tool for “invisible” characters that break lookups: a non-breaking space shows up…

Read article →
26 February 2020 by Atul Vij Excel Functions A–Z, Text

YIELD Function in Excel: Bond Yield From Its Price

YIELD Function in Excel: Bond Yield From Its Price featured illustration

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

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? →