Day | Date | Objective | Delivery |
Basic Excel |
Day 1 – (Wednesday) | June 3, 2026 | Onboarding – Course outline Introduction to Excel Interface Navigating the Excel ribbon, tabs, and menus. Understanding worksheets, rows, columns, and cells. Saving, opening, and creating workbooks.
| Online (Live session) |
Day 2 – (Friday) | June 5, 2026 | Data entry and Basic Formatting Overview of types of data Entering, editing, and deleting data. Formatting cells Adjusting row heights and column widths.
| Online (Live session) |
Day 3 – (Monday) | June 08, 2026 | Basic Formulas and Functions
| Online (Live session) |
Day 4 – (Wednesday) | June 10, 2026 | Working with Rows, Columns, and Sheets Inserting, deleting, and moving rows/columns. Renaming, adding, and deleting sheets. Using freeze panes and split view.
| Online (Live session) |
Day 5 – (Monday) | June 15, 2026 | Basic Sorting and Filtering Sorting data (ascending/descending). Applying filters to view specific data. Clearing sorting and filters.
| Online (Live session) |
Day 6 – (Wednesday)
| June 17, 2026 | Introduction to Charts Creating basic charts: Bar, Line, and Pie charts. Customizing chart elements (titles, axes, legends). Printing and exporting charts.
| Online (Live session) |
Day 7 – (Monday) | June 22, 2026 | Basic Data Validation | Online (Live session) |
Day 8 – (Wednesday) | June 24, 2026 | Printing and Sharing Workbooks Setting print areas and adjusting page layout. Using print preview and scaling options. Sharing workbooks via email or cloud storage.
| Online (Live session) |
Intermediate excel |
Day 9 – (Monday)
| June 29, 2026 | Advanced Formatting Conditional formatting basics. Using cell styles and themes. Custom number formatting.
| Online (Live session) |
Day 10 – (Wednesday) | July 1, 2026 | Intermediate Formulas and Functions Logical functions: Text functions Lookup functions
| Online (Live session) |
Day 11 – (Monday) | July 6, 2026 | Working with Tables Creating and formatting Excel tables. Using structured references in formulas. Sorting and filtering data in tables.
| Online (Live session) |
Day 12 – (Wednesday)
| July 8, 2026 | Data Visualization with Charts
| Online (Live session) |
Day 13 – (Monday) | July 13, 2026 | Pivot Tables Basics Creating and customizing pivot tables. Adding calculated fields and values. Grouping data within pivot tables.
| Online (Live session) |
Day 14 – (Wednesday) | July 15, 2026 | Data Validation and Protection Advanced data validation rules. Protecting sheets and locking cells. Understanding workbook security options.
| Online (Live session) |
Day 15 – (Monday) | July 20, 2026 | Using Templates and Macros Creating and saving templates. Recording and running simple macros. Assigning macros to buttons.
| Online (Live session) |
Day 16 – (Wednesday) | July 22, 2026 | Introduction to Collaboration Sharing workbooks for collaboration. Using comments and notes. Tracking changes in shared workbooks.
| Online (Live session) |
Advanced Excel |
Day 17 – (Monday) | July 27, 2026 | Advanced Functions and Nested Formulas
| Online (Live session) |
Day 18 – (Wednesday) | July 29, 2026 | Power Query Basics Importing data from external sources. Cleaning and transforming data in Power Query. Merging and appending queries.
| Online (Live session) |
Day 19 – (Monday) | August 3, 2026 | Advanced Pivot Tables and Pivot Charts | Online (Live session) |
Day 20 – (Wednesday) | August 5, 2026 | Data Analysis Tools Using the Analysis ToolPak. Running what-if scenarios and sensitivity analysis. Data tables, goal seek, and solver.
| Online (Live session) |
Day 21 – (Monday) | August 10, 2026 | Advanced Charting Techniques Dynamic charts with named ranges. Waterfall and thermometer charts. Creating custom chart types.
| Online (Live session) |
Day 22 – (Wednesday) | August 12, 2026 | Macros and VBA Introduction Editing macros in the VBA editor. Writing simple VBA scripts. Automating tasks with VBA.
| Online (Live session) |
Day 23 – (Monday) | August 17, 2026 | Power BI and Power Pivot Connecting Excel to Power BI. Using Power Pivot for data modeling. Creating relationships between tables.
| Online (Live session) |
Day 24 – (Wednesday) | August 19, 2026 | Automation and Dashboard Creation Building dynamic dashboards. Using form controls and slicers. Automating dashboard updates with VBA.
| Online (Live session) |
Capstone Project: Sales Performance and Forecasting Dashboard |
|
|
|
|
