Financial Modelling in Power BI
Can you build Financial Models in Power BI? With this book, you can! Instead of using Excel to create financial models and then importing them into Power BI for visualization and analysis, you'll learn to do everything in Power BI. In this book, you'll learn from my friend and MVP colleague Liam Bastick and Jonathan Liau how to do everything in Power BI, from start to finish. They'll guide you through the process with clear and practical examples.
Guerrilla Data Analysis Using Microsoft Excel
The book opens with a review of Excel basics and moves on to show you: Pivot tables, Conditional formatting, Power Query, and Dynamic Arrays. And then there are what the authors call skirmishes: those aspects of working with Excel and data that aren’t directly Excel but are real world challenges that make your Excel work more difficult.
Microsoft 365 Excel: The Only App That Matters
The Definitive Guide to Building Excel Solutions with the Excel Worksheet, Power Query, Power Pivot, and Power BI Desktop Using Worksheet Formulas, DAX Formulas, M Code Formulas, and Standard PivotTables. This eBook from my MVP colleague and inspiration, Mike "excelisfun" Girvin starts at the beginning and moves you to an advanced level by telling a logical story about how to use Excel to solve calculation-based problems and answer crucial questions.