Excel & Power BI for Finance: Excel (Season 1)

Season 1 of Excel & Power BI for Finance — six episodes turning a real ERP General Ledger extract into a robust monthly close model. Reading the GL, lookups (SUMIFS / XLOOKUP / INDEX-MATCH), pivot tables for the P&L, Power Query for ETL, and Tables / named ranges / dynamic arrays for hand-offable workbooks. Sample company: AtlasParts Corp.

6 posts