Skip to content

AJ's Techie & Wacky World

  • ✨ 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
  • 📲 Get App
MDETERM Function in Excel: Determinant of a Matrix

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 →
Excel Data Validation: Stop Bad Data Before It Gets In

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, GSTIN and duplicates — plus input messages and finding invalid data.

Read article →
MINVERSE Function in Excel: Inverse of a Matrix

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 →
DEC2OCT Function in Excel: Decimal to Octal

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 →
MMULT Function in Excel: Multiply Matrices

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 →
Dependent Drop-Down Lists in Excel (State → City, Category → Item)

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 how to catch stale picks.

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

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 to schedule daily.

Read article →
KURT Function in Excel: How Heavy Are the Tails?

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 →
SKEW.P Function in Excel: Skewness of a Population

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 →
SKEW Function in Excel: Is the Data Lopsided?

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 the average above the median.

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

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 →
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 →
Older posts
Newer posts
← Previous Page1 … Page83 Page84 Page85 … Page107 Next →

AJ's Techie & Wacky World

Curated by Atul Vij • © 2026 • All Rights Reserved

About Courses Free Tools Templates Privacy Policy Contact GitHub
Did you know?

Why? →