Microsoft Excel Data Analysis

This course teaches experienced Excel users how use Excel's What-If tools: Goal Seeker, Solver, Scenario Manager, and Data Tables. The student will learn how to install Excel's add-in tool AnalysisPak that comes with Excel but is not loaded, and will explore using it to create complex analyses such as Histograms, Rank and Percentile Analysis, and Descriptive Statistics. The student will also learn how to use the Data Tools group to separate text into multiple columns, remove duplicates, set up data validation in cells, and consolidate data from multiple ranges. Great course for managers who need to analyze data to make management decisions! Prerequisite: Excel I, II, and III or equivalent knowledge