MS Half-Day Public Class > Operational Excellence with Microsoft Excel

Operational Excellence with Microsoft Excel

Overview

Extracting and managing operational data from system
Compiling weekly / monthly data
Creating simple template to capture business data
Reconcile data sets from multiple source

When to Use

To prepare simplified template to store data
Check and verify imported data
Matching and comparing 2 or more sets of data
To prepare weekly or monthly summary

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 over a video conference platform.

Pre-Requisites

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

Course Modules

Lesson 1 : Keeping dynamic data range as Table
Lesson 2 : Getting a summary to meet specific criteria
Lesson 3 : Rules to control user input in a cell
Lesson 4 : Quick searching, compiling and comparing data from multiple sheets / workbooks

Get To Know The Trainer

Trainer Jarina

4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

VIEW PROFILE

Trainer Izham

4.5

Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.

VIEW PROFILE