 |
Corporate
portraits |
|
|
|
|
Microsoft
Office Training throughout West Sussex & East Sussex, Surrey and Hampshire: Horsham, Brighton, Burgess Hill, Chichester, Crawley, Eastbourne, East Grinstead, Haywards Heath,, Lewes, Littlehampton, Dorking, Farnham, Godalming, Guildford,Redhill, Reigate, Weybridge Woking, Havant, Petersfield, Portsmouth, Southampton, Winchester, Tonbridge & Tunbridge Wells.
|
 |
Basic
Excel Training (1 day) |
|
 |
| Microsoft
Office Training > Excel
Training > Basic Excel
Training |
Basic Excel
Training Overview (Excel 2007,
2003, XP and earlier) |
This
1 day basic Excel training course
is designed for those that 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
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 manuals and practice,
step-by-step exercises. This
will provide an excellent source
of information and on-going
self study once the training
has been completed.
Upgrade
with the Basic Excel 2007 Training
Course
For pricing click
here
To return to the application
overview page click
here
Excel Training in Sussex,
Surrey,
Hampshire
and London |
|
|
| Formulae
Basics |
- Basic calculations
- SUM, MIN, MAX, AVERAGE,COUNT,
COUNTA
- Copying formulae
- Absolute referencing
- Mixed referencing
- Naming cells and ranges
- Introduction to IF statements
- Performing calculations
with dates and times
|
|
|
| Charting |
- The chart wizard
- Formatting chart elements
- Changing the source data
- Creating a secondary axis
- Saving a custom chart
- Setting a default chart
|
|
|
| Formatting |
- Changing column widths and
row heights
- Formatting cells for different
data types
- Using autoformat for tables
- Format painter
- Styles
- Condtional formatting based
on cell values
|
|
|
| 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
|
|
|
| Basic List
Management |
- Sorting on multiple columns
- Hiding columns
- Changing column order
- Freezing rows and columns
- Introduction to filters
|
|
|
|
|
| |
|
|