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. The course will also cover how to automate business processes with VBA and create dynamic tools to achieve higher levels of productivity and efficiency for yourself and also 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

‍

* For questions about this course, delivery at your offices or to discuss bulk discounts please contact enquiries@tunneys.co.uk

‍