Live Virtual Training (Most Popular!) > Microsoft Excel Foundation

Microsoft Excel Foundation

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

Course Objectives

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

Target Audience

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 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
Topic B Creating a New Blank Workbook
Module 2: Formatting a Worksheet
Topic A: Formatting Fonts
Topic B: Add Borders and Colors to Cells
Topic C: Apply Number Formats
Topic D: Align Cell Contents
Module 3: Modifying a Worksheet
Topic A: Manipulate Data
Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
Topic C – Search for and Replace Data
Topic D – Spell Check a Worksheet
Module 4: Performing Calculation
Topic A: Create Formulas in a Worksheet
Topic B: Insert Functions in a Worksheet
Module 5: Managing Large Workbooks
Topic A: Format Worksheet Tabs
Topic B: Manage Worksheets
Topic C: Manage the view of Worksheets and Workbooks
Module 6: Printing Workbook Contents
Topic A: Define the Basic Page
Topic B: Refine the Page Layout and Apply Print Options

Get To Know The Trainer

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

VIEW PROFILE

Trainer Shalina

4.5

Shalina has 20 years of experience in IT related fields including 11 years in conducting public courses. She specializes in Corporate IT infrastructure planning (networking, troubleshooting and system integration), conducts applications training programs such as Microsoft, Adobe, Lotus and COMPtia products as well as organizes and conducts exhibitions and seminars.

VIEW PROFILE

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.

VIEW PROFILE

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

VIEW PROFILE

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

VIEW PROFILE

View more trainers