Operational Excellence with Microsoft Excel (Part A)

Course Objectives

Basic knowledge of Windows is essential with the following pre-requisites:

• Able to switch between task applications
• Able to create a spreadsheet with simple formatting
• Able to use Auto Filter command
• Able to use basic functions – AutoSum, Count, Max, Min and Average functions

Target Audience

• Administration Staff
• Financial Executive
• Operational Staff
• Resource and planning team
• Supervisors
• Engineers

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.

Course Modules

• Lesson 1: Keeping dynamic data range as Table
• Lesson 2: Getting a summary to meet specific criteria