Microsoft Excel Intermediate course, updated 2020

You will learn how to use some of the more common functions like IF statements, CountIF , Vlookup, Hlookup and SumIf.  You will also see how you can create create superb visualisations using charts and maps.  The Pivot tables and charts feature will enable you to manage and report on large data sets and remain in control of your data no matter how complicated the raw data set looks.

Outline is below:

· Conditional formatting

· Average function/Count

· Maximum function/Sum

· Minimum function/SumIF

· Basic Scenarios

· Sheet Layout and design

· Named Cells/Ranges

· Absolute Referencing/ percentages

· Basic Pivot Tables

· Using 3-D Referencing

· Goal Seek

· Data Tables

· Sheet and cell Protection

· Linking Sheets and Workbooks

· Using Array Formulae

· Using Group and Outline/Saving Views

· Naming Worksheets

· Using the Subtotals Feature

· Creating Templates

· Basic Lookups/Basic IF