Fully Customizable Courseware For Trainers
Microsoft 365 Excel: Online
DOWNLOAD A FREE SAMPLE
This comprehensive course has been meticulously designed to facilitate your rapid mastery of Microsoft Excel Online, the cloud-based spreadsheet program offered by Microsoft. Throughout the course, you will gain proficiency in various essential aspects, starting with the fundamentals of creating a spreadsheet. You will then delve into the intricacies of working with basic formulas and functions, empowering you to perform calculations and analyses with ease. Additionally, the course focuses on enhancing your spreadsheet presentation skills, ensuring that you can create visually appealing and professional-looking documents.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How to Use This Book
Lesson 1: Getting Started
TOPIC A: Getting Started with Excel Online
Logging into Office 365
Launching Excel Online
The Excel Online Interface
Creating a New Workbook
Closing Excel Online
Activity 1-1: Getting Started with Excel Online
TOPIC B: Getting to Know Excel
What are Spreadsheets, Worksheets, and Workbooks?
What are Columns, Rows, Cells, and Ranges?
Navigating in Excel
Excel Formulas
Activity 1-2: Getting to Know Excel
TOPIC C: Managing Workbooks
Opening a Workbook
Editing Your Workbook in Excel Desktop
Accessing Save Options
Using the Accessibility Checker
Printing a Workbook
Sharing a Workbook
Activity 1-3: Managing Workbooks
TOPIC D: Getting Help in Excel Online
Using the Help tab
Giving Feedback About Office
Activity 1-4: Getting Help in Excel Online
Summary
Review Questions
Lesson 2: Working with Data
TOPIC A: A Closer Look at Formulas
The Formula Bar
Elements of an Excel Formula
Mathematical Operators
The Order of Operations
Types of References
Activity 2-1: A Closer Look at Formulas
TOPIC B: Using Formulas and Functions
About Functions
Creating a Function with AutoComplete
Using the Insert Function Dialog Box
Using AutoSum
Viewing AutoSum Calculations in the Status Bar
Automatic Workbook Calculations
Activity 2-2: Using Formulas and Functions
TOPIC C: Working with Data
Selecting Cells
The Cut, Copy, and Paste Commands
Using Paste Options
Moving Data with Drag and Drop
The Undo and Redo Commands
Using AutoFill
Using Flash Fill
Activity 2-3: Working with Data
TOPIC D: Working with Rows and Columns
Inserting Rows and Columns
Deleting Rows and Columns
Clearing Data from Cells
Changing Column Width and Row Height
The Hide and Unhide Options
Activity 2-4: Working with Rows and Columns
TOPIC E: Sorting and Filtering Data
The Difference Between Sorting and Filtering
Sorting Data
Enabling Filtering
Using Text Filters
Clearing a Filter
Activity 2-5: Sorting and Filtering Data
Summary
Review Questions
Lesson 3: Formatting a Worksheet
TOPIC A: Formatting Text
What is a Font?
The Font Group
The Format Painter
Creating Links
Activity 3-1: Formatting Text
TOPIC B: Formatting Cells
Applying a Border
Applying a Fill
Changing the Number Format
Customizing Number Formats
Activity 3-2: Formatting Cells
TOPIC C: Aligning Cell Content
Alignment Options
The Indent Commands
The Wrap Text Command
Merge & Center Options
Activity 3-3: Aligning Cell Content
TOPIC D: Using Find & Select Tools
The Find Command
The Replace Command
The Go To Command
Activity 3-4: Using Find & Select Tools
TOPIC E: Applying Conditional Formatting
What is Conditional Formatting?
Applying Conditional Formatting Rules
Setting Conditional Formatting Options
Clearing Conditional Formatting
Activity 3-5: Applying Conditional Formatting
Summary
Review Questions
Lesson 4: Adding Pictures and Shapes
TOPIC A: Inserting Pictures
Inserting Pictures
Resizing Pictures
Rotating Pictures
Deleting Pictures
Adding Alternative Text
Activity 4-1: Inserting Pictures
TOPIC B: Inserting Shapes
Inserting Shapes
The Shape Tab
Resizing Shapes
Deleting Shapes
Activity 4-2: Inserting Shapes
TOPIC C: Formatting Shapes
Changing the Shape Type
Applying a Style
Customizing Shape Fill and Outline
Adding Alternative Text
Activity 4-3: Formatting Shapes
Summary
Review Questions
Lesson 5: Organizing Worksheet Data with Tables and Charts
TOPIC A: Inserting Tables
What is a Table?
Creating a Table
Customizing Row Display
Inserting and Deleting Table Rows and Columns
Sorting and Filtering Table Data
Activity 5-1: Inserting a Table
TOPIC B: Inserting Charts
Chart Types
Chart Elements
Inserting a Chart
The Chart Contextual Tab
Moving Charts
Resizing Charts
Activity 5-2: Inserting Charts
TOPIC C: Modifying Charts
Switching Row and Column Display
Use the Select Data Command
Changing the Chart Type
Adding a Chart Title
Modifying Chart Labels
Modifying Chart Axes
Activity 5-3: Modifying Charts
Summary
Review Questions
Lesson 6: Using PivotTables
TOPIC A: Inserting PivotTables
What is a PivotTable?
Creating a PivotTable
The PivotTable Fields Task Pane
Working with PivotTable Data
Activity 6-1: Inserting PivotTables
TOPIC B: Working with PivotTable Data
Expanding and Collapsing Data
Refreshing Data
Using the Value Field Settings Menu
Summarizing Values
Changing Value Display
Activity 6-2: Working with PivotTable Data
TOPIC C: Sorting and Filtering PivotTable Data
Sorting Data
Using the Filters Pane
Using Label and Value Filters
Clearing Filters
Activity 6-3: Sorting and Filtering PivotTable Data
Summary
Review Questions
Lesson 7: Finalizing Workbooks
TOPIC A: Using Comments
Inserting Comments
Showing and Hiding the Comments Pane
Replying to Comments
Deleting Comments
Activity 7-1: Working with Comments
TOPIC B: Managing Worksheets (Part One)
Viewing Worksheets
Inserting Worksheets
Deleting Worksheets
Duplicating Worksheets
Worksheet References in Formulas
Activity 7-2: Managing Worksheets (Part One)
TOPIC C: Managing Worksheets (Part Two)
Hiding and Unhiding Worksheets
Reordering Worksheets
Renaming Worksheet Tabs
Changing Tab Color
Activity 7-3: Managing Worksheets (Part Two)
TOPIC D: Changing View Options
Showing and Hiding Workbook Elements
The Freeze Panes Options
Activity 7-4: Changing View Options
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson 2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson 3
Lesson Lab 3-1
Lesson Lab 3-2
Lesson Lab 3-3
Lesson 4
Lesson Lab 4-1
Lesson Lab 4-2
Lesson 5
Lesson Lab 5-1
Lesson Lab 5-2
Lesson 6
Lesson Lab 6-1
Lesson 7
Lesson Lab 7-1
Lesson Lab 7-2
Course Wrap-Up
Post-Course Assessment
Course Summary
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
Instructor Guide
Velsoft Instructor Guides are the core of each training course. Our Instructor Guides lay out the training in simple, easy-to-follow instructions. You can also customize the Instructor Guides in order to personalize your training.
Student Manual
Each Instructor Guide - for each course - is paired with a Student Manual that you can present to your participants. This customizable Student Manual gives each participant the ?student? version of the course you will be teaching.
Exercise Workbook
Velsoft offers an Exercise Workbook (also customizable) that is specific to the course you are offering. You can choose whether this is something you would like to present to your students.
Sample Files
Pre-made Sample Exercise Files are provided for use with the Lab Workbook so that you, as the trainer, do not have to prepare activity working files.
PowerPoint Deck
Courseware from Velsoft is designed to give you everything you need for use in the classroom or for your workshop. This includes the PowerPoint versions of all the courses, prepared for you in advance.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quick Reference Guide summarizes the most important elements in each courseware title down to two pages.
Fully Customizable
Make any changes you like including easily taking our branding off and replacing it with yours.
Unlimited Users
Train as many participants at your location as you like - forever!
Unlimited Printing Rights
Print-on-demand only what you need for as many participants with no limits.
No Annual Renewal Fees
One-off pricing. Never pay again to use the materials.
