| |
| Onsite Microsoft Excel 2007 Training - we come to you! |
Microsoft Office Training > Office 2007 Training > Excel 2007 Beginner's
 |
Excel 2007 Beginner's Course
This
1 day Microsoft Excel course
is designed for those who have
little or no experience with
Microsoft Excel. The course
covers training in the basics
of formatting, navigation, data
entry and calculations. Make
sure you are comfortable with
the course content before you move
on to the intermediate level
course. The outline is only
a suggestion and can be tailored
to your business needs.
To accompany the instructor
lead training, each delegate
will receive course notes which
will provide an excellent source
of information and on-going
self study once the training
has been completed.
To view the Office 2007 shared
features topics click
here.
To view Excel 2007 upgrade topics click
here.
For pricing click
here
To return to the application
overview page click
here |
|
|
|
| Course Outline |
| Formulae
Basics |
- Basic calculations
- SUM, MIN, MAX, AVERAGE,COUNT,
COUNTA
- Copying formulae
- Absolute referencing
- Mixed referencing
- Naming cells and ranges
- The new Name Manager
- Introduction to IF statements
- Performing calculations
with dates and times
- Resize Formula Bar
|
|
|
| Charting |
- The chart Ribbon tabs
- Formatting chart elements
- Changing the source data
- Creating a secondary axis
- Saving a custom chart template
- Setting a default chart
|
|
|
| Formatting |
- Changing column widths and
row heights
- Formatting cells for different
data types
- Using the new table formatting options
- Format painter
- The New Conditional Formatting options
- New draw border and grid options
|
|
|
| Printing |
- Setting a print area
- Getting data to fit the
page
- Headers and footers
- Printing rows and/or column
headers on every page
- Printing gridlines
- The New Page Layout View
|
|
|
| Basic List
Management |
- Sorting on multiple columns
- Hiding columns
- Changing column order
- Freezing rows and columns
- Introduction to filters
- New Total features for filters
|
|
|
|
|
| |
| Onsite Microsoft Office Training |
Microsoft
Office Computer Training Courses throughout Surrey, Sussex, Hampshire, Kent, Essex, Berkshire, Buckinghamshire, Dorset, Hertfordshire, Oxfordshire, Wiltshire and London including Crawley, Brighton, Portsmouth, Southampton, Winchester, Farnham, Guildford, Basingstoke, Salisbury, Bournemouth, Poole, Dorchester, Tunbridge Wells, Ashford, Canterbury, Maidstone, Gravesend, Croydon, Kingston-upon-Thames, Reading, Newbury, Oxford, Watford, Hemel Hempstead, Dartford, Stevenage, Milton Keynes, Basildon, Chelmsford, Southend on Sea and Colchester.
|
|
|
|
|
