Duration
Microsoft Excel (Basic)
1 day
Course Overview
This one-day Microsoft Excel Basic course introduces essential Excel skills for beginners. Participants will learn to navigate the interface, manage data, and use key tools for productivity. By the end, they will confidently create and format spreadsheets.
Target Audience
Ideal for beginners, office professionals, students, entrepreneurs, and anyone looking to build a strong foundation in Excel
Learning Outcomes
Participants will be able to:
- Navigate and use Excel effectively.
- Enter, edit, and format data.
- Apply basic formulas and functions.
- Manage and visualize data with charts.
- Print and share workbooks with ease.
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.