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 →Atul Vij
Power Automate Lesson 8: Error Handling, Run History and Good Habits
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
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…
Read article →Power Automate Lesson 5: Approvals
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…
Read article →Power Automate Lesson 2: Your First Cloud Flow — Email Alerts
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…
Read article →Power Automate Lesson 1: What Power Automate Is (Cloud vs Desktop)
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
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…
Read article →Power BI Lesson 6: CALCULATE and Filter Context
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…
Read article →Power BI Data Modelling: Build a Star Schema (and Why Your Report Is Slow Without One)
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…
Read article →DAX CALCULATE Explained: Filter Context Without the Headache
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…
Read article →Power BI Lesson 1: Desktop Tour and Loading Data
Power BI Lesson 1: Desktop Tour and Loading Data
Install Power BI Desktop, learn the Report, Table and Model views, load several Excel tables through Power Query, check data types, and save a…
Read article →Power BI Desktop: Build Your First Report From an Excel File
Power BI Desktop: Build Your First Report From an Excel File
Step-by-step first Power BI report from an Excel table: install, Get data, check types in Power Query, build cards, bar and line charts, a…
Read article →