Microsoft Excel 2019 Intermediate

Microsoft Excel 2019 Intermediate







2 Days


Public Class

Public Class

Elevate Your Skills with Microsoft Excel Training

Are you ready to supercharge your career with Microsoft Excel training? Look no further than Info Trek’s ‘Microsoft Excel 2019 Intermediate’ course. This comprehensive program is designed for clerks, officers, executives, supervisors, administrators, and managers of all levels who want to take their Microsoft Excel proficiency to the next level.

Unleash Your Microsoft Excel Potential

This course goes beyond the basics and equips you with the tools to tackle real-world challenges. From mastering complex formulas and functions to data visualization and managing large workbooks, you’ll gain the skills and confidence needed to excel in today’s competitive job market.

Why Microsoft Excel Training Matters

In the fast-paced corporate world, Microsoft Excel skills are more critical than ever. By enrolling in this course, you’re not just learning; you’re investing in your future. You’ll be better equipped to analyze data, make informed decisions, and stand out in your career. Don’t miss this opportunity to boost your Microsoft Excel expertise with Info Trek’s expert-led training. Your success story begins here.

Course Details

Course Code: EX19I- 1; Instructor-led



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.


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.


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 simple to complex formulas and functions, like:
    • COUNTA & COUNTIFS Function
    • SUMIF & SUMIFS Function
    • IF Functions
  • Filter data using Auto & Advanced Filters
  • Clean Duplicate Records
  • Visualizing Data as a Graphics



  • Relative References
  • Absolute References
  • Mixed References

Topic A: Data Summary with Function


Topic B: Conditional Data Summary 1


Topic C: Conditional Data Extraction

  • IF

Topic A: Create and Modify Tables

  • Create table
  • Styles and Quick Style Sets
  • Removing Duplicate Values

Topic B: Sort and Filter Data

  • Sorting Data
  • Filtering Data
  • Advanced Filtering

Topic C: Use Subtotal to Calculate Data

  • Total Row with SubTotal Functions

Topic A: Conditional Formatting

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

Topic B: Create Charts

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

Topic C: Modify and Format Charts

  • Chart Elements
  • Minimize Extraneous Chart Elements
  • The Chart Tools Contextual Tabs
  • Formatting the Chart with a Style
  • Adding a Legend to the Chart

Topic A: Format Worksheet Tabs

  • Renaming Worksheet Tabs
  • Changing Tab Colour

Topic B: Manage Worksheets

  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas

Topic C: Manage the view of Worksheets and Workbooks

  • Split Command
  • Freeze Panes options
  • Arrange All Command
  • Arrange Windows Dialog Box
  • View Side by Side Command
  • Switch windows Command
  • New Window Command

Topic A:  Define the Basic Page Layout for a Workbook

  • The Print Options in Backstage View
  • The Page Setup Dialog Box
  • The Print Preview Option
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation

Topic B: Refine the Page Layout and Apply Print Options

  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options



Interested In

Microsoft Excel 2019 Intermediate

Starting From
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 2019 Intermediate
Duration: 2 Days
Class Type *
Intake Date *
First Name *
Last Name *
Email *
Contact No. *
Pax *
Total Price: RM

Enquire Now

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

Download Details

Name *
Email *
Contact No. *