EXC19B: Microsoft Excel 2019 Basic
Course Price
RM 300 (excluding 6% SST)
Duration: 1 days/8 hours
(9:00AM - 5:00PM)
Overview
In this Introduction to Microsoft Excel 2019 training class, students will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2019 worksheets.
Price
RM300 (excluding 6% SST)
Fee including:
-
Materials
-
Trained by Certified trainers
+
-
Students who have little or no familiarity with Microsoft Excel 2019 or more experienced Excel users who want to learn the topics covered in this course in the 2019 interface.
+
-
The inquiry process comprises three simple steps.
-
Submit Inquiry- Tell us a bit about yourself and the questions you want to enquire about. Use our CHAT feature or submit an enquiry form. You can also WhatsApp us on +601112216870 (Mr Vaheed)
-
Reviewing–Your questions will be processed and answered within a day or two
-
Response–Answers will typically be sent through email. However, you may tell us the option you prefer us to contact you in
+
-
-
Physical Classroom Training (Malaysia)
-
On-site Company Training (Malaysia)
-
Online Training via Microsoft Teams/ZOOM. (Malaysia and International)
+
-
Module 1: The Basics
-
Getting Started
-
Signing In
-
Creating a New Workbook
-
Understand the Basic Parts of a Workbook
-
Saving a Workbook
-
Opening a Workbook
Module 2: Your First Workbook
-
Selecting Data
-
Entering and Deleting Data
-
Using Undo and Redo
-
Using Cut, Copy, and Paste
Module 3: Working with Data
-
Inserting Rows and Columns
-
Merging and Splitting Cells
-
Moving Cells
-
Using Paste Special
-
Using Find and Replace
-
Hiding and Unhiding Cells
Module 4: Using Timesaving Tools
-
Using AutoFill
-
Using Flash Fill
-
Using AutoSum
-
Using AutoComplete
-
Using AutoCalculate
Module 5: Formatting Text
-
Changing the Font Face, Size, and Color
-
Applying Text Effects
-
Applying Borders and Fill
-
Using the Font Tab of the Format Cells Dialog
-
Clearing Formatting
Module 6: Formatting Data
-
Wrapping Text
-
Changing the Size of Rows and Columns
-
Adjusting Cell Alignment
-
Changing Text Direction
-
Changing Number Format
Module 7: Charting Data
-
Creating Sparklines
-
Inserting Charts
-
Drawing on Worksheet
Module 8: Viewing, Printing, and Sharing Your Workbook
-
Using Views
-
Saving a Workbook as PDF or XPS
-
Printing a Workbook
Module 9: Customizing the Interface
-
Changing Ribbon Display Options
-
Customizing the Quick Access Toolbar
-
Hiding and Showing Ribbon Tabs
-
Creating Custom Ribbon Tabs
-
Resetting Interface Changes