Fully Customizable Courseware For Trainers
Microsoft Excel 2013: Expert
DOWNLOAD A FREE SAMPLE
Teach your students Advanced Excel 2013 skills with this fully customizable Microsoft Excel 2013 Expert training course from Velsoft.
The 12 modules included in this course cover:
- Conditional formatting
- Slicers
- Power View
- Inquire Add-In
- Tables
- Records and Fields
- Excel as a database
- Custom AutoFill lists
- Comments
- Tracking Changes
- Linking, consolidating, and combining data
Each Velsoft training package includes an instructor guide, quick reference guide, exercise workbook, PowerPoint slides and more.
Download a free sample todayand see how we can help you deliver high-quality training.
Module 1: Using Conditional Formatting
Applying Conditional Formatting
Applying Multiple Rule Sets
Creating Custom Rule Sets
Viewing and Managing Rules
Clearing Custom Rules
Review Questions
Module 2: Working with Slicers
Inserting and Using a Slicer
Renaming the Slicer
Changing Slicer Settings
Formatting a Slicer
Clearing the Slicer
Review Questions
Module 3: Using Power View, Part One
Enabling Power View
Creating a Power View
Adding and Removing Fields
Arranging Fields
Filtering Data
Sorting Data
Review Questions
Module 4: Using Power View, Part Two
Refreshing Data
Choosing a Visualization
Changing Tile Display
Setting Display Options
Review Questions
Module 5: Using the Inquire Add-In
Installing Inquire
Generating a Workbook Analysis Report
Viewing Workbook and Worksheet Relationships
Viewing Cell Relationships
Comparing Two Workbooks
Review Questions
Module 6: Working with Tables
What is a Table?
Creating Tables
Resizing the Table
Choosing a Table Style
Clearing the Table
Review Questions
Module 7: Working with Records and Fields
What are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Deleting Records or Fields
Review Questions
Module 8: Using Excel as a Database
Filtering with Wildcard Characters
Validating Your Data
Data Validation Using Lists
Data Validation Using Formulas
Using Database Functions
Review Questions
Module 9: Using Custom AutoFill Lists
Creating a Custom AutoFill List
Using a Custom AutoFill List
Modifying a Custom AutoFill List
Deleting a Custom AutoFill List
Review Questions
Module 10: Using Comments
Inserting Comments
Editing Comments
Navigating Through Comments
Deleting Comments
Review Questions
Module 11: Tracking Changes
Tracking Changes
Reviewing Changes
Setting Options for Tracking Changes
Stopping Tracking Changes
Review Questions
Module 12: Linking, Consolidating, and Combining Data
Linking Workbooks
Consolidating Workbooks
Consolidating Worksheets
Pivoting Consolidated Data
Review Questions
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.
