MICROSOFT EXCEL (BASIC LEVEL)
Details
INTRODUCTION FOR MICROFOST EXCEL (BASIC LEVEL)
This course covers all the essentials of Microsoft Office Excel. Topics covered include the new Flash Fill feature, using formulas and functions, and customizing the interface. Material is also included on how to format text, data, and workbooks; and chart data.
COURSE OBJECTIVES
- How to create, open, and save workbooks
- How to enter, select, and delete data
- How to undo and redo
- Using cut, copy, and paste functions
- Inserting rows and columns
- How to merge and split cells
- Using Paste Special, find and replace, and hiding and unhiding cells
- How to use basic formulas
- How to learn basic and advanced functions
- How to run spell check.
- How to use the sort and filter tools to organize data
- How to use AutoFill, Flash Fill, AutoSum, AutoComplete, and AutoCalculate
- Various ways to format and work with text
- Various methods to chart data
- Ways to view and distribute a workbook
- Ways to customize the interface
Outline
COURSE CONTENT
- Module 1: The Basics
- Creating a New Workbook
- 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 Basic Excel Tools
- Understanding Cell References and Formulas
- Using Basic Formulas
- Using Basic Functions
- Using Advanced Functions
- Using Spell Check
- Using Sort and Filter
- Module 5: Using Timesaving Tools
- Using AutoFill
- Using Flash Fill
- Using AutoSum
- Using AutoComplete
- Using AutoCalculate
- Module 6: 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 7: Formatting Data
- Wrapping Text
- Changing the Size of Rows and Columns
- Adjusting Cell Alignment
- Changing Text Direction
- Changing Number Format
- Module 8: Formatting the Workbook
- Using Cell Styles
- Formatting Data as a Table
- Changing the Theme
- Inserting Page Breaks
- Adding a Background
- Module 9: Charting Data
- Creating Sparklines
- Inserting Charts
- Module 10: Viewing, Printing, and Sharing Your Workbook
- Using Views
- Saving a Workbook as PDF or XPS
- Printing a Workbook
- Module 11: Customizing the Interface
- Changing Ribbon Display Options
- Customizing the Quick Access Toolbar
- Hiding and Showing Ribbon Tabs
- Creating Custom Ribbon Tab
- Resetting Interface Changes
Special Offer
The promotion expiry date for each programmes differs. For more information on the exact expiry date of the promotion, feel free to contact us.
OTC Training Centre Sdn Bhd may at any time in its sole and absolute discretion withdraw, amend and/or alter the terms and conditions of the stated promotions without prior notice.
Schedules
| Mon, Tue | 09:00 AM — 05:00 PM |
Platform: Zoom
| No. of Days: | 2 |
| Total Hours: | 14 |
OTC Training Centre Sdn Bhd is an innovation leader in the development and delivery of practical outsourcing training programs for the past 17 years. Since then, OTC has supported thousands of companies to upskills their employees with personalized content and learning solutions. Today, we have evolved to provide a full suite of outsourcing services in the learning and development field.
Our training programs are entitled to HRDCorp claim, with our trainers being certified by HRDCorp as well. As a training provider, we aspire to keep providing the best training to our respected clients to ensure their satisfaction while using our service as the training provider.
Related Courses
