Excel Intermediate

Duration: 1 Day

Prerequisites

• 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 

Calculating With Advanced Formulas

• Using Mixed References in Calculations

• Work with Range Names

• Calculating across Worksheets

• Exploring Excel's Function Categories

• Analysing Data Based on Criteria

• Working with Date Functions

• Using Logical Functions

Apply Conditional Formatting

• Conditional Formatting

• Customising Conditional Formatting

• Sorting and Filtering by Conditional Formats

 Managing Worksheet Data

• Protecting Worksheets and Workbooks

• Using Sheet View

• Advanced Filtering

An Introduction to Pivot Tables

• Understanding Pivot Tables

• Analyse Data with Recommended Pivot Tables