DIPLOMA IN ADVANCE EXCEL (DAE)

Course Modules

Module 1: Fundamentals of Excel

• Introduction to Excel Interface & Ribbon
• Understanding Workbook & Worksheet
• Data Entry, Editing & Formatting
• Using Formulas & Functions (Basic: SUM, AVERAGE, MIN, MAX, COUNT, IF, etc.)
• Cell Referencing (Relative, Absolute & Mixed)
• Page Layout, Printing & Export Options
• Keyboard Shortcuts for Productivity

Module 2: Working with Excel Data

• Sorting & Filtering Data
• Data Validation & Conditional Formatting
• Working with Dates, Text & Logical Functions
• Lookup & Reference Functions (VLOOKUP, HLOOKUP, XLOOKUP, INDEX & MATCH)
• Financial Function (PMT, PV, RATE, NPER, PPMT, IPMT, FV)
• Pivot Tables & Pivot Charts
• Importing Data from External Sources (CSV, Web, SQL, etc.)
• Data Cleaning & Error Handling
• Protecting Worksheets & Workbooks (Password Security)

Module 3: VBA & Macros using Excel

• Introduction to Macros & Recording Macros
• Editing Macros using VBA (Visual Basic for Applications)
• Understanding VBA Editor & Object Hierarchy
• Writing VBA Code: Variables, Loops & Conditions
• Automating Repetitive Tasks with VBA
• Creating Custom Functions (UDFs)
• Error Handling in VBA
• Building Interactive Excel Applications (Forms, Buttons, Drop-downs)

Module 4: Data Visualisation & AI Tools

• Advanced Charts (Waterfall, Histogram, Pareto, Gantt, Sparklines)
• Power Query & Power Pivot
• Data Analysis ToolPak (What-if Analysis, Solver, Scenario Manager)
• Dashboards: Designing & Customising Interactive Dashboards
• Forecasting & Trend Analysis
• Introduction to AI-Powered Excel Features (Ideas in Excel, Data Insights)
• Integration with AI Tools (ChatGPT, Copilot in Excel)
• Case Studies & Real-World Projects

Module 5:Practical & Project Work (Capstone Module)