MICROSOFT EXCEL HALF DAY SESSION TWO COURSE OVERVIEW

Course Objectives

A 1/2 Day Intermediate Course, aimed at users that have attended the previous stage or are an experienced user. This course aims to give users further knowledge and tools to create and use Excel spreadsheets. By the end of the session users will be able to use a wider range of formulas and better understanding of the more powerful functions of excel.

Course Content

Quick refresh on excels basic commands

Absolute Cell References
•IF Statements
•H and V Lookup

Sorting Records

Subtotals

Filters

Pivot Tables and Pivot Charts

Hide / Un-Hide Columns

Freeze Panes

Named Ranges of Cells

Customise your own lists

Tools – Options

Data Validation

Protection

Linking and Embedding