City Lit > Business > Courses > IT training > Microsoft Excel: stage 2 (clb012)
Microsoft Excel: stage 2
Course available by request
Duration: 1 day
Price: £595 for up to 10 delegates
Information and booking: Phone 020 7492 2676 or Email business@citylit.ac.uk
What is the course about?
This course will introduce the more advanced features of Excel: sorting, filtering, linking, formulae, pivot tables and macros to allow you to create and work with complex spreadsheets.
What level is the course?
This is an advanced course and you should have completed the Excel for beginners course or have working knowledge or experience of using Excel.
What will the course cover? (contents, themes, projects)
- Advanced sorting of data
- Advanced filtering of data
- More advanced linking of worksheets for calculations
- More advanced formulas incorporating various functions
- Lookup Tables
- Using pivot tables
- Recording macros
- Using data tables
- Scenarios
- Auditing
- Naming data ranges.
How will I be taught?
Each student has their own computer.
Presentations will be made using computers, whiteboard, overhead screen and printed notes.
Step by step instruction, with demonstrations where appropriate, will help you grasp the concepts.
Who can I contact for further information?
For further information or to book a course phone 020 7492 2676 or Email business@citylit.ac.uk