Microsoft Power BI

    Microsoft Excel - What If Analysis, Goal Seek, Scenarios and Data Tables

    Course Duration: 90 Minutes

    Target Audience:

    This session is intended for Excel users who wish to make forecasts and projections on data using ‘what-if’ analysis tools.

    Course Objectives:

    This session will use the Goal Seek facility (single variable) and set up scenarios incorporating several variables, apply those scenarios and produce a scenario report. This session will also examine how to set up ‘what-if’ data tables.

    Course Outline:

    Introduction and Overview

    CONTENT

    Goal Seek

    • Use the Goal Seek Feature

    Create and Manage Scenarios

    • Create Scenarios
    • Apply Scenarios
    • Create a Scenario Summary
    • Use Range Names in a Scenario Summary

    1 and 2 Input Data Tables

    • Create a One-Way Data Table
    • Create a Two-Way Data Table

    Discussion and Question Time

    View Schedule
    Contact Us