Fully Customizable Courseware For Trainers
Microsoft Excel 2016: Part Three
DOWNLOAD A FREE SAMPLE
Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.
These Velsoft training materials build on what was learned in the first two courseware offerings for Excel 2016 — Part One and Part Two.
The comprehensive Part Three training package offers lessons on the following topics:
- Automating worksheet functionality
- Auditing worksheets
- Analyzing and presenting data
- Working with multiple workbooks
- Exporting Excel data
- Importing and exporting XML data
Each component in Microsoft Excel 2016: Part Three is completely customizable. You can add your logo, rearrange lessons, create different examples, and much more. Each training package contains an instructor guide, student manual, quick reference guide, and PowerPoint slides.
Download a?free sample today and see how easy training can be.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1:
Automating Worksheet Functionality
Workbook Properties
Activity 1-1
Macros
The Record Macro Dialog Box
Naming Macros
Visual Basic for Applications
Copying Macros Between Workbooks
Macro Security Settings
Activity 1-2
Conditional Formatting
Conditional Formats
The Conditional Formatting Rules Manager Dialog Box
The New Formatting Rule Dialog Box
Clear Rules
Activity 1-3
Data Validation
The Data Validation Dialog Box
Activity 1-4
Summary
Review Questions
Lesson 2:
Auditing Worksheets
The Trace Cells Feature
Tracer Arrows
Activity 2-1
Invalid Data
The Error Checking Command
Error Types
Activity 2-2
The Watch Window
Formula Evaluation
Activity 2-3
Outlines
The Outline Group
Activity 2-4
Summary
Review Questions
Lesson 3:
Analyzing and Presenting Data
Sparklines
Types of Sparklines
The Sparkline Tools – Design Tab
Activity 3-1
Scenarios
The What-If Analysis Tools
The Scenario Manager Dialog Box
Activity 3-2
Add-In Types
Goal Seek Feature
The Solver Tool
Activity 3-3
Analysis ToolPak
The Data Analysis Dialog Box
Activity 3-4
The Power View Add-In
Enabling Power View
Creating a Power View
Activity 3-5
Summary
Review Questions
Lesson 4:
Working with Multiple Workbooks
Data Consolidation
The Consolidate Dialog Box
Consolidation Functions
Activity 4-1
External References
Activity 4-2
The Compare and Merge Workbooks Feature
Activity 4-3
Summary
Review Questions
Lesson 5:
Exporting Excel Data
The Export Process
Activity 5-1
The Import Process
The Get External Data Group
Delimited Text Files
Methods of Importing Text Files
Activity 5-2
The File Publishing Process
Publish as Web Page Dialog Box
Activity 5-3
Web Queries
The New Web Query Dialog Box
Activity 5-4
Summary
Review Questions
Lesson 6:
Importing and Exporting XML Data
XML
XML Components
XML Schemas
XML Maps
The XML Source Task Pane
Import and Export XML Data
Activity 6-1
Summary
Review Questions
Lesson Lab 1-1
Lesson Lab 1-2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson Lab 3-1
Lesson Lab 3-2
Lesson Lab 4-1
Lesson Lab 5-1
Lesson Lab 5-2
Lesson Lab 6-1
Appendices
Keyboard Shortcut Quick Reference Sheet
Glossary
Index
Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This version of Excel incorporates some new features and integration of features that were previously only available as separate add-ins.
These Velsoft training materials build on what was learned in the first two courseware offerings for Excel 2016 — Part One and Part Two.
The comprehensive Part Three training package offers lessons on the following topics:
- Automating worksheet functionality
- Auditing worksheets
- Analyzing and presenting data
- Working with multiple workbooks
- Exporting Excel data
- Importing and exporting XML data
Each component in Microsoft Excel 2016: Part Three is completely customizable. You can add your logo, rearrange lessons, create different examples, and much more. Each training package contains an instructor guide, student manual, quick reference guide, and PowerPoint slides.
Download a?free sample today and see how easy training can be.
About This Course
Course Prerequisites
Course Overview
Course Objectives
How To Use This Book
Lesson 1:
Automating Worksheet Functionality
Workbook Properties
Activity 1-1
Macros
The Record Macro Dialog Box
Naming Macros
Visual Basic for Applications
Copying Macros Between Workbooks
Macro Security Settings
Activity 1-2
Conditional Formatting
Conditional Formats
The Conditional Formatting Rules Manager Dialog Box
The New Formatting Rule Dialog Box
Clear Rules
Activity 1-3
Data Validation
The Data Validation Dialog Box
Activity 1-4
Summary
Review Questions
Lesson 2:
Auditing Worksheets
The Trace Cells Feature
Tracer Arrows
Activity 2-1
Invalid Data
The Error Checking Command
Error Types
Activity 2-2
The Watch Window
Formula Evaluation
Activity 2-3
Outlines
The Outline Group
Activity 2-4
Summary
Review Questions
Lesson 3:
Analyzing and Presenting Data
Sparklines
Types of Sparklines
The Sparkline Tools – Design Tab
Activity 3-1
Scenarios
The What-If Analysis Tools
The Scenario Manager Dialog Box
Activity 3-2
Add-In Types
Goal Seek Feature
The Solver Tool
Activity 3-3
Analysis ToolPak
The Data Analysis Dialog Box
Activity 3-4
The Power View Add-In
Enabling Power View
Creating a Power View
Activity 3-5
Summary
Review Questions
Lesson 4:
Working with Multiple Workbooks
Data Consolidation
The Consolidate Dialog Box
Consolidation Functions
Activity 4-1
External References
Activity 4-2
The Compare and Merge Workbooks Feature
Activity 4-3
Summary
Review Questions
Lesson 5:
Exporting Excel Data
The Export Process
Activity 5-1
The Import Process
The Get External Data Group
Delimited Text Files
Methods of Importing Text Files
Activity 5-2
The File Publishing Process
Publish as Web Page Dialog Box
Activity 5-3
Web Queries
The New Web Query Dialog Box
Activity 5-4
Summary
Review Questions
Lesson 6:
Importing and Exporting XML Data
XML
XML Components
XML Schemas
XML Maps
The XML Source Task Pane
Import and Export XML Data
Activity 6-1
Summary
Review Questions
Lesson Lab 1-1
Lesson Lab 1-2
Lesson Lab 2-1
Lesson Lab 2-2
Lesson Lab 3-1
Lesson Lab 3-2
Lesson Lab 4-1
Lesson Lab 5-1
Lesson Lab 5-2
Lesson Lab 6-1
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 manual gives each participant the student version of the course you will be teaching.
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.
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.
