This course introduces the user to the more advanced features of Microsoft Excel to attain proficiency as a competent Excel user.
TARGET AUDIENCE:
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.
COURSE PREREQUISITES:
To ensure your success, we recommend you first take the following courses or have equivalent knowledge:
•
Microsoft Excel Level 1
•
Microsoft Excel Level 2
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.
COURSE CONTENT:
•
Templates
•
Paste Special Options
•
Time and Date functions
•
Financial Functions
•
LookUp Functions
•
Nested Functions
•
Advanced charts
•
Importing Text files
•
Auditing tools
•
Goal Seek
COURSE OBJECTIVE:
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
FOLLOW ON COURSES:
MSEXL4 – Microsoft Excel Level 4MSEXVBAP1 – Microsoft Excel VBA Part 1MSEXVBAP2 – Microsoft Excel VBA Part 2