Diploma in Advanced Excel & Data Analytics

Course Description

This 1 Year course provides structured learning in diploma in advanced excel & data analytics. The syllabus covers Excel Fundamentals | Advanced Formulas | IF, SUMIF, COUNTIF | VLOOKUP/XLOOKUP | INDEX & MATCH | Conditional Formatting | Data Validation | Sorting & Filtering | Pivot Tables | Pivot Charts | Data Cleaning | Data Analysis | Dashboard Development | Practical Projects. It is designed around the topics listed in the supplied course syllabus and focuses on developing practical understanding through the included areas of study.