This course introduces the user to the more advanced features of Microsoft Excel to attain proficiency as a competent Excel user.
Templates
Paste Special Options
Time and Date functions
Financial Functions
LookUp Functions
Nested Functions
Advanced charts
Importing Text files
Auditing tools
Goal Seek
By actively participating in this course, you will learn about the following:
Create and manipulate Templates
Use various Paste Special options
Create advanced charts
Import text files
Use Excel’s auditing tools
Use Time and Date functions
Use Financial functions
Use LookUp functions
Understand and create 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.
This course is aimed at those wishing to gain the skill sets necessary for calculating data using advanced functions and formulas and to create and manipulate advanced charts.
