Microsoft Excel 2016 Intermediate - Office for Mac Training in New Zealand

• Create basic spreadsheets
• Select and edit data
• Perform basic formatting
• Open, close and save files
• Create basic formulas – AutoSum
• Use Insert Function to create built-in functions
• Work with absolute references
• Use the Autofill feature

• Use advanced formulas
• Organise worksheet and table data using various techniques
• Create and modify charts
• Insert and modify graphic objects in a worksheet
• Customise and enhance workbooks and the Microsoft Office for Mac Excel environment

Module 1 - Calculating with Advanced Formulas

• Using Mixed References in Calculations
• Working 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

Module 3 - Mastering Excel Tables

• Introducing Excel Tables

Module 4 - Organising Worksheet Data

• Applying Basic Sorting to a Data Range
• Advanced Sorting
• Summarising Data with Subtotals

Module 5 - Charts

• Understanding Charts
• Modifying and Formatting a Chart
• Analysing Data using Sparklines

Module 6 - Working with Templates

• Creating a Hyperlink
• Adding Comments
• Working with Templates

Module 7 - Analysing Selected Data

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

Module 8 - Applying Conditional Formatting

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

Module 9 - An Introduction to PivotTables

• Understanding PivotTables
• Analysing Data with Recommended PivotTables

If time permits:-

Module 10 - Appendix: Inserting Illustrations

• SmartArt
• Inserting Images into a Spreadsheet
• Inserting Shapes into a Spreadsheet
• Grouping and Layering Graphics