MICROSOFT EXCEL 2021 INTERMEDIATE_1D

MICROSOFT EXCEL 2021 INTERMEDIATE_1D

Summary

Location

Location

Malaysia

Duration

Duration

1 Day
Format

Format

Public Class

Public Class

Course Details

Course Code: EX21I-1; Instructor-led

Audience

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 create a spreadsheet with simple formatting
  • Able to print a spreadsheet with headers and footers added
  • 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, discussion and practical exercise.

Course Objectives

Upon completion of this program, participants should be able to:

  • Create formulas and functions, like:
  • AVERAGEA &AVERAGEIFS Function
  • SUMIF & SUMIFS Function
  • IF Functions
  • Nested Functions
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filters
  • Visualizing Data as a Graphics

Outlines

Topic A: Formula Reference

  • Relative References
  • Absolute References
  • Mixed References

Topic A: Conditional Data Summary 1

  • COUNTIF / COUNTIFS
  • AVERAGEIF / AVERAGEIFS
  • SUMIF / SUMIFS

Topic B: Conditional Data Extraction

  • IFERROR
  • IF
  • IFS & Nested IF

Topic A: Create and Modify Tables

  • Create table
  • Table Styles and Options
  • Removing Duplicate Values
  • Total Row with SubTotal Functions
  • Rename table
  • Convert table to range

Topic B: Data Validation

  • Data Validation Using Lists
  • Data Validation Using Whole Number / Decimal

Topic C: Sort and Filter Data

  • Sorting Data by value
  • Sorting data by color
  • Filtering Data

Topic A: Conditional Formatting

  • Highlight Cell Rules
  • Data Bars
  • Icon Sets

Topic B: Create Charts

  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns

Topic C: Modify and Format Charts

  • Formatting the Chart with a Style
  • Chart Elements
    • Title
    • Axis
    • Legend
    • Data Label
    • Data Table

Trainers

Reviews

Interested In

MICROSOFT EXCEL 2021 INTERMEDIATE_1D

Starting From
RM300
Class Type
Private, Public

Why Us

Variety of Courses

Variety of Courses

Customizable Class

Customizable Class

Consultants Facilitate

Consultants Facilitate

HRDF Claimable

HRDF Claimable

Professional Certifications

Professional Certifications

Free Chat to Get Quote

Free Chat to Get Quote

Related Courses

Book Now

Course Name: MICROSOFT EXCEL 2021 INTERMEDIATE_1D
Duration: 1 Day
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM
0.00

Enquire Now

Course Name *
Name *
Email *
Contact No. *
Enquiry For
Company Name *
Job Position *
Message *

Download Details

Name *
Email *
Contact No. *