For advanced levels
Most suitable for advanced users of Excel who need to have a full understanding of functions, create forms and templates, perform data simulation and collaborate with others.
of this course is to provide students with a full understanding of functions, how they can be nested into each other in order to manipulate data. The student will also discover how to share a workbook with colleagues, automate some tasks by using forms, templates and macros. Also learn how to merge data from different tables into one; display columns and rows to only show the information required, and finally how to create scenarios.
Module 1: Advanced Functions
Module 2: Auditing Worksheets
Module 3: Summarising Data
Module 4: Simulation
Module 5: Automating Worksheet Functionality
Module 6: Collaboration Tools
Module 7: Templates and Forms
Module 8: Introduction to Macros