Course Modules
Week 1-2: Excel Essentials Review
Introduction to Excel Interface
Basic Formulas and Functions
Data Formatting and Conditional Formatting
Charts and Graphs Basics
Week 3-4: Advanced Formulas and Functions
Advanced Lookup Functions (VLOOKUP, HLOOKUP)
INDEX and MATCH
Logical Functions (IF, AND, OR)
Text Functions (LEFT, RIGHT, MID, CONCATENATE)
Date and Time Functions
Week 5-6: Data Analysis and Visualization
Pivot Tables and Pivot Charts
Data Validation
Advanced Charting Techniques
Text Functions
Scenario Analysis and Data Tables
Week 7-8: Data Management and Automation
Sorting and Filtering Data
Importing and Exporting Data
Data Cleaning Techniques
Macros Basics
Introduction to VBA (Visual Basic for Applications)
Week 9-10: Advanced Data Analysis Tools
Power Query
Power Pivot
Goal Seek
Statistical Analysis
Week 11-12: Automation with VBA
VBA Programming Basics
Writing and Debugging Macros
User Forms and Controls
Automating Reports and Dashboards
Course Code : CCA101
Course Code : DFA201
Course Code : DCA202
Course Code : DWD101
Course Code : COA101
Course Code : DITA201
Course Code : DPP101
Course Code : CCA101
Course Code : ADVEXCEL101
Course Code : ADVEXCEL101
Course Code : CCBET-40
Course Code : MOS101
Course Code : M-DDTP201
Course Code : M-ADDTP302
Course Code : M-DFAS102
Course Code : M-DWD105
Course Code : M-CCA101
Course Code : M-CGD101
Course Code : M-ADCA101
Course Code : M-SCC201
Course Code : M-SCPC401