Course curriculum

  • 03

    Calculate impact of Sales Variances on Profit of a business using Excel

  • 04

    Calculate impact of Variance on Profit margin (%) using Excel

    • 4.1 Change in Profit Margin % intro

      FREE PREVIEW
    • 4.2 Change in Profit margin % Example

    • 4.3 Change in Profit % due to Price

    • 4.4 Change in Profit Margin % due to Mix

    • 4.5 Explaining Profit % Change (Cost and Mix) - Part 1

      FREE PREVIEW
    • 4.5 Explaining Profit % Change (Cost and Mix) - Part 2 Model Intro

    • 4.5 Explaining Profit % Change (Cost and Mix) - Part 3 Price impact

    • 4.5 Explaining Profit % Change (Cost and Mix) - Part 4 Cost impact

    • 4.5 Explaining Profit % Change (Cost and Mix) - Part 5 Mix Change Impact 1

    • 4.5 Explaining Profit % Change (Cost and Mix) - Part 6 Mix Change Impact 2

    • Download Impact on Margin % Example

  • 05

    Automated Excel modeling for Sales, Cost and prior period variances

    • 5.1 Explaining Sales Variance in $ vs bud

    • 5.2 Explaining Variances in Cost $

    • 5.3 Explaining variances vs prior year

  • 06

    Summarize the results of all variances

    • 6.1 Summarize and present intro

    • 6.2 Summarise and present results - summary table

    • 6.3 summarise and present results - Waterfall chart total

    • 6.4 Summarise and present results - Waterfall Chart Individual product

    • 6.5 Creating Waterfall chart manually

    • 6.6 Linking waterfall chart to PowerPoint presentation

    • Practice File #3 - Create Waterfall Chart

  • 07

    Analyze, present and make recommendations!

    • 7.1 Analysing variances and making recommendations

    • 7.2 Analysing variances other factors to consider

    • Q&A: What if we sold a new product that did not exist in PY or budget

    • Solved Excel Files!

  • 08

    Wrap Up!

    • 8.1 Wrap Up!