Time: 9am - 4pm
Duration: 1 day
Compatible with 2013
In this course you will learn how to: create advanced formulas and functions; create named ranges; resolving formula errors; consolidate data; removing duplicates; configure data validation; transpose data; use outlining, grouping, and subtotal tools; working with scenarios; use data analysis tools (such as Solver and Goal Seek); create and use PivotTables and PivotCharts; use PowerPivot to integrate data from several different sources; record, edit, and use macros.
MO13EX101—Microsoft Excel 2013 Core Essentials or equivalent is mandatory.