Microsoft Excel 2016 Intermediate

Module 1: Calculating With Advanced Formulas

• Use Excel's Quick Analysis Tools
• Using Mixed References in Calculations
• Work with Range Names
• Calculating across Worksheets
• Exploring Excel's Function Categories
• Analysing Data Based on Criteria
• Working with Text Functions
• Calculating with Financial Functions
• Using Logical Functions
• Applying Lookup Functions

Module 2: Auditing a Worksheet

• Finding Cells
• Finding and Resolving Errors
• Using the Watch Window
• Evaluating a Formula

Module 3: Mastering Excel Tables

• Introducing Excel Tables
• Using Advanced Table Tools

Module 4: Organising Worksheet Data

• Apply Basic Sorting to a Data Range
• Advanced Sorting
• Summarise Data with Subtotals

Module 5: Charts

• Understanding Charts
• Create a Chart
• Modify and Format a Chart
• Analyse Data Using Sparklines

Module 6: Working with Templates

• Create a Hyperlink
• Adding Comments
• Work with Templates

Module 7: Analysing Selected Data

• Applying Basic Filters
• Advanced Filters
• Use Database Functions
• Use Outlines to Organise Data

Module 8: Apply Conditional Formatting

• Conditional Formatting
• Customising Conditional Formatting
• Sorting and Filtering by Colour

Module 9: An Introduction to Pivot Tables

• Understanding Pivot Tables
• Analyse Data with Recommended Pivot Tables

Module 10: Appendix - Inserting Illustrations

• SmartArt
• Insert Images into a Spreadsheet
• Insert Shapes into a Spreadsheet
• Group and Layer Graphics

Module 11: Appendix - Excel Options