Microsoft Excel 2019 Foundation

Microsoft Excel 2019 Foundation







1 Day


Public Class

Public Class

Excel Training: Unlocking Your Full Potential

Dive into the World of Microsoft Excel

Are you ready to supercharge your career with top-notch Microsoft Excel training? Look no further than the ‘Microsoft Excel 2019 Foundation’ course offered by Info Trek, Malaysia’s leading provider of corporate technology training. This isn’t just another course; it’s your ticket to mastering the art of Microsoft Excel and enhancing your professional journey.

Microsoft Excel Mastery for All

Designed for individuals at every career level, from clerks to managers, this course is tailored to help you harness the true power of Microsoft Excel 2019. No matter where you stand in your career, a solid grasp of Microsoft Excel is a game-changer. From identifying the elements of the Microsoft Excel interface to performing complex calculations and managing large workbooks, this training covers it all.

Excel Training: Your Career Catalyst

Imagine being the Microsoft Excel whiz in your office, effortlessly handling data, creating stunning spreadsheets, and impressing your colleagues and superiors. With ‘Microsoft Excel 2019 Foundation,’ you’ll gain the skills and confidence to make this a reality. This course isn’t just about learning Microsoft Excel; it’s about propelling your career to new heights. So, why wait? Join us at Info Trek and let’s embark on this Microsoft Excel adventure together.

Unlock your Microsoft Excel potential and transform your career today!

Course Details

Course Code: EX19F-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 Windows is essential with the following pre-requisites:

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to configure the desktop
  • Able to use the Control Panel
  • Able to move and re-size Application Windows
  • Able to switch between task applications


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:

  • Getting Started with Microsoft Excel 2019, Identify the Elements, and Interface of Excel
  • Performing Calculation, Basic Formula and Functions
  • Modify worksheet & Formatting Worksheet
  • Printing and managing large workbook


Topic A – Identify the Elements of the Excel Interface

  • Microsoft Excel 2019
  • What is Spreadsheet, Worksheet and Workbook
  • What are Columns, Row, Cells, and Ranges
  • The Excel Interface
  • Navigation Options

Topic B Creating a New Blank Workbook

  • The Ribbon
  • The Backstage View
  • The Save and Save As Commands

Topic A: Formatting Fonts

  • Fonts
  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Live Preview and Formatting
  • The Mini Toolbar
  • The Clear Button

Topic B: Add Borders and Colours to Cells

  • Border Options
  • Fill Options
  • Sheet Backgrounds

Topic C: Apply Number Formats

  • Number Formats
  • Dragging and Dropping Cells
  • How to cut, copy, and paste cells
  • How to cut, copy, and Paste Multiple cells
  • Using the Clipboard
  • Using Paste Special
  • Number Formats in Excel
  • Custom Number Formats

Topic D: Align Cell Contents

  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Orientation Options
  • The Merge & Center Options

Topic E: Apply Cell Styles

  • Cell Styles
  • The Style Dialog Box

Topic A: Manipulate Data

  • The Undo and Redo Commands
  • The AutoFill Feature
  • Auto Fill Options
  • The Transpose Option
  • Live Preview

Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows

  • The Insert and Delete options
  • Column Width and Row Height Alternation Methods
  • The Hide and Unhide Options

Topic C – Search for and Replace Data

  • The Find Command
  • The Replace Command
  • The Go to Command

Topic D – Spell Check a Worksheet

  • The Spelling Dialog Box

Topic A: Create Formulas in a Worksheet

  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations
  • Division Formula

Topic B: Insert Functions in a Worksheet

  • Functions
  • The Function Library
  • Common Functions in Excel (SUM, AVERAGE, COUNT, MIN & MAX)

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 Foundation

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 Foundation
Duration: 1 Day
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. *