|
MICROSOFT EXCEL INTERMEDIATE 2003
AIMS AND OBJECTIVES
This one-day training session will expand on participants' existing
knowledge of Microsoft Excel. During the session participants
will receive training on a variety of uses of Excel in the workplace.
All participants will receive hands-on training of all the topics.
WHO SHOULD ATTEND?
The training session is designed for those who have a good grounding
in Microsoft Excel, for example, following attendance at an Introduction
or Improvers workshop. Each participant will be given a comprehensive
reference manual to take away with them.
COURSE CONTENT
Handling Large Spreadsheets
- Page break preview
- Printing row & column headings
- Printing formulae and gridlines
|
Styles and Conditional Formatting
- What are styles?
- Creating and using styles?
- Applying conditional formatting to single/range of cells
|
Improving Data Entry Speed
- Filling a series of cells
- Creating custom lists |
Spreadsheet Templates
- Creating
- Using
- Changing |
Working Across Worksheets
- Adding and moving worksheets
- Linking worksheets
- Linking cells
- Using functions across worksheets
- Using paste special
- Using typed functions
- Using named ranges |
Date & Time Calculations
- Selecting the correct format
- Using in-built functions |
Protecting Data
- File passwords
- Cell protection |
Using Excel as a Database
- What is a database?
- Concept of data, field names, records and files
- Entering data via a form
- Sorting data
- Filtering data |
Functions
- Basic functions reviewed - average, max, min
- IF function
- COUNTIF, SUMIF
- Use of past function button |
Excel Charts
- Creating and labelling
- Amending
- Adding trendlines |
|
