EXCEL AND POWERPOINT PRODUCTIVITY HACKS FOR PRESENTER (VERSION 2013)

EXCEL AND POWERPOINT PRODUCTIVITY HACKS FOR PRESENTER (VERSION 2013)

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

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

  • Cell referencing
  • Absolute Cell Referencing
  • VLOOKUP()
  • VLOOKUP Exact Match
  • Nested VLOOKUP with IFERROR Function
  • VLOOKUP Approximately Match
  • Use VLOOKUP to return more than one result-Array Formula
  • 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
  • Creating Pivot Char
  • Show/Hide the filtering button in Pivot Chart
  • Export Pivot Excel Dashboard to POWERPOINT
  • 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
  • Inserting SmartArt
  • One click Organization Chart with SmartArt
  • Add Assistant(s) to your Organization Chart
  • Entrance, emphasis & exit animation
  • Start animation using trigger
  • How to use transition to create endless timeline or process with hyperlinks

Trainers

Reviews

Interested In

EXCEL AND POWERPOINT PRODUCTIVITY HACKS FOR PRESENTER (VERSION 2013)

Starting From
RM500
Intake Date
25 OCT 2023
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: EXCEL AND POWERPOINT PRODUCTIVITY HACKS FOR PRESENTER (VERSION 2013)
Duration: 1 Day
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *