Hi 👋 I'm the Codegiz assistant. Ask me about our packages, services, pricing, or how we'd tackle your project — I'll point you to the right starting point. Or email hello@codegiz.com or WhatsApp +65 8962 7828 to talk to a human.
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.