Fully Customizable Courseware For Trainers
Microsoft 365 Excel: Online
Our mission is to provide you with the best possible courseware so you can teach incredible classes and workshops
High quality course content - written for you
Save hundreds of hours in developing training materials. Download our proven content used by trainers in 164 countries worldwide.
Enjoy confidence in the classroom
Facilitate perfect workshops everytime with high-quality training material with all the training components you need.
Save time & money with pre-written materials
Focus your attention on the training and we'll take care of the materials.
Course description
This course will help you get up to speed with using Microsoft Excel Online — Microsoft’s cloud-based spreadsheet program — teaching how to create a spreadsheet; how to work with basic formulas and functions; and how to make a spreadsheet look presentable.
For more information, Download a free sample.
Course outline
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
What you get
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.
Sample Files
Each Velsoft courseware title comes with a Lab Workbook loaded with activities and exercises to practice and reinforce the learners' understanding of the course objectives. 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 workshop. This includes PowerPoint slides for classroom use, 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 in two pages the most important elements in each courseware title.
The best courseware in the world has Velsoft on the cover.
Our goal is to improve the daily life of those who train the world.
Velsoft empowers training providers with course material and educational technologies that get results.
Fully customizable
Easily make any changes to the material you like. Simply open in MS Word or Google Docs and localize the content to meet your training needs.
Unlimited reprinting
Print only what you need, when you need it. Print as many copies at your location as you like - forever. This includes editing and printing.
Unlimited users
Train as many people at your location as you like - forever. There is no per-user pricing or limit on the number of people that can be trained.
No annual renewal fees
This course comes with a perpetual license which means once you purchase it you never have to pay anything ever again.
COURSEWARE SAMPLE
Courseware you can customize.
View an eLearning Course
SCORM COMPLIANT
Available as an eLearning Course
ELEARNING SAMPLE
eLearning you can customize.
COURSEWARE SAMPLE
Courseware you can customize.
Safe & Inclusive Workplace
By Velsoft
Seeing Double
August Only
COURSEWARE SAMPLE
Courseware you can customize.