Microsoft EXCEL Course
Microsoft WORD Course
January 4, 2021
Microsoft EXCEL Course
| Online LIVE Class Course | Day (Hour) | Timing
Lunch (1 hr break) for 9am-5pm / 9am-3pm | Jan 2021 | HRDF CLAIMABLE |
|---|---|---|---|---|
| Microsoft Excel Essential Skills (Level 1 & 2) | 2 (14 hr) | 9am - 5pm | 7-8 | YES |
| Manipulating Data Effectively with Microsoft Excel (Level 1 & 2) | 2 (14 hr) | 9am - 5pm | 25-26 | YES |
| Data Management with Pivot Table using Microsoft Excel | 1 (7 hr) | 9am - 5pm | 19 | YES |
| Secret to Microsoft Excel Waterfall Charts | 0.5 (4 hr) | 9am - 1pm | 4 | YES |
| Microsoft Excel Interactive Charts | 0.5 (4 hr) | 2pm - 6pm | 4 | YES |
| Presenting Analysis with Microsoft Excel Charts | 0.5 (4 hr) | 9am - 1pm | 25 | YES |
| Conditional Formatting with Microsoft Excel | 0.5 (4 hr) | 9am - 1pm | 13 | YES |
| Custom Format with Microsoft Excel | 0.5 (4 hr) | 2pm - 6pm | 18 | YES |
| Data Analysing with Microsoft Excel Functions | 1 (7 hr) | 9am - 5pm | 7 | YES |
| Microsoft Excel TEXT Functions | 0.5 (4 hr) | 2pm - 6pm | 27 | YES |
| Conditional Ranking using Microsoft Excel Functions | 0.5 (4 hr) | 2pm - 6pm | 13 | YES |
| Microsoft Excel Lookup Functions – Vlookup, Hlookup, Match, Index | 0.5 (4 hr) | 9am - 1pm | 27 | YES |
| Microsoft Excel 365 - New Functions | 0.5 (4 hr) | 9am - 1pm | 29 | YES |
| Microsoft Excel Functions & Formulas | 2 (14 hr) | 9am - 5pm | 11-12 | NO |
| Advanced Microsoft Excel Functions & Formulas | 1 (7 hr) | 9am - 5pm | 13 | NO |
| Mastering Microsoft Excel Array Formulas | 1 (7 hr) | 9am - 5pm | 5 | NO |
| Tasks Automation with Microsoft Excel Macro / VBA (Fundamental & Intermediate) | 2 (14 hr) | 9am - 5pm | 6-7 | NO |
| Tasks Automation with Microsoft Excel Macro / VBA (Advanced) | 2 (14 hr) | 9am - 5pm | 20-21 | NO |
| Microsoft Excel Survey Automation and Consolidation | 1 (7 hr) | 9am - 5pm | 18 | NO |
| Introduction to Dashboard Reporting | 1 (7 hr) | 9am - 5pm | 12 | YES |
| Interactive Visual Dashboard Reporting and Analysis with Microsoft Excel | 2 (14 hr) | 9am - 5pm | 19-20 | no |
| Introduction to Power Query & Power BI | 0.5 (4 hr) | 9am - 1pm | 4 | YES |
| PowerQuery: Transforming work processes in Microsoft Excel | 1 (7 hr) | 9am - 5pm | 14 | NO |
| Power BI Desktop Essential Skills | 2 (14 hr) | 9am - 5pm | 7-8 | YES |
| Optimizing the Power of HR Using Microsoft Excel | 2 (14 hr) | 9am - 5pm | 21-22 | YES |
| Applying Microsoft Excel for HR | 2 (7 hr) | 9am - 5pm | 14-15 | YES |