Course Description

Do you often work with data at work or frequently extract data to create reports to update your leaders?

Microsoft Excel is a powerful spreadsheet program that allows you to make quick and accurate numerical calculations.

You will be more confident when you present formulated spreadsheets to highlight your key data narratives.

This 1 day workshop course is suitable for you, if you are looking beyond using basic features of Excel. You will be explored with more features of Excel to increase your productivity while working with data.

You’ll learn the popular features such as conditional formatting, sorting, filtering and data validation. Besides that, you will learn formulas like IF(), AND() and OR(), conditional and database formulas. Most importantly, you will learn to work with Charts confidently.

Course Objective

At the end of this course, you should be able to:

Enhance your work environment and generate new ideas

Essential Excel Fundamental

Clarify the roles and responsibilities of your supervisory role and adjust to the new role with confidence

Working with Functions and Formulas

Learn how to listen effectively so that you can understand and manage others

Managing Workbooks and Protections

Work effectively on the computer desktop using icons

Working with Data Ranges

Apply 3K Strategies

Filtering Data

Enhance your work environment and generate new ideas

Essential Excel Fundamental

Clarify the roles and responsibilities of your supervisory role and adjust to the new role with confidence

Working with Functions and Formulas

Learn how to listen effectively so that you can understand and manage others

Managing Workbooks and Protections

Work effectively on the computer desktop using icons

Working with Data Ranges

Apply 3K Strategies

Filtering Data

Course Outline

You will be learning the following:

  • Customizing the Quick Access Toolbar

  • Entering Content Automatically (AutoFill & Flash Fill)

  • Using Paste Options and Paste Special Commands

  • Applying Conditional Formatting

  • Creating and Managing Conditional Formatting Rules

  • Overview of Formulas and Cell References (Absolute & Relative)

  • Cell and Range Names

  • Using and Managing Defined Names

  • Understanding Formula Errors

  • Using Logical Functions (Nested IF, AND, OR)

  • Using Conditional Count, Sum and Average Functions (COUNTIF, SUMIF, AVERAGEIF)

  • Using Database Functions (DSUM, DCOUNT, DAVERAGE)

  • Splitting and Freezing a Window

  • Working with Multiple Workbook Windows

  • Protecting Workbooks

  • Protecting a Workbook Structure

  • Protecting Worksheets and Worksheet Elements

  • Creating Custom Number Format

  • Sorting by One Column

  • Sorting by Multiple Columns

  • Sorting by Custom List

  • Filtering Data

  • Creating Custom AutoFilter

  • Using Data Validation

  • Using Subtotal

  • Choosing and Selecting the Source Data

  • Using Quick Analysis

  • Choosing the Right Chart

  • Inserting, Moving, Resizing and Deleting Chart

  • Elements of a Chart

  • Modifying and Changing Chart Data

  • Filtering Chart

  • Changing Chart Layout, Style and Colours

  • Working with Chart Labels

  • Changing Chart Gridlines

  • Changing the Scale

  • Emphasizing Data

  • Changing Chart Type

  • Using Sparklines

Course Fees And Grants

Course Fee:
$200 ($216 Inc. 8% GST) per participant
No SDF grant

Any of the 2 fast track – 10% offer
$360 ($388.80 Inc. 8% GST)

Any of the 3 fast track – 20% offer
$480 ($518.40 Inc. 8% GST)

No SDF grant.

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueJan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

Course Fee:
$200 ($216 Inc. 8% GST) per participant
No SDF grant

Any of the 2 fast track – 10% offer
$360 ($388.80 Inc. 8% GST)

Any of the 3 fast track – 20% offer
$480 ($518.40 Inc. 8% GST)

No SDF grant.

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

ASK Training