Excel Intermediate

Who should attend: Those people who wish to increase their utilisation of this popular spreadsheet package.


Course Contents

Entering Functions Using the AutoSum Icon
- SUM, AVERAGE, MAX, MIN
Using the IF Logical Function
Text Functions
- CONCATENATE, PROPER, LEFT
Creating Absolute Cell References in Formulas
Using Named Ranges in Functions

Break

Handling Multiple Worksheets in a Workbook
- linking cells across worksheets
- creating 3D formulas
Using the Watch Window
Moving, Copying, and Deleting Worksheets
Grouping Worksheets Together
Opening and Arranging Windows
Splitting Windows and Freezing/Unfreezing Panes

Lunch

Understanding Cell Protection
- protecting worksheets
Data Validation
- setting validation criteria
- controlling data entry
Customising the AutoFill Facility
- creating and editing AutoFill entries

Break

Working with Excel Tables
- adding a total row
- creating a calculated column
Filtering Data
- using slicers
- using Custom filters
- filtering data ranges
Sorting Records
Utilising Structured References