FREE WORKSHOP

Optimize Your Microsoft Office Skill

16 April 2022 | 9AM – 1PM | Microsoft TEAMS

Trainer : Sylvia Anthony

Overview

Upon completion of this program, participants should be able to

  • VLOOKUP
  • Pivot Table
  • Create Complete Presentation
  • Export Presentation as Movie

OUTLINE

Excel

 

Lesson 1: Using VLOOKUP Function

Lesson 1.1 Find closest match with VLOOKUP

Lesson 2: Create Pivot Table

Lesson 2.1 Create Pivot Table New Worksheet

Lesson 2.2 Create Pivot Table Existing Worksheet

Lesson 2.3 Group Sort & Filter

Lesson 2.4 Pivot Chart Creation

Powerpoint

 

Lesson 1: Create New Presentation

Lesson 1.1 Word Content Send to Power Point

Lesson 1.2 Apply Design to Presentation

Lesson 1.3 Change Text to Smart Art Graphics

Lesson 1.4 Create Simple Animation to selected slide

Lesson 1.5 Export Presentation as Movie