Fully Customizable Courseware For Trainers
Microsoft 365 Excel: Part 2
DOWNLOAD A FREE SAMPLE
This is the second part of Velsoft’s Microsoft Office Excel 365 courseware. This version of Excel incorporates some new features and connectivity options in an effort to make collaboration and production as easy as possible.
This course is intended to help all users get up to speed on the different features of Microsoft Excel 365 and to become familiar with its more advanced selection of features. It covers how to create and use advanced formulas, analyze data, organize worksheet data with tables, visualize data with charts, insert graphics, and enhance workbooks.
This course uses the online version of Excel 365, not the desktop version.
By the end of this course, users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, inserting graphics, and enhancing workbooks.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How to Use This Book
Lesson 1: Creating Advanced Formulas
TOPIC A: Apply Range Names
Range Names
Adding Range Names Using the Name Box
Adding Range Names Using the New Name Dialog Box
Using Range Names in Formulas
Activity 1-1: Using Range Names in Formulas
TOPIC B: Use Specialized Functions
Function Categories
Function Syntax
Finding Excel Functions
Function Entry Dialog Boxes
Using Nested Functions
Automatic Workbook Calculations
Showing and Hiding Formulas
Enabling Iterative Calculations
Activity 1-2: Using Specialized Functions
Summary
Review Questions
Lesson 2: Analyzing Data with Logical and Lookup Functions
TOPIC A: Use Text Functions
Text Functions
The LEFT and RIGHT Functions
The MID Function
The LEN Function
The TRIM Function
The UPPER, LOWER, and PROPER Functions
The TEXTJOIN Function
The TRANSPOSE Function
Activity 2-1: Analyzing Data Using Text Functions
TOPIC B: Use Logical Functions
Logical Functions
Logical Operators
The AND Function
The OR Function
The IF Function
The IFS Function
Activity 2-2: Analyzing Data Using Logical Functions
TOPIC C: Use Lookup Functions
Lookup Functions
The LOOKUP Function
The VLOOKUP Function
The HLOOKUP Function
The MATCH Function
The INDEX Function
Activity 2-3: Analyzing Data Using Lookup Functions
TOPIC D: Use Date Functions
The TODAY Function
The NOW Function
Serializing Dates and Times with Functions
Activity 2-4: Analyzing Data Using Date Functions
TOPIC E: Use Financial Functions
The IPMT Function
The PPMT Function
The NPV Function
The FV Function
Activity 2-5: Using Financial Functions
Summary
Review Questions
Lesson 3: Organizing Worksheet Data with Tables
TOPIC A: Create and Format Tables
Tables
Table Components
The Create Table Dialog Box
The Table Design Contextual Tab
Styles and Quick Style Sets
Customizing Row Display
Activity 3-1: Creating and Modifying a Table
TOPIC B: Modifying Tables
Adding Rows and Columns
Total Row Functions
Removing Duplicate Values
Activity 3-2: Modifying Tables
TOPIC C: Table References
Naming Tables
Using Structured References
Database Functions
Converting to Range
Activity 3-3: Table References
Summary
Review Questions
Lesson 4: Visualizing Data with Charts
TOPIC A: Create Charts
Charts
Chart Types
Chart Insertion Methods
Resizing and Moving the Chart
Adding Additional Data
Switching Between Rows and Columns
Activity 4-1: Creating Charts
TOPIC B: Modify and Format Charts
The Difference Between Modifying and Formatting
Chart Elements
Minimize Extraneous Chart Elements
The Chart Contextual Tabs
Formatting the Chart with a Style
Adding a Legend to the Chart
Activity 4-2: Modifying and Formatting Charts
TOPIC C: Create a Trendline
Trendlines
Types of Trendlines
Adding a Trendline
The Format Trendline Task Pane
Activity 4-3: Create a Trendline
TOPIC D: Create Advanced Charts
Combination Charts
Dual Axis Charts
Creating Custom Chart Templates
Activity 4-4: Creating Advanced Charts
Summary
Review Questions
Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts
TOPIC A: Create a PivotTable
PivotTables
Start with Questions, End with Structure
The Create PivotTable Dialog Box
The PivotTable Fields Task Pane
Summarize Data in a PivotTable
The “Show Values As” Functionality of a PivotTable
Format a PivotTable
External Data
PowerPivot
PowerPivot Functions
Activity 5-1: Creating PivotTables
TOPIC B: Filter Data Using Slicers
Slicers
The Insert Slicers Dialog Box
Activity 5-2: Filtering Data Using Slicers
TOPIC C: Analyze Data with PivotCharts
PivotCharts
Creating PivotCharts
Applying a Style to a PivotChart
Activity 5-3: Analyzing Data with PivotCharts
Summary
Review Questions
Lesson 6: Working with Graphical Objects
TOPIC A: Insert and Modify Graphic Objects
Graphical Objects
Inserting Shapes
Inserting WordArt
Inserting Text Boxes
Inserting Images
The Picture Format Contextual Tab
The Shape Format Contextual Tab
The SmartArt Contextual Tabs
Activity 6-1: Inserting Graphical Objects
TOPIC B: Layer and Group Graphical Objects
Layering Objects
Grouping Objects
Positioning Objects
Activity 6-2: Layering and Grouping Shapes
TOPIC C: Incorporate SmartArt
About SmartArt
The Choose a SmartArt Graphic Dialog Box
About the Text Pane
Activity 6-3: Incorporating SmartArt
Summary
Review Questions
Lesson 7: Enhancing Workbooks
TOPIC A: Customize Workbooks
Notes and Comments
Comments
Notes
Watermarks
Background Pictures
Activity 7-1: Customizing Workbooks
TOPIC B: Manage Themes
About Themes
Customizing Themes
Activity 7-2: Managing Themes
TOPIC C: Protect Files
Recovering Lost Data
The Protect Group
The Protect Worksheet Option
The Protect Workbook Option
Mark Workbooks as Final
Encrypting a Workbook
Digitally Signing a Workbook
Activity 7-3: Protecting a Worksheet and a Workbook
TOPIC D: Preparing a Workbook for Multiple Audiences
Displaying Data in Multiple International Formats
Utilize International Symbols
Adding Alternative Text to Objects
Activity 7-4: Preparing a Workbook for Multiple Audiences
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 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
Index
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.
