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

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE INCLUDE

ALL IN FROM ONLY

RM49/PAX

*T&C Applies

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?