Microsoft Excel 2013 – Advanced
Duration
1 day
Pre Requisites
Delegates should first attend the Microsoft Excel Intermediate course or have attained a similar level of expertise.
Objectives
By the end of this one day course delegates will feel confident in their ability to use the more advanced features of Excel including lookup tables, advanced formulae, PivotTables and macros.
Other Versions Available
2007, 2010
Further Learning
Excel with PowerPivot
Excel VBA
Course Content
Advanced Functions
- Using SUMIF, AVERAGEIF & COUNTIF
- Multiple conditions
- Lookup Tables
- Text Functions
Outlining and Views
- Outlining a Worksheet
- Creating Custom Views
Controlling Data Input
- Data Validation
Advanced Filtering
- Text to Columns
- Advanced Filtering
PivotTables
- Creating PivotTables
- Formatting the Pivot Table
- Using Slicers
- Adding a Timeline
- Calculations in PivotTables
- Grouping & Ungrouping
- Creating a PivotChart
- Create PivotTables based on Multiple Tables
Macros
- Recording a Macro
- Viewing Macros
- Adding a Macro to the Ribbon
- Assigning a Macros to an Object
- Accessing the Developer Tab
- Macro Security Settings
What-If Analysis (time permitting)
- Goal Seek
- Data Tables
- Scenarios