The course is presented in three parts:
First, the course reveals the 3 environments forecasts and budgets are made and compare each one of them.
Next, the course presents 6 challenges in budget modeling and reporting. They include:
- How to accommodate Operation Team’s need to work from Excel while all budgets are in the Planning system?
- How to build an interactive budgeting model in Excel?
- How to write into a PivotTable?
Last, we provide 6 solutions to the above 6 challenges in budget modeling and reporting. They include:
- Building an interactive budgeting model that allows the Operation Team to make changes to forecasts and budgets and see the results instantaneously.
- Building an “editable” PivotTable that allows Operation Team to put forecasts and budgets directly in the PivotTable report.
- Consolidating Actuals, Forecasts and Budgets from different data sources by using Power Query.
- Building integrated Slides from Excel Reports.
Course Key Concepts: Flat table, Cross table, Calculated field, Calculated item.
Learning Objectives
- Discover and understand when and how to build an interactive budgeting model in Excel.
- Identify reasons in building a PivotTable report vs a regular report with formulas.
- Discover techniques on building an “editable” PivotTable.
- Recognize and understand ways to report budgets from the System using a PivotTable.
- Explore methods of consolidating Actuals and Budgets from multiple data sources.
5 Reviews (30 ratings)
Reviews
Prerequisites
Basic Excel knowledge
Excel Pivot Table: basics
Power Query: Ultimate Data Transformation
Example: be able to open one Excel file and connect to external data files, etc.
It is recommended to take other Excel Magic series courses by Lenny Wu.
Excel Magic 1: Building Dynamic Formulas
Excel Magic 2: Building Your Report Generation "Bot"
Excel Magic 3: Automating Data Entry with Data Feeds
Excel Magic 4: Ultimate API Reporting in Excel
Excel Magic 5: Building Interactive Budgeting Model in Excel
Excel Magic 6: Excel's 7 Languages
Excel Magic 7: Creating Excel Charts like a PRO
Excel Magic 8: Transforming a Pro-forma into a Dashboard
Excel Magic 9: Building a Project Tracking “Gantt” Chart