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

R Lesson 1: Install R and RStudio

R Lesson 1: Install R and RStudio featured illustration

15 Feb 2018 · R · 1 min read

R Lesson 1: Install R and RStudio

Install R and RStudio, find your way around the four panes, run code in the console and scripts, install packages, and set a project…

Read article →
15 February 2018 by Atul Vij R

Power Pivot and DAX: Your First Data Model and Measures

Power Pivot and DAX: Your First Data Model and Measures featured illustration

13 Feb 2018 · Power Query & Pivots · 2 min read

Power Pivot and DAX: Your First Data Model and Measures

Start with Power Pivot in Excel: load tables to the Data Model, create relationships, write first DAX measures (SUM, DIVIDE, CALCULATE), build a pivot…

Read article →
13 February 2018 by Atul Vij Power Query & Pivots

PERCENTILE Function in Excel: k-th Percentile (Older Name)

PERCENTILE Function in Excel: k-th Percentile (Older Name) featured illustration

8 Feb 2018 · Excel Functions A–Z · 1 min read

PERCENTILE Function in Excel: k-th Percentile (Older Name)

PERCENTILE returns the k-th percentile (inclusive). It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but…

Read article →
8 February 2018 by Atul Vij Excel Functions A–Z, Statistical

CORREL Function in Excel: How Strongly Two Things Move Together

CORREL Function in Excel: How Strongly Two Things Move Together featured illustration

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

CORREL Function in Excel: How Strongly Two Things Move Together

CORREL returns a number between −1 and 1: near 1 means both rise together, near −1 means one falls as the other rises, near…

Read article →
6 February 2018 by Atul Vij Excel Functions A–Z, Statistical

PERCENTILE.INC Function in Excel: Value at a Percentile (e.g. 90th)

PERCENTILE.INC Function in Excel: Value at a Percentile (e.g. 90th) featured illustration

30 Jan 2018 · Excel Functions A–Z · 1 min read

PERCENTILE.INC Function in Excel: Value at a Percentile (e.g. 90th)

PERCENTILE.INC returns the value below which a given percentage of data falls — for salary bands, delivery-time targets and outliers.

Read article →
30 January 2018 by Atul Vij Excel Functions A–Z, Statistical

STDEV.S Function in Excel: How Spread Out Are the Numbers?

STDEV.S Function in Excel: How Spread Out Are the Numbers? featured illustration

23 Jan 2018 · Excel Functions A–Z · 1 min read

STDEV.S Function in Excel: How Spread Out Are the Numbers?

STDEV.S measures how far values typically sit from the average (sample standard deviation). A small value means consistent; a large one means volatile.

Read article →
23 January 2018 by Atul Vij Excel Functions A–Z, Statistical

POWER Function in Excel: Raise to a Power (and Growth Rates)

POWER Function in Excel: Raise to a Power (and Growth Rates) featured illustration

19 Dec 2017 · Excel Functions A–Z · 1 min read

POWER Function in Excel: Raise to a Power (and Growth Rates)

POWER raises a number to a power; the ^ operator does the same. Its most useful business job is CAGR.

Read article →
19 December 2017 by Atul Vij Excel Functions A–Z, Math & Trig

FLOOR.MATH Function in Excel: Round Down to a Multiple

FLOOR.MATH Function in Excel: Round Down to a Multiple featured illustration

12 Dec 2017 · Excel Functions A–Z · 1 min read

FLOOR.MATH Function in Excel: Round Down to a Multiple

FLOOR.MATH rounds down to the nearest multiple — slabs, time buckets and whole units.

Read article →
12 December 2017 by Atul Vij Excel Functions A–Z, Math & Trig

CEILING.MATH Function in Excel: Round Up to a Multiple

CEILING.MATH Function in Excel: Round Up to a Multiple featured illustration

5 Dec 2017 · Excel Functions A–Z · 1 min read

CEILING.MATH Function in Excel: Round Up to a Multiple

CEILING.MATH rounds up to the next multiple; FLOOR.MATH rounds down. Great for pricing and pack sizes.

Read article →
5 December 2017 by Atul Vij Excel Functions A–Z, Math & Trig

TRUNC Function in Excel: Cut Off Decimals Without Rounding

TRUNC Function in Excel: Cut Off Decimals Without Rounding featured illustration

28 Nov 2017 · Excel Functions A–Z · 1 min read

TRUNC Function in Excel: Cut Off Decimals Without Rounding

TRUNC drops digits after a given point, moving towards zero. Unlike INT, TRUNC(−8.9) is −8.

Read article →
28 November 2017 by Atul Vij Excel Functions A–Z, Math & Trig

QUOTIENT Function in Excel: Whole-Number Division

QUOTIENT Function in Excel: Whole-Number Division featured illustration

21 Nov 2017 · Excel Functions A–Z · 1 min read

QUOTIENT Function in Excel: Whole-Number Division

QUOTIENT returns only the integer part of a division; MOD returns the remainder.

Read article →
21 November 2017 by Atul Vij Excel Functions A–Z, Math & Trig

Word Track Changes and Compare: Review Documents Like a Pro

Word Track Changes and Compare: Review Documents Like a Pro featured illustration

8 Nov 2017 · Word · 1 min read

Word Track Changes and Compare: Review Documents Like a Pro

Use Track Changes, comments, Accept/Reject and Compare Documents in Microsoft Word to review contracts and reports — plus how to remove hidden tracked changes…

Read article →
8 November 2017 by Atul Vij Word

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