Duration
Microsoft Excel 2019 (Basic)
1 day
Outline
9:00am-10:30am
Module 1: The Basics
- Creating a New Workbook
- Understand the Basic Parts of a Workbook
- Saving a Workbook
- Opening a Workbook
10:30am-10:45pm Morning Break
10:45pm-12:30pm
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
12:30pm-1:30pm Lunch
1:30pm-3:30pm
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
3:30pm-3:45pm Afternoon Break
3:45pm-5:00pm
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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.