Microsoft Office Excel Intermediate 

Program Period

Duration: 2-days

Who is this course for?

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; and personnel who already know and understand and want to further enhance their knowledge and practical uses of Microsoft Excel.

Prerequisites

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

Have attended Microsoft Excel – Foundation Level; OR

• • Able to switch between task applications

• • Able to create a spreadsheet with simple formatting

• • Able to create a basic chart

• • Able to print a spreadsheet with headers and footers added

• • Able to use Auto Filter command

• • Able to apply Freeze Pane command

• • Able to create basic formulas – Addition, Subtraction, Multiplication and Division

• • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.

Methodology

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

Objective

Upon completion of this program, participants should be able to create simple to complex formulas and functions, like:

• • COUNTA & COUNTIFS Function

• • AVERAGEA &AVERAGEIFS Function

• • SUMIF & SUMIFS Function

• • IF Functions

• • Nested Functions

• • Database Function

• • Validate data in a Worksheet

• • Filter data using Auto & Advanced Filters

Course Syllabus: 

Day 1: 2pm-6pm

 

Unit 1 – Performing Calculations

Unit 2 – Creating Advanced Formulas

Unit 3 – Working with Functions

Unit 4 – Organizing Worksheet Data with Tables