Course Details
Course Code: EXFM; Instructor-led
Audience
This course is designed for Managers of all levels; and personnel who already know and want to further enhance their knowledge and practical uses of Microsoft Excel & PowerPoint.
Prerequisites
Basic knowledge of Microsoft Excel & PowerPoint is essential with the following pre-requisites:
- Have attended Microsoft Excel & PowerPoint – Foundation Level
- Able to Create, Open & Close a New workbook in Excel & New Presentation in PowerPoint
Methodology
Elements of this syllabus are subject to change. This one-day instructor- led course provides students with the knowledge and skills to create a simple to complex Excel Report/Dashboard & eye-catching PowerPoint presentation which easy to maintain and visual appealing.
Course Objectives
Upon completion of this program, participants should be able to:
- Create simple formula by reference data from cell
- Apply freeze cell reference
- Understand the uses of VLOOKUP
- Use VLOOKUP in different situation (approximately match & exact match)
- Nest VLOOKUP function and IFERROR function
- Create simple Table and export it to Pivot Table
- Use different calculation in Pivot Table
- Insert slicer to analyse data
- Create dynamic dashboards by creating different Pivot Charts
- Paste Excel dashboard as link to PowerPoint for presentation
- Understand about theme colour and customize to keep consistency within a presentation
- Understand different types of animation and transition
- Apply trigger to activate multiple animation
Outlines
Module 1: Simple Calculation
- Cell referencing
- Absolute Cell Referencing
Module 2: Lookup Function
- VLOOKUP()
- VLOOKUP Exact Match
- Nested VLOOKUP with IFERROR Function
- VLOOKUP Approximately Match
- Use VLOOKUP to return more than one result-Array Formula
Module 3: Pivot Table
- Convert raw data into an Excel Table format
- Covert Table to Pivot Table
- Apply changes to database and synchronize the changes
- Using Pivot table to Compile Report
- What is Pivot Table Fields?
- Using different formulas in Pivot Table
Module 4: Pivot Charts
- Creating Pivot Char
- Show/Hide the filtering button in Pivot Chart
Module 5: Real Time Dynamic Dashboard in POWERPOINT
- Export Pivot Excel Dashboard to POWERPOINT
Module 6: Importance of Theme
- Choosing a Theme
- Choosing a Variant
- Utilize the colour dropper to pick up colour from objects
- Create customize colour palate to keep the consistency of the whole presentation
Module 7: SmartArt
- Inserting SmartArt
- One click Organization Chart with SmartArt
- Add Assistant(s) to your Organization Chart
Module 8: Simple animation & Transition
- Entrance, emphasis & exit animation
- Start animation using trigger
- How to use transition to create endless timeline or process with hyperlinks