MS Office
$275
Per Participant
The purpose of this Advanced Microsoft Excel training course is to equip participants with the knowledge and abilities required to use pivot tables, audit and analyze worksheet data, make use of data tools, work in teams, and create and manage macros.
Excel proficiency at both the beginning and intermediate levels.
Students who wish to master the topics taught in this course in the interface or students who want to acquire more advanced skills with Microsoft Excel but have intermediate competence levels.
Microtek Learning is a Microsoft Certified Partner for Learning Solutions. This class uses official Microsoft courseware and will be delivered by a Microsoft Certified Trainer (MCT).
This module explains how to use pivot tables in Microsoft Excel.
Lessons
Lab 1: Working with Pivot Tables
After completing this module, students will be able to:
This module explains how to audit worksheets.
Lessons
Lab 1: Auditing Worksheets Exercises
After completing this module, students will be able to:
This module explains how to work with data tools.
Lessons
Lab 1: Data Tools Exercises
After completing this module, students will be able to:
This module explains how to work with others in Microsoft Excel.
Lessons
Lab 1: Working with Others Exercises
After completing this module, students will be able to:
This module explains how to record and use macros.
Lessons
Lab 1: Recording and Using Macros Exercises
After completing this module, students will be able to:
This module explains how to use sparklines and other useful random features.
Lessons
Lab 1: Random Useful Items Exercises
After completing this module, students will be able to:
This module explains how to save, share, and collaborate with others using the cloud.
Lessons
Lab 1: Using the Cloud
After completing this module, students will be able to:
For many years, Microtek Learning has been helping organizations, leaders, and professionals to reach their maximum performance by addressing the challenges they are facing.
I'm really impressed with the storytelling skills of the instructor. She makes the session exciting by keeping things simple and easy to understand.
Texas
I was recommended the ITIL 4 Foundation course by an IT professional who had completed the same course at Microtek Learning. The training gave me a thorough understanding of service management that I felt I could take back to my job as an IT Project Management and apply it to improve the value of products and services.
Texas
I was sceptical at first whether to enrol with Microtek Learning or not, however, I am glad that I did- I got everything that was promised (maybe more). The trainer was very patient and knowledgeable and with his effort and mine, I was able to clear the exam with ease! Keep up the good work everyone.
MARTIN
TORONTO, CANADA