IT and Computing (Live Online) > Microsoft Excel Functions & Formulas

Microsoft Excel Functions & Formulas

Course Objectives

Designed for those who are geared up to speed with Microsoft Excel but you would now like to automate some common tasks, apply advanced analysis techniques to more complex data sets. This course is aimed at someone desiring to gain the skills necessary to learn advanced formulas, using What If Analysis tools, Vlookup and more complex formulas.

Audience

Participants should be familiar with using computers and have used a mouse and keyboard. Participants should be comfortable in the Windows environment and be able to use Windows to manage information on their computer.

To get the most out of this course, we recommend completion of one of the following courses, or equivalent knowledge from another source: Windows 2003/ Windows 7 and Microsoft Excel Basic, Intermediate and Advance.

METHODOLOGY

Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.

Course Modules

MODULE 1: USING LOGOCAL FUNCTIONS

The IF function
Creating nested IF functions
The IFS function
AND and OR functions
Combining logical functions

MODULE 2: WORKING WITH LOOKUPS

The VLOOKUP function
The HLOOKUP function
Combining VLOOKUP and HLOOKUP function
INDEX & MATCH

MODULE 3: DATA VALIDATION

Using data validation
Setting criteria for entry of text, values and dates
Creating a dropdown list

MODULE 4: PIVOTTABLES AND PIVOTCHARTS

Creating and rearranging PivotTables
Using the PivotTable toolbar
Creating PivotCharts
Using Slicers to manipulate PivotTable

MODULE 5: USING ANALYTICAL OPTIONS

Using Goal Seek
Creating, saving and viewing scenarios
Creating single input data tables
Creating double input data tables
Projecting with data tables

MODULE 6: MACROS

Creating macros
Using the macro recorder

Get To Know The Trainer

Trainer Beatrice

4.5

Beatrice has been in the training industry for the past 27 years being one of the pioneer trainers of Microsoft Office training programs. She has vast experience having trained many people from various corporate sectors. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad (PSMB/HRDC).

VIEW PROFILE

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