Productivity hacks refers to any trick, shortcut, skill, or novelty method that increases productivity and efficiency, in all walks of using Microsoft Excel to store data and generate reports also with Microsoft PowerPoint to create an eye-catching PowerPoint presentation which easy to maintain and visual appealing.

1. Create simple formula by reference data from cell
   
2. Apply freeze cell reference
   
3. Understand the uses of VLOOKUP.
   
4. Use VLOOKUP in different situation (approximately match & exact match).
   
5. Nest VLOOKUP function and IFERROR function
   
6. Create simple Table and export it to Pivot Table
   
7. Use different calculation in Pivot Table
   
8. Insert slicer to analyse data
   
9. Create dynamic dashboards by creating different Pivot Charts
   
10. Paste Excel dashboard as link to PowerPoint for presentation
    
11. Understand about theme colour and customize to keep consistency within a presentation
    
12. Understand different types of animation and transition
    
13. Apply trigger to activate multiple animation
    

Basic knowledge of Microsoft Excel & PowerPoint is essential with the following prerequisites: - • Have attended Microsoft Excel & PowerPoint – Foundation Level. •Able to Create, Open & Close a New workbook in Excel & New Presentation in PowerPoint.