Excel Training - Intermediate

Excel training that builds on the skills learnt on our introduction to Excel course, the participant will develop a multi-sheet spreadsheet to summarise complex data imported from alternative formats, the user will then go on the output a worksheet as HTML. At the end of the course the user will have sufficient knowledge to enable the analysis of complex data sources and produce easy to follow management summaries.

Course content:

Import filters
Pivot tables
An introduction to Macros
Export filters
Use of Forms
Filters
Developing worksheets for web browsers
DDE and OLE
Modifying Charts
Lists

Course duration 1 day.

Course Prerequisites. The course assumes the participant will have already completed the level one course above or is at an equivalent level.