| |
| Onsite Microsoft Excel Training - we come to you! |
| Microsoft
Office Training > Excel
Training > Basic Excel
Training |
 |
Excel Training - Beginner's Course
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 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.
The outline is only a suggestion and
can be tailored to your business needs.
To accompany the instructor lead training,
each delegate will receive class notes that
will provide an excellent source of information
and on-going self study once the training
has been completed. For pricing click
here |
|
|
|
| Course Outline |
| 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
- Sparklines
- Trendlines
|
|
|
| Formatting |
- Changing column widths and
row heights
- Formatting cells for different
data types
- Using autoformat for tables
- Format painter
- Conditional 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
- Total row
|
|
|
|
|
| |
| 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.
|
|
|
|
|
