MS Excel 2010 Advanced

Working with Outlines
Apply an Outline, Collapse/Expand an Outline, Modify Outline Settings, Clear an Outline, Use Auto Outline, Create Subtotals in a List, Remove Subtotals from a List

Using Multiple Workbooks
Open and Arrange Multiple Workbooks, Save a Workspace, Create and Maintain Links

Using Range Names
Jump to a Named Range, Assign Names, Use Range Names in Formulas, Create Range Names from Headings, Apply Range Names, Delete Range Names, Use Range Names in 3-D Formulas, Create 3-D Range Names, Use 3-D Range Names in Formulas

Working with Tables
Use Tables, Create a Table from Existing Data, Change the Table Name, Change the Table Style, Change Table Style Options, Create a Total Row, Add Table Rows and Columns, Insert/Delete Table Rows/Columns, Create a Calculated Column, Select Parts of a Table, Move a Table, Sort Data by Multiple Levels, Use Text Filters, Use Number Filters, Use Data Validation, Validate Data using a List, Create a Custom Error Message, Remove Data Validation

Working with Advanced Filters
Create a Criteria Range, Use a Criteria Range, Show All Records, Use Comparison Criteria, Use an Advanced And Condition, Use an Advanced Or Condition, Copy Filtered Records, Use Database Functions, Find Unique Records, Remove Duplicates from a Table

Using Advanced Functions
Use the VLOOKUP and HLOOKUP Function, Use the IF Function and Nested IF Function, Use the ISERROR Function, Use an AND Condition with IF, Use an OR Condition with IF, Use the ROUND Function, Limit the Precision of Numbers

Using Advanced Functions
Using the VLOOKUP & HLOOKUP Function, Using the IF Function & Nested IF Function, Using the ISERROR Function, Using an ‘AND’ Condition with IF, Using an ‘OR’ Condition with IF

Advanced Charting
Add, Remove and Format Gridlines, Format an Axis, Change the Axis Scale, Format the Data Series, Add Data – Different Worksheets, Use a Secondary Axis, Change Data Series Chart Types, Add a Trendline, Create User-defined Charts, Create, Customise, Remove Sparklines

Using Templates
Save a Workbook as a Template, Use a Template, Edit a Template, Delete a Template, Create Default Templates

Using Auditing Tools
Display the Formula Auditing Toolbar, Display/Remove Dependent and Precedent Arrows, Remove Tracer Arrows, Use Auditing Tools Buttons