EX19F(1) Microsoft Excel – Foundation (Online Training)

4.6

Course Objectives

  • 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

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

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, discussions and practical exercise

Course Modules

  • Module 1: Getting Started with Microsoft Excel 2019

    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
  • Module 2: Formatting a Worksheet

    Topic A: Modify Fonts
    – Fonts
    – The Font Group
    – The Format Cells Dialog Box
    – The Format Painter
    – Live Preview and Formatting
    – The Mini Toolbar

    Topic B: Add Borders and Colors 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
    – Orientation Options
    – The Merge & Center Options

    Topic E: Apply Cell Styles
    – Cell Styles
    – The Style Dialog Box

  • Module 3: Modifying a Worksheet

    Topic A: Manipulate Data
    – The Undo and Redo Commands
    – The AutoFill Feature
    – Auto Fill Options
    – The Transpose Option
    – Live Preview
    – The Clear Button

    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

  • Module 4: Managing Large Workbooks

    Topic A: Format Worksheet Tabs
    – Renaming Worksheet Tabs
    – Changing Tab Color

    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

  • Module 5: Performing Calculation

    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)

  • Module 6: Printing Workbook Contents

    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 Area
    – Scalling Options

Get To Know The Trainer

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.

Chat with us LIVE to get a

FREE QUOTATION!

THIS PUBLIC COURSE INCLUDES

CLASS DETAILS

ALL IN FROM ONLY

RM0/PAX

*T&C Applies

4.6

  • 68%
  • 26%
  • 5%
  • 0%
  • 0%
  • LK
    LENG WAI KONG
    Senior Manager, Operations

    5

    Great trainer En.Azrul
  • CL
    Chin Yoke Lin
    Assistant Manager, Operations

    5

  • Rw
    Ronald loo thim wah
    Assistant Manager, Sales

    5

  • H
    Hongsyeagiin
    Manager / Supervisor, Operations

    5

  • lq
    lee jia qi
    Manager / Supervisor, Sales

    5

  • EL
    Esther Low
    Junior Executive, Marketing / Design

    5

  • HF
    Hosea Fong
    Executive, Sales

    5

  • LC
    LIM KIM CHENG
    Assistant Manager, Operations

    5

  • RM
    ROSLI BIN MOHAMAD
    Junior Executive, Accounting and Finance

    5

  • UG
    Umadarshini A/P S Gnanapupathi
    Assistant Manager, Operations

    5

  • FI
    Fatin Nurfarahin Bt Mohd Izam
    Junior Executive, Project Management

    5

  • SF
    Siti Nur Fareesha
    Executive, Marketing / Design

    5

    Good!
  • NK
    Nurul Afiqah Binti Khiruddin
    Assistant Manager, Procurement / Purchasing

    5

  • NR
    Nik Nornaimah Binti Ahmad Rujhan
    Executive, Operations

    4

  • LJ
    Lee Fu Jin
    Executive, Sales

    4

  • MZ
    MUHAMAD FAIZAL BIN ZAKARIYAH
    Senior Executive, Engineering

    4

  • MZ
    MUHAMAD FAIZAL BIN ZAKARIYAH
    Senior Executive, Engineering

    4

  • TE
    Tan Tiong Eng
    Junior Executive, Administration / Secretarial

    4

  • WM
    Wong Seau Mun
    Assistant Manager, Administration / Secretarial

    3

OF 2Next

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?