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
COVARIANCE.P Function in Excel: Covariance of a Whole Population

23 Dec 2021 · Excel Functions A–Z · 1 min read

COVARIANCE.P Function in Excel: Covariance of a Whole Population

COVARIANCE.P measures how two complete data sets move together, dividing by n (COVARIANCE.S divides by n-1).

Read article →
XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version

22 Dec 2021 · Formula Combos · 3 min read

XLOOKUP with Two (or More) Criteria — Plus the INDEX-MATCH Version

Look up a value using two conditions — product AND region, or employee AND month — with XLOOKUP, INDEX-MATCH, or a helper column. With examples and pitfalls.

Read article →
PPMT Function in Excel: Principal Part of an EMI

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

PPMT Function in Excel: Principal Part of an EMI

FinancialLevel: ExpertAvailable in: Excel 2007+PPMT returns the principal repaid by a specific EMI.Syntax=PPMT(rate, per, nper, pv, [fv].

Read article →
Power Automate Lesson 8: Error Handling, Run History and Good Habits

28 Nov 2021 · Power Automate · 2 min read

Power Automate Lesson 8: Error Handling, Run History and Good Habits

Keep flows reliable: run history, Configure run after for failure branches, scopes for try/catch, notifications on failure, naming, ownership and documentation.

Read article →
Power Automate Lesson 6: Forms to Excel and Teams

26 Nov 2021 · Power Automate · 1 min read

Power Automate Lesson 6: Forms to Excel and Teams

Send Microsoft Forms responses into an Excel table and post a summary to a Teams channel: get response details, add a row, adaptive messages and handling file uploads.

Read article →
Power Automate Lesson 5: Approvals

25 Nov 2021 · Power Automate · 1 min read

Power Automate Lesson 5: Approvals

Build an approval flow: start and wait for an approval, approve from email, Teams or mobile, branch on the outcome, and record decisions in Excel or SharePoint.

Read article →
Power Automate Lesson 2: Your First Cloud Flow — Email Alerts

22 Nov 2021 · Power Automate · 2 min read

Power Automate Lesson 2: Your First Cloud Flow — Email Alerts

Build a flow that sends a Teams or mobile notification when an important email arrives: trigger conditions, dynamic content, testing and turning flows on and off.

Read article →
Power Automate Lesson 1: What Power Automate Is (Cloud vs Desktop)

21 Nov 2021 · Power Automate · 1 min read

Power Automate Lesson 1: What Power Automate Is (Cloud vs Desktop)

Understand Power Automate: cloud flows vs desktop flows, triggers and actions, connectors, licences included with Microsoft 365, and what to automate first.

Read article →
Power BI Lesson 2: The Data Model — Facts, Dimensions and a Star Schema

9 Nov 2021 · Power BI & DAX · 2 min read

Power BI Lesson 2: The Data Model — Facts, Dimensions and a Star Schema

Design a Power BI model that works: fact tables vs dimension tables, why a star schema beats one big flat table, keys, a Calendar dimension, and hiding columns report users don’t need.

Read article →
Power BI Lesson 6: CALCULATE and Filter Context

9 Nov 2021 · Power BI & DAX · 2 min read

Power BI Lesson 6: CALCULATE and Filter Context

Understand filter context, then change it with CALCULATE: sales for one category, ignore a filter with ALL and REMOVEFILTERS, share of total, and the patterns behind most advanced DAX.

Read article →
Power BI Data Modelling: Build a Star Schema (and Why Your Report Is Slow Without One)

2 Nov 2021 · Power BI & DAX · 3 min read

Power BI Data Modelling: Build a Star Schema (and Why Your Report Is Slow Without One)

Learn the star schema for Power BI: fact and dimension tables, one-to-many relationships, filter direction, a proper date table, and how to turn a flat Excel export into a fast model.

Read article →
DAX CALCULATE Explained: Filter Context Without the Headache

29 Oct 2021 · Power BI & DAX · 3 min read

DAX CALCULATE Explained: Filter Context Without the Headache

A deep, practical guide to CALCULATE in Power BI and Power Pivot: filter context, row context, ALL, REMOVEFILTERS, KEEPFILTERS, time intelligence and the patterns you will reuse every week.

Read article →
Older posts
Newer posts
← Previous Page1 … Page73 Page74 Page75 … 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? →