Fully Customizable Courseware For Trainers
Microsoft 365 Excel
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
Microsoft Excel 365 is a spreadsheet program that enables users to work with and store data in a table. It is part of Microsoft’s cloud-based subscription to a suite of programs that also includes Word, Outlook, and PowerPoint.
This course will help users get up to speed with the basics of Excel 365. By the end of this course, users should be comfortable with creating a new spreadsheet, working with basic formulas and functions, and making a spreadsheet look professional and presentable.
Topics include: working with formulas and functions; formatting parts of a worksheet; using pictures, tables, charts, and PivotTables; and finalizing workbooks.
Each Velsoft course package comes complete with all the tools needed to deliver a comprehensive training session including an instructor guide, student manual, quick reference guide, PowerPoint slides, and more.
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 PowerPoint 365
Logging into Office 365
Launching PowerPoint 365
Creating a Presentation
The PowerPoint 365 Interface
Closing PowerPoint 365
Activity 1-1: Getting Started with PowerPoint 365
TOPIC B: Creating Presentations
Opening a Presentation
Creating a New Presentation
Editing Your Presentation in PowerPoint Desktop
Accessing Download Options
Printing a Presentation
Sharing a Presentation
Activity 1-2: Creating Presentations
TOPIC C: Editing Presentations
The Default PowerPoint Template
Using Text Boxes
Using Text and Content Placeholders
Adding Slide Notes
Using AutoCorrect
Activity 1-3: Editing Presentations
TOPIC D: Viewing a Presentation
Presentation Views
Using Zoom
Using Fit to Window
Starting a Slide Show
Slide Show Features
Activity 1-4: Viewing a Presentation
TOPIC E: Getting Help in PowerPoint 365
Using Tell Me
Accessing Advanced Help Options
Activity 1-5: Getting Help in PowerPoint 365
Summary
Review Questions
Lesson 2: Developing a PowerPoint Presentation
TOPIC A: Building a Presentation
Inserting New Slides
Changing the Slide Layout
Rearranging Slides
Duplicating Slides
Hiding and Showing Slides
Deleting Slides
Activity 2-1: Building a Presentation
TOPIC B: Editing Text and Objects
Selecting Text and Objects
Cut, Copy, and Paste Options
Duplicating Objects
Undo and Redo Commands
Using Find
Activity 2-2: Editing Text and Objects
TOPIC C: Formatting Text
About Fonts
Formatting Options
The Mini Toolbar
The Format Painter
Creating Links
Activity 2-3: Formatting Text
TOPIC D: Formatting Paragraphs
Creating Bulleted and Numbered Lists
Changing Horizontal Text Alignment
Changing Vertical Text Alignment
Indenting Text
Changing Spacing
Changing Text Direction
Using the Paragraph Dialog Box
Activity 2-4: Formatting Paragraphs
Summary
Review Questions
Lesson 3: Working with Images and Shapes
TOPIC A: Inserting Graphics
Inserting Shapes
Inserting Text Boxes
Inserting Symbols
Inserting Local Pictures
Inserting Online Pictures
Inserting Online Videos
Activity 3-1: Inserting Graphics
TOPIC B: Modifying Objects
Selecting Objects
Resizing Objects
Rotating Images
Arranging Objects
Deleting Objects
Activity 3-2: Modifying Objects
TOPIC C: Formatting Objects
Applying a Style
Customizing the Fill
Customizing the Outline
Adding Text to a Shape
Adding Alternative Text
Activity 3-3: Formatting Objects
TOPIC D: Adjusting Image Appearance
Using the Picture Tools – Format Tab
Applying Picture Styles
Cropping Images
Changing an Image
Resetting an Image
Activity 3-4: Adjusting Image Appearance
Summary
Review Questions
Lesson 4: Working with SmartArt
TOPIC A: Creating SmartArt
What is SmartArt?
Inserting SmartArt
The SmartArt Tools Contextual Tab
Adding Text to SmartArt
Deleting SmartArt
Activity 4-1: Creating SmartArt
TOPIC B: Modifying SmartArt
Resizing SmartArt
Adding and Removing Shapes
Promoting and Demoting Shapes
Changing the Direction
Adding Alternative Text
Activity 4-2: Modifying SmartArt
TOPIC C: Formatting SmartArt
Changing the Layout
Changing the Color Scheme
Changing the Style
Resetting the Graphic
Activity 4-3: Formatting SmartArt
Summary
Review Questions
Lesson 5: Working with Tables
TOPIC A: Creating Tables
What is a Table?
Creating a Table
The Table Tools – Design Contextual Tab
The Table Tools – Layout Contextual Tab
Activity 5-1: Creating Tables
TOPIC B: Editing Tables
Selecting Rows, Columns, and Tables
Inserting and Deleting Rows and Columns
Resizing the Table
Resizing Rows and Columns
Merging and Splitting Cells
Activity 5-2: Editing Tables
TOPIC C: Formatting Tables
Applying a Table Style
Customizing the Table Style
Applying Cell Shading
Changing Cell Alignment
Activity 5-3: Formatting Tables
Summary
Review Questions
Lesson 6: Finishing Your Presentation
TOPIC A: Animating Objects
Applying an Animation
Setting Effect Options
Changing the Timing
Removing Animations
Activity 6-1: Animating Objects
TOPIC B: Applying Transitions
Applying Transitions
Setting Effect Options
Customizing Transition Timing
Using Apply to All
Activity 6-2: Applying Transitions
TOPIC C: Customizing Design Options
Changing Slide Size
Applying Themes
Using Theme Variants
Changing the Background Style
Using the Design Ideas Task Pane
Checking Accessibility
Activity 6-3: Customizing Design Options
TOPIC D: Working with Comments
Inserting Comments
Showing and Hiding the Comments Pane
Replying to Comments
Deleting and Editing Comments
Tag Comments
Activity 6-4: Working with Comments
TOPIC E: Co-authoring Presentations
Getting Started
Collaborating on Shared Presentations
Using Chat
Activity 6-5: Co-authoring Presentations
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson Lab 1-2
Lesson 2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson 3
Lesson Lab 3-1
Lesson Lab 3-2
Lesson 4
Lesson Lab 4-1
Lesson 5
Lesson Lab 5-1
Lesson 6
Lesson Lab 6-1
Lesson Lab 6-2
Lesson Lab 6-3
Course Wrap-Up
Course Summary
Post-Course Assessment
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
Index
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.
Exercise Workbook
Whether or not you choose to introduce exercises into your training is up to you as the facilitator. In case you want to do this Velsoft offers you an Exercise Workbook (also customizable) that is specific to the course you are offering.
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 the PowerPoint versions of all the courses, prepared for you in advanced.
Quick Reference Guide
Quick Reference Guides are a favorite tool for trainers to provide to their learners. Each Quest Reference Guide summarizes the most important elements in each courseware title down to two pages.
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.