Intermediate Excel
For Delegates with a basic knowledge of Excel who wish to extend their knowledge further.
Aims & Objectives To introduce more advanced formatting, formulas and functions, as well as time saving features of Excel.
Pre-requisites Delegates should have a good understanding of the basic functions and features of Excel, including simple formulas, and have preferably attended the preliminary Excel course.

Content

 Changing the Default Template
AutoTemplates
Grouping Sheets
Repeating Headings
Freezing Titles + Splitting Windows
Naming Cells and Formulae
Linking Worksheets + Workbooks (3D references)
Consolidating Data
Customising Excel
Creating a Series - AutoFill
Growth Series
Custom Series
Concatenation
Date and Time Calculations
Conditional Formatting
Conditional Functions, including:
IF, AND, NOT, OR
COUNTIF, SUMIF
SUMPRODUCT

Duration

 1 day                     back