This course can act as a follow on from the excel beginners course or as a standalone. It will cover creating complex models that will involve linking multiple worksheets and files. Logical functions along with the creation of graphs and charts for industry usage along with conditional formatting. It will enable a participant to perform much more complex tasks in excel – eliminating the need for manual efforts and act as an aid to decision making. Real live examples from industry domains will be used.
Upon completion of this course participants will be able to:
Create Complex business models using multiple worksheets and files
Perform logical functions acting as an aid to interpretation of business outcomes
Use data functions
Use charts and graphs and integrate them into business overviews
Create pivot tables – for more complex modelling
Who should attend
This course is suitable for those who have completed an excel beginners course. Or those who are using excel on a day to day basis and can perform basic excel operations such as create, edit, format and print along with understanding and creating basic formula and functions.