This course is designed for users who want to take more control of Microsoft Excel and use it in order to facilitate business decisions. This course allows users to start analysing data for the good of the business rather than just using it as an end user.
This course is designed for those wishing to gain the skills necessary to automate some common Excel tasks.
By actively participating in this course, you will learn about the following:
Using Templates
Using Paste Special Options
Creating advanced charts
Importing text files
Using Excel’s auditing tools
Using Time and Date functions
Using Financial functions
Using LookUp functions
Understanding and creating Nested functions
To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
Software Requirements for Virtual Classroom
Delegates will need to have Microsoft Excel 2013, 2016, 2019 or 365 (desktop version) installed on their PC to participate in Virtual Classroom courses. Delegates may notice differences in their software if using a MAC.
Templates
Paste Special Options
Time and Date functions
Financial Functions
LookUp Functions
Nested Functions
Advanced charts
Importing Text files
Auditing tools
Goal Seek