|
INTRODUCTION TO MICROSOFT EXCEL 2003
AIMS AND OBJECTIVES
This one-day training session will give participants an understanding
of the basic functions of Microsoft Excel. During the session
participants will receive training on many different uses of Microsoft
Excel, including an introduction to the formulas available and
their uses. They will also have hands-on use of each of the functions.
WHO SHOULD ATTEND?
The training is designed for those who are new to Microsoft Excel.
A basic knowledge of working within the Windows environment and
using the mouse is desirable. Each participant will be given a
comprehensive reference manual to take away with them.
COURSE CONTENT
What is Excel?
- Starting Excel
- Basic concepts of spreadsheets
- An introduction to workbooks and worksheets
- Working with rows and columns
- Cell references |
Basic Calculations within Excel
- Addition, subtraction, multiplication and division
- An introduction to functions
- Functions, including SUM,MIN, MAX and AVERAGE
- The 'BODMAS' rule
- Absolute cell addresses versus relative cell addresses
|
Navigating within Excel
- Using the mouse
- Using the keyboard
- Useful keyboard shortcuts |
Printing and Page Setup
- Scaling
- Fitting to page
- Margins
- Headers and footers
- Printing Options |
Data Entry
- Entering text, numbers and dates
- Correcting errors |
Time Saving Techniques
- Cut, copy and paste
- Replicating data
- More keyboard shortcuts |
File Management
- Saving files
- Opening files |
Charting
- Creating |
Formatting Cells
- Number formats
- Cell formatting including borders and shading
- Auto format |
|
|
