Diploma in Advanced Excel & Data Analysis

Course Description

This 6 Months course provides structured learning in diploma in advanced excel & data analysis. 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 Analysis | Dashboard Creation | 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.