Introduction
This 20-hour Advanced Excel workshop provides in-depth training to master Excel’s powerful tools and features for data management, analysis, and visualization. Participants will learn advanced formulas, data validation, and conditional formatting to handle complex datasets effectively. The workshop covers pivot tables, macros, and what-if analysis for advanced data analysis and decision-making.
Participants will also design professional dashboards, create dynamic charts, and automate tasks using VBA basics. With hands-on practice and real-world projects, this workshop equips learners with the skills to enhance productivity, streamline workflows, and make data-driven decisions confidently.
Course Modules
Module 1 Advanced Excel Essentials
Understanding Advanced Excel Features; Advanced Formatting and Data Validation; Working with Functions and Formulas
Module 2 Data Management and Analysis
Data Sorting and Filtering; Working with Pivot Tables and Pivot Charts; Data Consolidation and Grouping
Module 3 Advanced Tools and Automation
Using What-If Analysis; Introduction to Macros; Data Protection and Collaboration
Module 4 Visualization and Reporting
Creating Advanced Charts; Building Professional Dashboards
Certification Details
We offer two types of certifications under this course: Completion Certificate and Participation Certificate.
Completion Certificate
To receive a Completion Certificate, students must pass a final exam. On passing, a hard copy certificate will be issued and will include the student's name, guardian's name, enrolment number, course completed, and course duration.
Participation Certification
A soft copy certificate will be issued and will include the student's name, guardian's name, enrolment number, course participated in, and course duration.
Grading Scale
The exam will be graded on the following scale:
Percentage
Final Grade
> 85%
A+
80% - 85%
A+
75% - 80%
B+
70% - 75%
B
65% - 70%
C+
60% - 65%
C
55% - 60%
D+
50% - 55%
D
40% - 50%
E
< 40%
Fail
Students who either do not take the final exam or do not pass but maintain at least 40% attendance will be awarded a Participation Certification.