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
Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDE

9 Jan 2019 · Power BI & DAX · 2 min read

Power BI Lesson 5: Your First DAX — SUM, COUNTROWS, DIVIDE

Write the core measures every report needs: total sales with SUMX, cost and margin, order counts with COUNTROWS, distinct counts, averages, and safe ratios with DIVIDE, plus formatting and variables.

Read article →
Power BI Lesson 4: Measures vs Calculated Columns

8 Jan 2019 · Power BI & DAX · 2 min read

Power BI Lesson 4: Measures vs Calculated Columns

Understand the difference that confuses every beginner: calculated columns compute per row and are stored; measures compute on the fly in filter context. When to use each, with examples.

Read article →
Power BI Lesson 3: Relationships and Filter Direction

7 Jan 2019 · Power BI & DAX · 2 min read

Power BI Lesson 3: Relationships and Filter Direction

Connect tables in the Model view: one-to-many relationships, cardinality, single vs both cross-filter direction, active and inactive relationships, and fixing the blank row and wrong totals.

Read article →
Build a Data Entry Form in Excel VBA (UserForm Step by Step)

13 Nov 2018 · Excel VBA · 2 min read

Build a Data Entry Form in Excel VBA (UserForm Step by Step)

Create a VBA UserForm for clean data entry: design the form, fill drop-downs from a table, validate inputs, add rows to an Excel Table, clear the form and open it from a button.

Read article →
STDEV Function in Excel: Sample Standard Deviation (Older Name)

28 Aug 2018 · Excel Functions A–Z · 1 min read

STDEV Function in Excel: Sample Standard Deviation (Older Name)

STDEV estimates the standard deviation from a sample. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still calculate, but Microsoft recommends STDEV.S for new work. Both give the same result.

Read article →
DB Function in Excel: Declining-Balance Depreciation

21 Aug 2018 · Excel Functions A–Z · 1 min read

DB Function in Excel: Declining-Balance Depreciation

DB calculates depreciation using a fixed-rate declining balance derived from cost, salvage and life, with an optional first-year month count.

Read article →
SLN Function in Excel: Straight-Line Depreciation

14 Aug 2018 · Excel Functions A–Z · 1 min read

SLN Function in Excel: Straight-Line Depreciation

FinancialLevel: IntermediateAvailable in: Excel 2007+SLN returns equal depreciation for each period of an asset's life.Syntax=SLN(cost, salvage.

Read article →
SQL GROUP BY and HAVING: Pivot Tables Written in SQL

7 Aug 2018 · SQL · 1 min read

SQL GROUP BY and HAVING: Pivot Tables Written in SQL

Summarise data with SQL GROUP BY, filter groups with HAVING, and understand the difference from WHERE — explained for Excel users with pivot-table comparisons.

Read article →
CUMIPMT Function in Excel: Total Interest Over a Range of EMIs

24 Jul 2018 · Excel Functions A–Z · 1 min read

CUMIPMT Function in Excel: Total Interest Over a Range of EMIs

CUMIPMT totals the interest paid between two payment numbers — e.g. for one financial year. CUMPRINC does the same for principal.

Read article →
Linux Command Line for Windows Users: 20 Commands to Survive a Server

17 Jul 2018 · Dev Tools · 2 min read

Linux Command Line for Windows Users: 20 Commands to Survive a Server

The 20 Linux terminal commands you need when you first log in to a server — moving around, reading logs, finding files, permissions and processes — with Windows equivalents.

Read article →
IPMT Function in Excel: Interest Part of an EMI

10 Jul 2018 · Excel Functions A–Z · 1 min read

IPMT Function in Excel: Interest Part of an EMI

IPMT returns how much of a given EMI is interest; PPMT returns the principal part. Together they always equal PMT.

Read article →
SQRT Function in Excel: Square Root

3 Jul 2018 · Excel Functions A–Z · 1 min read

SQRT Function in Excel: Square Root

MathLevel: BeginnerAvailable in: Excel 2007+SQRT returns the positive square root.Syntax=SQRT(number)ArgumentWhat it meansnumberZero or.

Read article →
Older posts
Newer posts
← Previous Page1 … Page95 Page96 Page97 … 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? →