Fully Customizable Courseware For Trainers
Microsoft Excel 2016: Part One
DOWNLOAD A FREE SAMPLE
Microsoft Excel 2016 Part One, the first course in our Microsoft Excel 2016 series will give students a solid grasp of the basics, with lessons on:
- Getting started with Excel
- Performing calculations
- Modifying and formatting worksheets
- Printing workbook contents
- Managing large workbooks
- Customizing the Excel environment
Each component in this Microsoft Excel 2016 training package (including the instructor guide, student manual, quick reference guide, and PowerPoint slides)
is completely customizable. You can add your logo, rearrange lessons, create different examples, and much more.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1: Getting Started with Microsoft Excel 2016
TOPIC A: Identify the Elements of the Excel Interface
Microsoft Excel 2016
What are Spreadsheets, Worksheets, and Workbooks?
What are Columns, Rows, Cells, and Ranges?
The Excel Interface
Navigation Options
Creating a New Blank Workbook
Creating a New Workbook from a Template
Activity 1-1
TOPIC B: Create a Basic Worksheet
The Ribbon
The Backstage View
Data Types
Excel 2016 File Formats
The Save and Save As Commands
Saving to Microsoft OneDrive
Compatibility Mode
The Convert Option
The Compatibility Checker
Checking for Accessibility Issues
Activity 1-2
TOPIC C: Use the Help System
Using Tell Me
Accessing Advanced Help Options
Activity 1-3
Summary
Review Questions
Lesson 2: Performing Calculations
TOPIC A: Create Formulas in a Worksheet
Excel Formulas
The Formula Bar
Elements of an Excel Formula
Common Mathematical Operators
The Order of Operations
Activity 2-1
TOPIC B: Insert Functions in a Worksheet
Functions
The Function Library
Common Functions in Excel
The Formula AutoComplete Feature
Activity 2-2
TOPIC C: Reuse Formulas
The Cut, Copy, and Paste Commands
Paste Special Options
Relative References
Absolute References
Mixed References
Activity 2-3
Summary
Review Questions
Lesson 3: Modifying a Worksheet
TOPIC A: Manipulate Data
The Undo and Redo Commands
The AutoFill Feature
AutoFill Options
The Transpose Option
Live Preview
The Clear Button
Activity 3-1
TOPIC B: Insert, Manipulate, and Delete Cells, Columns, and Rows
The Insert and Delete Options
Column Width and Row Height Alternation Methods
The Hide and Unhide Options
Activity 3-2
TOPIC C: Search For and Replace Data
Cell Names and Range Names
The Find Command
The Replace Command
The Go To Command
Activity 3-3
TOPIC D: Spell Check a Worksheet
The Spelling Dialog Box
Activity 3-4
Summary
Review Questions
Lesson 4: Formatting a Worksheet
TOPIC A: Modify Fonts
Fonts
The Font Group
The Format Cells Dialog Box
The Format Painter
Galleries
Live Preview and Formatting
The Mini Toolbar
Activity 4-1
TOPIC B: Add Borders and Colors to Cells
Border Options
Fill Options
Sheet Backgrounds
Paste Options
Activity 4-2
TOPIC C: Apply Number Formats
Number Formats
Number Formats in Excel
Custom Number Formats
Activity 4-3
TOPIC D: Align Cell Contents
Alignment Options
The Indent Commands
The Wrap Text Command
Orientation Options
The Merge & Center Options
Activity 4-4
TOPIC E: Apply Cell Styles
Cell Styles
The Style Dialog Box
Activity 4-5
Summary
Review Questions
Lesson 5: Printing Workbook Contents
TOPIC A: Define the Basic Page Layout for a Workbook
The Print Options in Backstage View
The Page Setup Dialog Box
The Print Preview Option
Workbook Views
Headers and Footers
Header and Footer Settings
Page Margins
Margins Tab Options
Page Orientation
Activity 5-1
TOPIC B: Refine the Page Layout and Apply Print Options
Zoom Options
Page Breaks
Page Break Options
The Print Area
Print Titles
Scaling Options
Activity 5-2
Summary
Review Questions
Lesson 6: Managing Large Workbooks
TOPIC A: Format Worksheet Tabs
Renaming Worksheet Tabs
Changing Tab Color
Activity 6-1
TOPIC B: Manage Worksheets
Grouped Worksheets
Repositioning Worksheets
Inserting or Deleting Worksheets
Hiding and Unhiding Worksheets
Worksheet References in Formulas
Activity 6-2
TOPIC C: Manage the View of Worksheets and Workbooks
The Split Command
The Freeze Panes Options
The Arrange All Command
The Arrange Windows Dialog Box
The View Side by Side Command
The Switch Windows Command
The New Window Command
Activity 6-3
Summary
Review Questions
Lesson 7: Customizing the Excel Environment
TOPIC A: Customize General and Language Options
The Excel Options Dialog Box
The General Category
The Language Category
Activity 7-1
TOPIC B: Customize Formula Options
The Formulas Category
Activity 7-2
TOPIC C: Customize Proofing and Save Options
The Proofing Category
The Save Category
Version Control
Activity 7-3
TOPIC D: Customize the Ribbon and Quick Access Toolbar
The Customize Ribbon Category
The Quick Access Toolbar Category
Activity 7-4
TOPIC E: Customize the Functionality of Excel by Enabling Add-Ins
What Are Add-ins?
The Add-Ins Category
The Developer Tab
Activity 7-5
TOPIC F: Customize Advanced and Trust Center Options
The Advanced Category
The Trust Center Category
Activity 7-6
Summary
Review Questions
Lesson Labs
Lesson 1
Lesson Lab 1-1
Lesson 2
Lesson Lab 2-1
Lesson 3
Lesson Lab 3-1
Lesson Lab 3-2
Lesson 4
Lesson Lab 4-1
Lesson Lab 4-2
Lesson 5
Lesson Lab 5-1
Lesson 6
Lesson Lab 6-1
Lesson Lab 6-2
Lesson 7
Lesson Lab 7-1
Course Wrap-Up
Post-Course Assessment
Course Summary
Next Steps
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.
