| |
| Onsite Microsoft Excel Training - we come to you! |
| Microsoft
Office Training > Excel
Training > Excel Advanced Course |
 |
Excel Advanced Course
This 1 day
Microsoft Excel advanced course is designed
for those that need to explore functions to a more in depth level and also need to automate aspects
of Excel's functionality with the use
of Macros. Some basic computer programming skills
will be acquired during this course so
a very good level of computer literacy
is needed together with a good grasp of
the Excel themes covered in the Beginners'
and Intermediate Excel courses.
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 |
| Advanced Functions |
- IF OR and IF AND
- Two way look ups using VLOOKUP and MATCH
- Combining IF and VLOOKUP
|
|
|
| Pivot Tables |
- Preparing data
- Understanding a Pivot Table layout
- Formatting data
- Grouping items
- Filtering data in the PivotTable
- Inserting calculated fields
- Changing calculation options
- Creating PivotCharts
- Use Slicers (Excel 2010)
|
|
|
| What is a Macro? |
- Command macros
- Function macros
- Recorded macros
- Written macros
|
|
|
| Good Practise |
- Good practise
- Naming a macro
- Macro security
- Macro storage
- Editing a recorded macro
using VBA
- Relative vs absolute recording
mode
|
|
|
| Running
a Macro |
- Shortcut keys
- Macro button
- Custom Toolbar
- Custom Menu
- Automatically on workbook
opening/closing
|
|
|
|
|
| |
| 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.
|
|
|
|
|
