Course length:  1-day

Course Description

Microsoft Office Excel is Microsoft’s popular spreadsheet program that allows users to organize, format, and calculate data with formulas using a structure broken up by rows and columns.

The Expert Data Analysis course is designed for advanced Microsoft Office Excel professionals who may work or be interested in the domain of statistics, project analysis, and market analysis. This course explores built-in and add-in tools that allow users to perform advanced analysis on their data.

Highlights of the course include manipulating data using Excel tools and Add-ins such as Consolidate, Goal Seek, Scenario Manager, The Analysis Toolpak, Solver, Power Pivot and Power View.

The Inquire add-in, PowerPivot, and Power View are tools available in Office 2013 and later. With the exception of those few topics, users currently operating on Office 2010 will be able to apply the material covered in this course.

Prerequisites

Excel Level 3 Advanced or have equivalent knowledge.

Course Outline

Linking, Consolidating, and Combining Data

Analyzing Data

Using the Solver Add-in

Working with Scenarios

 

Using the Inquire Add-In (2013 and later)

Using PowerPivot (2013 and later)

Using Power View (2013 and later)