Live Virtual Training (Most Popular!) > OEME Operational Excellence with Microsoft Excel

OEME Operational Excellence with Microsoft Excel

All versions available. Outline version below is Microsoft Excel 2019. If you need assistance just chat with us LIVE.

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

Create Table
Quick Formatting using Table Style
Turn on quick summary with Subtotal
Cleaning Up Duplicate Entry

Lesson 2 : Getting a summary to meet specific criteria

Adding up value with SUMIF / SUMIFS
Finding number of entry with COUNTIF / COUNTIFS
Average up value with AVERAGEIF / AVERAGEIFS

Lesson 3 : Rules to control user input in a cell

Dropdown list to limit entries
Restrict value entry for number and date
Custom user defined restriction

Lesson 4 : Quick searching, compiling and comparing data from multiple sheets / workbooks

Vertical search for exact matching data using VLOOKUP
Horizontal search for matching data using HLOOKUP
VLOOKUP as alternative for Nested IF function

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 P.L

4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

VIEW PROFILE