Excel – Advanced
½ Day [3hrs] Hands On Training Course
Designed for experienced users of Excel this session jumps straight into more advanced tools in Excel such as creating templates, protecting sheets and cells and templates and macros to automate common tasks.
Requirements
This session is best run hands on with participants utilising a computer
What You Will Cover:
- Security & Protection including protecting worksheets
- Circular References and auditing tools
- Linking multiple sheets and files
- Editing & Changing links
- Data consolidation
- Importing & Exporting
- Pivot Tables
- Macros
Download this outline as a PDF.