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

Excel Data Validation: Stop Bad Data Before It Gets In

Excel Data Validation: Stop Bad Data Before It Gets In featured illustration

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

Excel Data Validation: Stop Bad Data Before It Gets In

Use Excel Data Validation to block wrong entries: drop-down lists, whole numbers, date ranges, text length, and custom formula rules for PAN, mobile numbers,…

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

MINVERSE Function in Excel: Inverse of a Matrix

MINVERSE Function in Excel: Inverse of a Matrix featured illustration

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

MINVERSE Function in Excel: Inverse of a Matrix

MathLevel: ExpertAvailable in: Excel 2007+MINVERSE inverts a square matrix β€” with MMULT it solves simultaneous.

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

DEC2OCT Function in Excel: Decimal to Octal

DEC2OCT Function in Excel: Decimal to Octal featured illustration

13 Oct 2020 Β· Engineering Β· 1 min read

DEC2OCT Function in Excel: Decimal to Octal

DEC2OCT converts a decimal number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.

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

MMULT Function in Excel: Multiply Matrices

MMULT Function in Excel: Multiply Matrices featured illustration

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

MMULT Function in Excel: Multiply Matrices

MMULT multiplies two matrices. In practice it computes many weighted sums at once β€” quantities Γ— price lists for many orders.

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

Dependent Drop-Down Lists in Excel (State β†’ City, Category β†’ Item)

Dependent Drop-Down Lists in Excel (State β†’ City, Category β†’ Item) featured illustration

3 Oct 2020 Β· Formula Combos Β· 2 min read

Dependent Drop-Down Lists in Excel (State β†’ City, Category β†’ Item)

Make a second drop-down that changes with the first: INDIRECT with named ranges for any Excel, and FILTER+UNIQUE dynamic lists for Excel 365, plus…

Read article β†’
3 October 2020 by Atul Vij Formula Combos

Python: Pull Data From an API Into a Formatted Excel Report

Python: Pull Data From an API Into a Formatted Excel Report featured illustration

15 Sep 2020 Β· Python Automation Β· 1 min read

Python: Pull Data From an API Into a Formatted Excel Report

A complete Python script that calls a JSON API, reshapes the data with pandas, and writes a formatted Excel report with openpyxl β€” ready…

Read article β†’
15 September 2020 by Atul Vij Python Automation

KURT Function in Excel: How Heavy Are the Tails?

KURT Function in Excel: How Heavy Are the Tails? featured illustration

5 Sep 2020 Β· Excel Functions A–Z Β· 1 min read

KURT Function in Excel: How Heavy Are the Tails?

KURT measures whether data has more extreme values than a normal distribution (positive) or fewer (negative).

Read article β†’
5 September 2020 by Atul Vij Excel Functions A–Z, Statistical

SKEW.P Function in Excel: Skewness of a Population

SKEW.P Function in Excel: Skewness of a Population featured illustration

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

SKEW.P Function in Excel: Skewness of a Population

SKEW.P measures lopsidedness of a complete data set; SKEW is the sample version.

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

SKEW Function in Excel: Is the Data Lopsided?

SKEW Function in Excel: Is the Data Lopsided? featured illustration

31 Aug 2020 Β· Excel Functions A–Z Β· 1 min read

SKEW Function in Excel: Is the Data Lopsided?

SKEW is positive when a long tail stretches to the right β€” typical for salaries and order values, where a few big ones pull…

Read article β†’
31 August 2020 by Atul Vij Excel Functions A–Z, Statistical

COVARIANCE.S Function in Excel: Do Two Series Move Together?

COVARIANCE.S Function in Excel: Do Two Series Move Together? featured illustration

16 Aug 2020 Β· Excel Functions A–Z Β· 1 min read

COVARIANCE.S Function in Excel: Do Two Series Move Together?

COVARIANCE.S measures whether two variables rise and fall together. Its size depends on units, so CORREL is easier to read.

Read article β†’
16 August 2020 by Atul Vij Excel Functions A–Z, Statistical

Why Learn Rust? Your First Rust Program, Explained for Beginners

Why Learn Rust? Your First Rust Program, Explained for Beginners

8 Aug 2020 Β· Rust Β· 2 min read

Why Learn Rust? Your First Rust Program, Explained for Beginners

What makes Rust different β€” speed without crashes β€” and a gentle walk through your first program: variables, ownership, and a tiny CSV-style summary.

Read article β†’
8 August 2020 by Atul Vij Rust

MAXA Function in Excel: Largest Value, Logicals Included

MAXA Function in Excel: Largest Value, Logicals Included featured illustration

1 Aug 2020 Β· Excel Functions A–Z Β· 1 min read

MAXA Function in Excel: Largest Value, Logicals Included

StatisticsLevel: IntermediateAvailable in: Excel 2007+MAXA is MAX that counts TRUE as 1 and text as 0.Syntax=MAXA(value1, [value2], ...)ArgumentWhat it.

Read article β†’
1 August 2020 by Atul Vij Excel Functions A–Z, Statistical

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