The Intermediate Excel 2016 course builds on the techniques and concepts presented in the Excel 2016 Introduction course.  This course will focus on how to create and use advanced formulas, analyze data, organize worksheet data with tables and enhance workbooks.

Course Content

This course will look specifically at :

• Creating Formulas and exploring Excel Functions
• Link Cells in Different Workbooks
• Introduction to Specialised Functions
• If statements, Sumif, Countif, Vlookup, Text Functions, Date and Time Functions
• Organising Worksheet Data with Tables
• Analysing Data with PivotTables
• Apply Conditional Formatting
• Protect Files

In addition to the above, the trainer will focus on specific topics/queries that participants have.

Trainer

Mary Warde, Sureskills Ltd