Excel for Finance Lesson 4: Monthly MIS P&L From a GL Extract
Turn a general-ledger or trial-balance extract into a monthly P&L: map heads to groups, SUMIFS by month and type, gross profit, EBITDA, net profit,…
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
Power BI Intermediate Lesson 2: % of Total With ALL, ALLEXCEPT and REMOVEFILTERS
Power BI Intermediate Lesson 2: % of Total With ALL, ALLEXCEPT and REMOVEFILTERS
Region share of total, product share within its category and grand-total percentages that stay correct under slicers, with REMOVEFILTERS, ALL and ALLEXCEPT.
Read article →Power BI Intermediate Lesson 1: CALCULATE and Filter Context
Power BI Intermediate Lesson 1: CALCULATE and Filter Context
How CALCULATE adds and replaces filters, why a measure gives different results in each cell, and when KEEPFILTERS returns blank.
Read article →GAMMALN.PRECISE Function in Excel: Natural Log of Gamma (2010+ Version)
GAMMALN.PRECISE Function in Excel: Natural Log of Gamma (2010+ Version)
GAMMALN.PRECISE is the 2010 version of GAMMALN with the same result and improved accuracy.
Read article →Excel Lesson 18: Final Project — Build a Monthly Sales Report
Excel Lesson 18: Final Project — Build a Monthly Sales Report
Put the whole course together: turn raw orders into a one-page quarterly sales report with KPIs, region vs target with Met/Missed, a monthly chart,…
Read article →Excel Lesson 15: Data Validation and Drop-Down Lists
Excel Lesson 15: Data Validation and Drop-Down Lists
Stop typing mistakes before they happen: drop-down lists from a range or Table, whole-number and date limits, custom rules for PAN and mobile numbers,…
Read article →GAMMA Function in Excel: The Gamma Function
GAMMA Function in Excel: The Gamma Function
StatisticsLevel: ExpertAvailable in: Excel 2013+GAMMA extends factorials to non-whole numbers: GAMMA(n) = (n-1)! for whole.
Read article →Excel Lesson 14: Lookups — VLOOKUP and XLOOKUP
Excel Lesson 14: Lookups — VLOOKUP and XLOOKUP
Fetch a price, name or rate from another table: VLOOKUP exact match step by step, XLOOKUP (easier and more flexible), handling codes that aren’t…
Read article →Excel Lesson 13: Dates — TODAY, EOMONTH, DATEDIF and Date Maths
Excel Lesson 13: Dates — TODAY, EOMONTH, DATEDIF and Date Maths
How Excel stores dates, adding days and months, due dates, month-end with EOMONTH, age and service with DATEDIF, working days with NETWORKDAYS, YEAR/MONTH/WEEKDAY, and…
Read article →Excel Lesson 12: Text Functions — LEFT, RIGHT, MID, TRIM, PROPER and More
Excel Lesson 12: Text Functions — LEFT, RIGHT, MID, TRIM, PROPER and More
Clean and split messy text: TRIM extra spaces, fix case with PROPER/UPPER/LOWER, cut pieces with LEFT, RIGHT and MID, find positions with FIND, replace…
Read article →Excel Lesson 11: Absolute vs Relative References ($)
Excel Lesson 11: Absolute vs Relative References ($)
Why formulas break when copied, and how the $ sign fixes it: relative, absolute ($B$8) and mixed ($A2, B$1) references, the F4 shortcut, named…
Read article →Excel Lesson 10: Printing and Page Setup
Excel Lesson 10: Printing and Page Setup
Print Excel sheets that fit: Print Preview, orientation, Fit to page width, print area, repeating header rows, headers and footers with page numbers, page…
Read article →