Microsoft Excel 2021 Intermediate

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

Course Objectives

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

  • Create 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
  • Visualizing Data as a Graphics

Target 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.

 

Methodology

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

Course Modules

Module 1:  Referencing Calculations

Topic A: Formula Reference

  • Relative References
  • Absolute References
  • Mixed References

Topic B: Apply Range Names

  • Adding a Range Names Using the Name Box
  • Adding a Range Names Using Define Name
  • Adding multiple names using Create from Selection
  • Editing and Deleting Range Name Using Name Manager
  • Using Range Names in Formulas

Module 2: Working with Functions

Topic A: Data Summary with Function

  • COUNTA
  • AVERAGEA

Topic B: Conditional Data Summary 1

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

Topic C: Conditional Data Extraction

  • IFERROR
  • IF
  • IFS & Nested IF

Topic D: Conditional Data Summary 2

  • DSUM
  • DCOUNT / DCOUNTA
  • DAVERAGE
  • DMAX
  • DMIN

Module 3: Organize Dynamic Data Range with Table

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
  • Data Validation Using Date

Topic C: Sort and Filter Data

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

Module 4: Data Visualization

Topic A: Conditional Formatting

  • Highlight Cell Rules
  • Data Bars
  • Icon Sets
  • Creating New Rules with Formula

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

Topic D: Adding Sparklines

  • Adding Sparklines
  • Removing Sparklines

Topic E: Editing Sparklines

  • Showing and Hiding Data
  • Changing the Style
  • Changing the Sparkline and Marker Color
  • Setting Axis Options

Module 5: Setting Up Reports as Pages

Topic A: Working with Different Views

  • Using Page Break Preview for Page Setup
  • Using Page Layout View for Express Header & Footer
  • Using Custom view

Get To Know The Trainer

Trainer Azrul

 

Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation

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

Trainer Izham

 4.5

Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.

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).

Trainer Nazarudin

 4.5

Nazarudin Aziz started freelancing as a Corporate Trainer since the year of 2005 specializing in the field of Multimedia Graphic Designer and Microsoft Office Applications. His list of clients are Perodua, Grand Pacific Hotel, Cosway, UDA Mall, Institut Teknologu Rekabentuk Perabot Malaysia, Telekom Malaysia, Lembaga Tabung Haji, Yayasan Pelajaran MARA, Kementerian Pembangunan Wanita & Masyarakat, Hospital Tengku Ampuan Rahimah Klang, United Engineers Malaysia, Malaysian Maritime & Dredging Corporation, Jabatan Perdana Menteri, Indah Water Consotrium and many more.

Trainer Slyvia

 

Sylvia has been in the IT Training Industry for the past 20 years She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Microsoft and Adobe applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs

Trainer Patrick

 

Patrick Cheah has been involved in the IT and Training industry since 2002. He is very passionate about sharing knowledge and providing technical solutions. A Microsoft Certified Trainer and a member of the Toastmasters International, he has conducted trainings since 2005 to clients from various sectors. Patrick is also involved in writing and publishing online articles, promotional write-ups and event reports in several web portals.

  View more trainers

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE BENEFITS

ALL IN FROM ONLY

RM0/DAY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.8

  • 89%
  • 0%
  • 11%
  • 0%
  • 0%
  • NR
    NURUL FATIN ATIQAH BINTI ABD RAHIM
    Junior Executive, HR / Learning and Development

    5

  • MR
    MOHAMMAD ASYRUL BIN ABD RASHID
    Executive, Engineering

    5

  • M
    Manimaran
    Senior Executive, Manufacturing / Production

    5

    Should be
  • Ns
    Nor syareeza binti mohammad shazlan
    Junior Executive, Manufacturing / Production

    5

  • ZA
    Zuraiha Abdullah
    Junior Executive, Quality Assurance

    5

  • MA
    Madam Noradzlin Abd Aziz
    Junior Executive, Engineering

    5

  • NF
    NORHAYATI MOHD FUZI
    Senior Executive, Quality Assurance

    5

    Good
  • C
    Cheeranan
    Executive, Engineering

    5

  • TT
    Thanigesh Thiyagu
    Executive, Engineering

    3

Courses you may like

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?