Course Overview
Elevate Your Expertise with Advanced Excel Training
Looking to supercharge your Microsoft Excel skills? Our ‘Microsoft Excel 2021 Advanced’ course is your ticket to unlocking the full potential of this powerful tool. Whether you’re a clerk, executive, manager, or just someone passionate about mastering Excel, this course is tailor-made for you. We’ve designed it to take your existing Excel knowledge to the next level, helping you excel in your professional endeavors.
What are the skills covered
Upon completion of this program, participants should be able to:
- Create Subtotal Using the Subtotal Function
- Analyze data Using Pivot Tables
- Perform What If Analysis using:
- Goal Seek
- Solver
- Input Table
- Scenarios
- Use XLOOKUP function to extract data
- Nesting INDEX and MATCH Function
- Combining & Consolidating Data
- Summarizing & Analyzing with Pivot Table and Pivot Charts
Who should attend this course
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.
Course Curriculum
What are the Prerequisites
Basic knowledge of Microsoft Excel is essential with the following pre-requisites:
- Have attended Microsoft Excel – Foundation & Intermediate Level; OR
- Able to create simple to complex formulas and functions
- Able to validate data in a Worksheet
- Able to apply Filter data using Auto & Advanced Filters
- Able to clean Duplicate Records
Course Modules
Exam & Certification
This course is not associated with any Certification.
