Microsoft Excel 2019 Foundation | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Microsoft Excel 2019 Foundation

Location

Format What’s this?
Starting From
RM 99.00
  1. 1 Days
  1. HRDF SBL Claimable
  2. Lunch & refreshment provided
  3. Certificate of Attendance available

All of our private classes are customized to your organization's needs.


Click on the button below to send us your details and you will be contacted shortly.

  1. 1 Days

Microsoft Excel 2019 Foundation

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


METHODOLOGY

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

COURSE OBJECTIVES

• Give participant a systematic understanding of a spreadsheet ad its benefits

• Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day business environment


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


Expand All

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 Titles

• Scaling Options


Azrulnizam Bin Ahmad

Azrulnizam Bin Ahmad

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.He is an energetic, independent, goal-oriented individual that has a high work standard and is committed to his work. He is also a good planner, is creative and resourceful, has great leadership charisma and works well with others. Read More

Jarina Muhamad Ismail

Jarina Muhamad Ismail

Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Course Reviews

No Remarks

0

0 Ratings