IT and Computing (Live Online) > Excel and PowerPoint Productivity Hacks for Presenter

Excel and PowerPoint Productivity Hacks for Presenter

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

Target 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.

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 Modules

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

Get To Know The Trainer

Trainer P.L

4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

VIEW PROFILE