5 Files

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.

3 Files

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.

3 Files

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.

1 File

In the business world Waterfall Charts are a must. But, they are VERY tricky to customize in Excel. We’ve got 15 versions pre-made for you in our downloadable Excel file. Ready to plugin your numbers and apply in your reports. All charts are inspired by our customers who needed these in their corporate reports. We've included instructions on how to copy over your data and use these right away. No stress.

6 Files

Enhance your financial modelling skills with this eBook bundle from expert Liam Bastick. The bundle includes two essential books & downloadable Excel files: 1. Introduction to Financial Modelling: Ideal for beginners, it breaks down complex concepts into easy steps. 2. Continuing Financial Modelling: For advanced learners, it covers sophisticated techniques and real-world applications.