Our Excel Advanced Workshop is designed for users, who have previously attended an intermediate course or who have the equivalent knowledge. This course is a practical session with small tutoring groups in order for individuals’ requirements to be met.
Our Excel Advanced workshop covers:
- Creating a List & Maintaining a List
- Using the Data Form
- Sorting & Filtering a List
- Using Subtotals in a List
- Creating a User Defined Function
- Creating Pivot Tables & Pivot Chart Reports
- Using Goal Seek & Solver
- Using Scenario Manager
- Recording & Using Macros
The Excel Advanced Workshop takes place over a 1 day.
Time: 9.30am – 4.30pm
Candidates will be required to bring their own laptop computer, loaded with a full copy of Excel 2007 or above. A personal memory stick will be issued to each candidate with all coursework examples so they may take this back to the workplace.
All successful candidates will receive a certificate specifying their qualification shortly after attending their course.