TARGET AUDIENCE
Designed for anyone with minimal or no prior knowledge of Microsoft Excel 365 and looking to acquire solid foundational skills to perform basic spreadsheet functions.
PRE-REQUISITE
Basic knowledge of computers, using the keyboard, mouse and Windows is required.
LEARNING OUTCOME
In this course, participants will:
Discover features this Excel application offers to increase productivity and convenience, such as the ability to access spreadsheets anywhere and share with collaborators.
Understand how to work simultaneously on a spreadsheet.
Learn the basics of creating, editing, and saving spreadsheets.
Increase knowledge of editing spreadsheets and be able to proficiently use the new interface.
Learn formatting options to make data more readable and emphasize important sections.
Recognize how to organize and display data in Charts, improving the visual readability of data trends.
Course Outline ::EXC365B::
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 Auto Calculate
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
Course Outline ::EXC365B::
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
Programme scope, delivery arrangements and suitability are confirmed during enquiry.