| |
| Onsite Microsoft Excel 2010 Training - we come to you! |
|
 |
Excel 2010 Training For Beginners
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.
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 |
|
|
|
| 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
- Sparklines
|
|
|
| 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.
|
|
|
|
|
