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
How To Use This Book
Automating Worksheet Functionality
The Record Macro Dialog Box
Visual Basic for Applications
Copying Macros Between Workbooks
Macro Security Settings
The Conditional Formatting Rules Manager Dialog Box
The New Formatting Rule Dialog Box
The Data Validation Dialog Box
The Trace Cells Feature
The Error Checking Command
The Watch Window
The Outline Group
Analyzing and Presenting Data
Types of Sparklines
The Sparkline Tools – Design Tab
The What-If Analysis Tools
The Scenario Manager Dialog Box
Goal Seek Feature
The Solver Tool
The Data Analysis Dialog Box
The Power View Add-In
Enabling Power View
Creating a Power View
Working with Multiple Workbooks
The Consolidate Dialog Box
The Compare and Merge Workbooks Feature
Exporting Excel Data
The Export Process
The Import Process
The Get External Data Group
Delimited Text Files
Methods of Importing Text Files
The File Publishing Process
Publish as Web Page Dialog Box
The New Web Query Dialog Box
Importing and Exporting XML Data
The XML Source Task Pane
Import and Export XML Data
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
Keyboard Shortcut Quick Reference Sheet
Everything you need to deliver amazing training
Each courseware title is a trainers' kit that comes with the following course components:
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.
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.
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.
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.
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.