Every course is tailored to the needs of the group, but this is a typical outline for this level
INTRODUCTION 1 Day
Pre-requisites
This course is aimed at delegates who wish to learn the basic concepts of Microsoft Excel.Delegates should be comfortable using a keyboard and mouse in a Windows environment.
Objective
To provide delegates with the confidence, knowledge and practical experience to be able to use Excel for numerical analysis & presentation of information.
Overview
Delegates will learn how to use the basic features in Excel. I
ndependent exercises are an integral part of the course. It emphasises hands-on experience through use of sample course files and, if appropriate, delegates' own worksheets.
Core Topics
The Excel Screen
Entering Numbers, Text, Dates and Formulas
Formulas and Functions
File Storage and Retrieval
Entering Lists of Data
Sorting
Subtotals
AutoFilter
Formatting your Work
Printing
Charting