MICROSOFT EXCEL (BASIC LEVEL)
Details
INTRODUCTION FOR MICROSOFT 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.
OBJECTIVE
- 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
The Basics
- Creating a New Workbook
- Parts of a Workbook
- Saving a Workbook
- Opening a Workbook
Your First Workbook
- Selecting Data
- Entering and Deleting Data
- Using Undo and Redo
- Using Cut, Copy, and Paste
Working with Data
- Inserting Rows and Columns
- Merging and Splitting Cells
- Moving Cells
- Using Paste Special
- Using Find and Replace
- Hiding and Unhiding Cells
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
Using Timesaving Tools
- Using AutoFill
- Using Flash Fill
- Using AutoSum
- Using AutoComplete
- Using AutoCalculate
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
Formatting Data
- Wrapping Text
- Changing the Size of Rows and Columns
- Adjusting Cell Alignment
- Changing Text Direction
- Changing Number Format
Formatting the Workbook
- Using Cell Styles
- Formatting Data as a Table
- Changing the Theme
- Inserting Page Breaks
- Adding a Background
Charting Data
- Creating Sparklines
- Inserting Charts
Viewing, Printing, and Sharing Your Workbook
- Using Views
- Saving a Workbook as PDF or XPS
- Printing a Workbook
Customizing the Interface
- Changing Ribbon Display Options
- Customizing the Quick Access Toolbar
- Hiding and Showing Ribbon Tabs
- Creating Custom Ribbon Tab
- Resetting Interface Changes
Schedules
Wed, Thu | 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.