Course Overview
This course offers participants at all levels of proficiency a comprehensive coverage of the most useful and powerful excel techniques and tools for business analysis delivered by senior financial modellers. By completing this course, partipants will learn how to multiply their productivity by manipulating and managing data sets, models and reports using powerful functions, formulae and modelling techniques.
Practical aspects of the course will cover how to automate business processes with VBA and create dynamic tools to achieve higher levels of productivity and efficiency for yourself and your team or organisation. This course is intended for business professionals at all levels of proficiency in excel and anslysis. It is not essential to have attended any other courses prior to commencement.
Partipants of this course will learn how to use and apply power excel functions, formula, modelling techniques, data analysis and reporting techniques and VBA code to boost productivity and acheive a mastery of excel. As part of the course, participants will learn to clean, manipulate, analyse and report on different sizes of data sets and how to use sophisticated formula, modelling and VBA code to solve typical business problems.
Course Content
This course will provide a comprehensive coverage of basic to advanced excel skills and techniques and will train participants through solving various business and data analysis problems using excel. The course will cover the following:
- Orientation overview of excel;
- Key functions and formulae;
- Solving typical business problems;
- Getting and using data;
- Dealing with large data sets;
- Introduction to VBA programing;
- Applying VBA to business problems;
- Security and access rights
