Your Career
Training Marketplace

Sign in SIGN UP FREE
Browse Catalog
Business Skills
All Your Business Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Finance
All Your Finance Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Health Care
All Your Health Care Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Human Resources
All Your Human Resources Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Industrial
All Your Industrial Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Information Technology
All Your IT Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Legal
All Your Legal Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677

Questions? Call Toll-Free: 1-866-540-9677

Business Skills
All Your Business Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Finance
All Your Finance Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Health Care
All Your Health Care Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Human Resources
All Your Human Resources Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Industrial
All Your Industrial Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Information Technology
All Your IT Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677
Legal
All Your Legal Training Needs In One Place.
- Choose a Category
- Business Essentials eLearning Library
  - Equip yourself with the skills you’ll need for your everyday business tasks. Everything from leadership and business concepts to IT, finance and more.
    Read More Register Now
    Instant Access
    From Anywhere
    
    Unlimited
    Viewing
    
    6-12 Months
    To Complete
- Request On-Site Training
  - With TrainUp’s On-Site Training Services, you get:
    Dedicated Private Event Representative Tenured & Award-Winning Instructor
    Customized Training Curriculum
    Affordable Cost Per Participant
    Flexible Scheduling
    …We bring the best to you!
    View More Info Request on-site training
- Corporate Discounts
  - TrainUp offers discounts to corporations buying content for multiple users. Please contact us to learn more.
    Contact Us (866) 540-9677

Course ID: 309865

Video Collection

Excel 2016 Video Collection

When you register for training with TrainUp.com, you are also supporting local education. Find out how.

In-Person Group Onsite Info

This Video Collection Contains 156 Videos. View All Titles.

Excel 2016 Video Collection

This Excel 2016 Video Collection e-learning and video micro-learning bundle contains 156 videos to enhance your skills. Courses are instantly accessible after purchase, viewing is unlimited, and you get 6 month-access to the library.

What is eLearning?

eLearning is a topical piece of online training material that is available to learn at your convenience. It is typically delivered in the form of videos or an interactive presentation, conducted via electronic media, through the web. eLearning courses are accessible on demand through your My Training Portal. Learn it when you need it!

Contents

156 Videos

COLLECTION PRICE

$199.00

View Courses

Looking for Group eLearning Options?

Instant Access
From Anywhere
Unlimited
Viewing
6-12 Months
To Complete

When you register for training with TrainUp.com, you are also supporting local education. Find out how.

Browse Videos Included In This Collection

Text Boxes

After watching this video; you will be able to add a text box to a Microsoft Excel 2016 worksheet.
Adding Watermarks

After watching this video; you will be able to use Word Art and images to create watermarks in Microsoft Excel 2016.
Creating Charts

After watching this video; you will be able to create a chart in Microsoft Excel 2016.
Adding Hyperlinks

After watching this video; you will be able to create a hyperlink in an Excel 2016 workbook.
Customizing the Ribbon

After watching this video; you will be able to modify the Ribbon layout in Excel 2016.
Tracking Changes in a Workbook

After watching this video; you will be able to manage changes in a Microsoft Excel 2016 Workbook.
Using Advanced Functions

After watching this video; you will be able to perform advanced queries in Microsoft Excel 2016.
Using Auto Fill to Copy Data

After watching this video; you will be able to copy data using Auto Fill in Microsoft Excel 2016.
Using Cell Styles

After watching this video; you will be able to apply cell styles to your data in Microsoft Excel 2016.
Using Flash Fill with Data Lists

After watching this video; you will be able to complete data lists using Flash Fill in Microsoft Excel 2016.
Using Macros

After watching this video; you will be able to configure macro security settings in Microsoft Excel 2016.
Using Named Cell Ranges in Formulas

After watching this video; you will be able to use named cell ranges in formulas in Microsoft Excel 2016.
Using Shapes

After watching this video; you will be able to add shapes and lines to a worksheet in Microsoft Excel 2016.
Using Subtotals

After watching this video; you will be able to calculate subtotals and grand totals in Microsoft Excel 2016.
Using Tables

After watching this video; you will be able to create a table in Microsoft Excel 2016.
Using the Spellchecker

After watching this video; you will be able to check your documents with the spellchecker.
Using Trendlines

After watching this video; you will be able to add trendlines to a chart in Microsoft Excel 2016.
VLOOKUP and HLOOKUP

After watching this video; you will be able to look up data using the VLOOKUP and HLOOKUP functions in Microsoft Excel 2016.
File Sharing

After watching this video; you will be able to share and publish your work in Microsoft Excel 2016.
Filter PivotTable Data

After watching this video; you will be able to filter PivotTable data with slicers in Microsoft Excel 2016.
Format Data in

After watching this video; you will be able to apply a cell style; formatting numbers and text; and modify the positioning of data in Microsoft Excel 2016.
Format Numerical Data

After watching this video; you will be able to apply formatting to different types of numerical data in Microsoft Excel 2016.
Format Text Boxes

After watching this video; you will be able to modify the look of a text box in Microsoft Excel 2016.
Formula Operators

After watching this video; you will be able to recognize Microsoft Excel 2016 formula operators.
Personalizing Display Options

After watching this video; you will be able to modify default display options in Excel 2016.
Printing in Excel 2016

After watching this video; you will be able to configure Excel 2016 worksheets and workbooks for printing.
Protecting Your Workbook

After watching this video; you will be able to apply different levels of protection to your Microsoft Excel 2016 Workbook.
Quick Conditional Formatting

After watching this video; you will be able to apply conditional formatting using Quick Analysis in Microsoft Excel 2016.
Recording Macros

After watching this video; you will be able to create a macro in Microsoft Excel 2016.
Refining Filters

After watching this video; you will be able to refine data filters in Microsoft Excel 2016.
Review and Share your Workbooks

After watching this video; you will be able to review and share existing Workbooks.
Running Macros

After watching this video; you will be able to run a macro in Microsoft Excel 2016.
Running Macros From the Interface

After watching this video; you will be able to run a custom macro from an interface element in Microsoft Excel 2016.
Saving a Workbook in Excel 2016

After watching this video; you will be able to save a workbook in Microsoft Excel 2016.
Saving to External Locations

After watching this video; you will be able to save a workbook to an online location in Microsoft Excel 2016.
SmartArt

After watching this video; you will be able to insert SmartArt into a Microsoft Excel 2016 worksheet.
Styling PivotTables

After watching this video; you will be able to alter the look of your PivotTable in Microsoft Excel 2016.
SUMIFS; AVERAGEIFS; and COUNTIFS

After watching this video; you will be able to use SUMIFS; AVERAGEIFS; and COUNTIFS in Microsoft Excel 2016.
Text; Shapes; and SmartArt

After watching this video; you will be able to add text; shapes; and SmartArt to a Microsoft Excel 2016 worksheet.
The DATE Function

After watching this video; you will be able to use the DATE function in Microsoft Excel 2016.
The Excel 2016 Interface

After watching this video; you will be able to recognize the different parts of the Microsoft Excel 2016 interface.
The IF Function

After watching this video; you will be able to apply conditional logic using the IF function in Microsoft Excel 2016.
The IFERROR Function

After watching this video; you will be able to handle errors using IFERROR in Microsoft Excel 2016.
The LOOKUP Function

After watching this video; you will be able to look up data using the LOOKUP function in Microsoft Excel 2016.
The NETWORKDAYS Function

After watching this video; you will be able to use the NETWORKDAYS function in Microsoft Excel 2016.
The SUM Function

After watching this video; you will be able to use the SUM function to calculate totals in Microsoft Excel 2016.
Adding Basic Data Validation

After watching this video; you will be able to implement basic data validation in a Microsoft Excel 2016 worksheet.
Adding Header and Footer Information

After watching this video; you will be able to add headers and footers to a Microsoft Excel 2016 workbook.
Adding Visual Effects to a Worksheet

After watching this video; you will be able to apply a theme and a watermark to a Microsoft Excel 2016 worksheet.
Adjust the Appearance of a Chart

After watching this video; you will be able to style a chart with a quick style in Microsoft Excel 2016.
Advanced Sparklines

After watching this video; you will be able to create custom sparklines in Microsoft Excel 2016.
Aligning Cell Data

After watching this video; you will be able to alter the alignment; indentation; and orientation of cell data in Microsoft Excel 2016.
Applying Functions within Formulas

After watching this video; you will be able to use the IF function with other functions in Microsoft Excel 2016.
Applying Text Formatting

After watching this video; you will be able to format text data in Microsoft Excel 2016.
AutoSum Functions

After watching this video; you will be able to calculate the AVERAGE; COUNT; MIN; and MAX of a column or row of numbers in Microsoft Excel 2016.
Basic Formulas

After watching this video; you will be able to create basic number and text formulas in Microsoft Excel 2016.
Basic Logical Functions

After watching this video; you will be able to use the AND; OR; and NOT functions in Microsoft Excel 2016.
Basic Sorting

After watching this video; you will be able to sort data alphabetically and numerically in Microsoft Excel 2016.
Basic Sparklines

After watching this video; you will be able to create and edit basic sparklines in Microsoft Excel 2016.
Borders and Fills

After watching this video; you will be able to apply borders and fills to cells in Microsoft Excel 2016.
Chart Templates

After watching this video; you will be able to create a chart template from an existing chart in Microsoft Excel 2016.
Charts and Tables

After watching this video; you will be able to add tables and charts to a worksheet in Microsoft Excel 2016.
Co-authoring

After watching this video; you will be able to work with others on the same document in Microsoft Excel 2016.
Color Sorting

After watching this video; you will be able to sort data by cell or font color in Microsoft Excel 2016.
Columns and Rows

After watching this video; you will be able to insert and resize columns and rows in Microsoft Excel 2016.
Complete a Series Using Auto Fill

After watching this video; you will be able to fill a series using Auto Fill in Microsoft Excel 2016.
Configuring Window Views

After watching this video; you will be able to select window view options in Excel 2016.
Configuring Workbook Views

After watching this video; you will be able to select workbook view options in Excel 2016.
Converting Text to Columns

After watching this video; you will be able to convert text to columns in Microsoft Excel 2016.
Copy Cell Formatting with Format Painter

After watching this video; you will be able to use the Format Painter tool to copy formatting in Microsoft Excel 2016.
Create a PivotChart

After watching this video; you will be able to use recommended charts to create a PivotChart in Microsoft Excel 2016.
Create a PivotChart from a PivotTable

After watching this video; you will be able to use PivotTable data to create a PivotChart in Microsoft Excel 2016.
Create and Open Workbooks

After watching this video; you will be able to create Microsoft Excel 2016 workbooks and open existing documents.
Create and Save an Excel Workbook (VSAE)

After watching this video; you will be able to create an Excel 2016 document; add data to it; enter property information; and save it.
Create Macros

After watching this video; you will be able to record a simple Macro in Microsoft Excel 2016.
Creating Custom Templates

After watching this video; you will be able to create and modify custom templates in Excel 2016.
Creating Form Fields

After watching this video; you will be able to create custom form fields in Excel 2016.
Creating Formulas and Using Functions

After watching this video; you will be able to create a formula and named cell range in Microsoft Excel 2016.
Creating PivotTables

After watching this video; you will be able to create a PivotTable in Microsoft Excel 2016.
Creating PivotTables and PivotCharts

After watching this video; you will be able to present data in PivotTables and PivotCharts.
Custom Cell Styles

After watching this video; you will be able to create a custom cell style in Microsoft Excel 2016.
Custom Conditional Formatting

After watching this video; you will be able to create custom conditional formatting rules in Microsoft Excel 2016.
Custom Filters

After watching this video; you will be able to create a custom filter in Microsoft Excel 2016.
Custom Formatting

After watching this video; you will be able to create custom text and numerical formats in Microsoft Excel 2016.
Custom Sorts

After watching this video; you will be able to configure a custom sort in Microsoft Excel 2016.
Customizing Columns and Rows

After watching this video; you will be able to modify default column and row settings in Excel 2016.
Customizing Data Validation

After watching this video; you will be able to apply advanced data validation in Microsoft Excel 2016.
Customizing Themes

After watching this video; you will be able to modify and save a theme in Microsoft Excel 2016.
Customizing Themes and Colors

After watching this video; you will be able to create custom color formats in Excel 2016.
Customizing Views and Layout

After watching this video; you will be able to configure appropriate views; layout; and visual elements in Excel 2016.
Customizing Your Data

After watching this video; you will be able to use hyperlinks; conditional formatting; and sparklines to customize the look of your data in Microsoft Excel 2016.
Defining Named Cell Ranges

After watching this video; you will be able to create named cell ranges in Microsoft Excel 2016.
Deleting and Hiding Excel 2016 Data

After watching this video; you will be able to delete or hide cell; row; and column data in Microsoft Excel 2016.
Dual Axis Charts

After watching this video; you will be able to create a dual axis chart in Microsoft Excel 2016.
Edit PivotTable Data

After watching this video; you will be able to modify the data in a PivotTable in Microsoft Excel 2016.
Enter Data in a Worksheet

After watching this video; you will be able to add data to a Microsoft Excel 2016 worksheet.
Excel Themes

After watching this video; you will be able to apply a theme to a Worksheet in Microsoft Excel 2016.
Exporting Excel 2016 Data

After watching this video; you will be able to export Excel 2016 document data in different formats.
Group and Ungroup Data

After watching this video; you will be able to create data summaries using groups in Microsoft Excel 2016.
Images; Headers; and Footers

After watching this video; you will be able to add images; headers; and footers in Microsoft Excel 2016.
Insert a Screenshot

After watching this video; you will be able to add screenshot and screen clippings to a worksheet in Microsoft Excel 2016.
Insert an Image

After watching this video; you will be able to add images to a worksheet in Microsoft Excel 2016.
Link to Access Databases

After watching this video; you will be able to add and manage connections to an Access database in Microsoft Excel 2016.
Link to Other Workbooks

After watching this video; you will be able to link to data in another Workbook in Microsoft Excel 2016.
Making Your Data Work

After watching this video; you will be able to sort; group; filter; and validate data in Microsoft Excel 2016.
Managing Excel 2016 Worksheets

After watching this video; you will be able to create and customize worksheets in Microsoft Excel 2016.
Merging and Splitting

After watching this video; you will be able to merge and split cell data in Microsoft Excel 2016.
Modify a Chart

After watching this video; you will be able to modify an existing chart in Microsoft Excel 2016.
Modify a Table

After watching this video; you will be able to modify an existing table in Microsoft Excel 2016.
Modify an Image

After watching this video; you will be able to modify an image using Microsoft Excel 2016 tools.
Modify Excel 2016 Document Properties

After watching this video; you will be able to add properties information to a Microsoft Excel 2016 document.
Modifying Cell Styles

After watching this video; you will be able to create and modify cell styles in Excel 2016.
Modifying Existing Hyperlinks

After watching this video; you will be able to modify an existing hyperlink in an Excel 2016 workbook.
Modifying PivotCharts

After watching this video; you will be able to alter the data in a PivotChart in Microsoft Excel 2016.
Modifying SmartArt

After watching this video; you will be able to edit SmartArt you have added to a Microsoft Excel 2016 worksheet.
Moving Data in Excel 2016

After watching this video; you will be able to cut; copy; and paste data in Microsoft Excel 2016.
Multiple Workbooks

After watching this video; you will be able to manage multiple Workbooks in Microsoft Excel 2016.
NOW and TODAY Functions

After watching this video; you will be able to use the NOW and TODAY functions in Microsoft Excel 2016.
Online Services

After watching this video; you will be able to sign in to Microsoft Excel 2016 and add a OneDrive service.
Order of Operations

After watching this video; you will be able to recognize the order of operations in Microsoft Excel 2016.
Using Comments

After watching this video; you will be able to add and modify comments in a Microsoft Excel 2016 workbook.
Find and Replace Data

After watching this video; you will be able to search a workbook to find and replace data in Microsoft Excel 2016.
Transposing Data

After watching this video; you will be able to use TRANSPOSE to alter a worksheet in Microsoft Excel 2016.
Customizing the Quick Access Toolbar

After watching this video; you will be able to modify the Quick Access Toolbar layout in Excel 2016.
Using Filters

After watching this video; you will be able to filter data in Microsoft Excel 2016.
Microsoft Excel 2016: Data Tables with Two Variables

After watching this video, you will be able to create a two-variable data table in Microsoft Excel 2016.
Microsoft Excel 2016: Data Tables

After watching this video, you will be able to create a single variable data table in Microsoft Excel 2016.
Microsoft Excel 2016: Setting up Power Pivot

After watching this video, you will be able to configure Power Pivot and import data into a Microsoft Excel 2016 Workbook.
Microsoft Excel 2016: Experiment with Values

After watching this video, you will be able to Use Goal Seek, Scenario Manager, and Data Tables to try different values in Microsoft Excel 2016.
Microsoft Excel 2016: Managing Add-ins in Excel

After watching this video, you will be able to insert and manage an add-in in Microsoft Excel 2016.
Microsoft Excel 2016: Adding Office Add-ins to Excel

After watching this video, you will be able to add an app-in for Microsoft Excel 2016 to your Microsoft account.
Microsoft Excel 2016: Using Solver

After watching this video, you will be able to determine a value based on a number of variables using Solver in Microsoft Excel 2016.
Microsoft Excel 2016: Goal Seek

After watching this video, you will be able to use Goal Seek to find required input values in Microsoft Excel 2016.
Microsoft Excel 2016: Consolidating Scenario Information

After watching this video, you will be able to create a summary report of scenarios in a Microsoft Excel 2016 Worksheet.
Microsoft Excel 2016: Scenario Manager

After watching this video, you will be able to create and compare scenarios using scenario manager in Microsoft Excel 2016.
Microsoft Excel 2016: Merging Scenarios

After watching this video, you will be able to merge scenarios in Microsoft Excel 2016.
Microsoft Excel 2016: Advanced Custom Conditional Formatting

After watching this video, you will be able to create custom conditional formatting rules in Microsoft Excel 2016.
Microsoft Excel 2016: Advanced Filters

After watching this video, you will be able to apply complex filtering criteria to data in Microsoft Excel 2016.
Microsoft Excel 2016: Altering Custom Rules

After watching this video, you will be able to modify custom conditional formatting rules in Microsoft Excel 2016.
Microsoft Excel 2016: Checking Accessibility

After watching this video, you will be able to check for accessibility issues in Microsoft Excel 2016.
Microsoft Excel 2016: Customizing Data

After watching this video, you will be able to use custom formats, filters, and fill series when working with data in Microsoft Excel 2016.
Microsoft Excel 2016: Create a PivotTable Using PowerPivot

After watching this video, you will be able to create and populate a PivotTable using PowerPivot in Microsoft Excel 2016.
Microsoft Excel 2016: Connecting Tables

After watching this video, you will be able to create a PivotTable using Power Pivot in Microsoft Excel 2016.
Microsoft Excel 2016: Custom Date and Time Formats

After watching this video, you will be able to create a custom date and time format in Microsoft Excel 2016.
Microsoft Excel 2016: Custom Number Formats

After watching this video, you will be able to create a custom number format in Microsoft Excel 2016.
Microsoft Excel 2016: Custom Fill Series

After watching this video, you will be able to create a custom fill series in Microsoft Excel 2016.
Microsoft Excel 2016: Custom Accounting Formats

After watching this video, you will be able to create a custom accounting format in Microsoft Excel 2016.
Microsoft Excel 2016: Checking for Errors

After watching this video, you will be able to run the error checker in Microsoft Excel 2016.
Microsoft Excel 2016: Troubleshoot Formulas

After watching this video, you will be able to troubleshoot formulas using the evaluate formula tool in Microsoft Excel 2016.
Microsoft Excel 2016: Tracing Errors

After watching this video, you will be able to trace errors in Microsoft Excel 2016.
Microsoft Excel 2016: Combine Data and Check it for Errors

After watching this video, you will be able to use Microsoft Excel 2016 transform features to work with data, and check it for errors.
Microsoft Excel 2016: Displaying Data in International Formats

After watching this video, you will be able to prepare a workbook for internationalization in Microsoft Excel 2016.
Microsoft Excel 2016: Adjusting the Tab Order

After watching this video, you will be able to modify the tab order between workbook elements in Microsoft Excel 2016.
Microsoft Excel 2016: Get & Transform

After watching this video, you will be able to use Get & Transform to pull together data from different sources in Microsoft Excel 2016.
Microsoft Excel 2016: Ensuring Workbook Accessibility

After watching this video, you will be able to adjust a workbook to ensure accessibility and optimal tab order.
Microsoft Excel 2016: Unpivot Data

After watching this video, you will be able to use the unpivot columns feature to transform data in Microsoft Excel 2016.

Join The 50,000+ Companies That Have Purchased Training from TrainUp.com

50K+ Companies Trained
Including 90% Of Fortune 500 Companies Have Purchased Training With TrainUp.com
300K+ Courses & Videos
Live Instructor-Led (Classroom & Virtual), Self-Paced E-learning & Custom OnSite Training Solutions From Leading Training Providers
800+ Expert Instructors
Industry-Leading Subject Matter Experts (SMEs).Tenured &
Award-Winning Instructor Network

Terms and Conditions

Please read these Terms and Conditions carefully before using Capital One Spring member exclusives (the “Service”) at TrainUp.com.

Your access to and use of the Service is conditioned upon your acceptance of and compliance with these Terms. These Terms apply to all Capital One Spring members who wish to access or use the Service and by accessing or using the Service you agree to be bound by these Terms.

This site uses cookies. We will never sell or rent your information. By signing up for a TrainUp.com account as a Capital One Spring member, you will receive emails in relationship to your content registration and monthly updates. You will only receive emails from TrainUp.com and never a third-party source.

By signing up for a free TrainUp.com account you will be asked to provide basic information about yourself and company, If you wish to purchase any product or service made available through the Service, you may be asked to supply certain additional information relevant to your purchase.

The Service may employ the use of third-party services to allow access to course contents. By submitting your information, you grant us the right to provide the information to these third parties as needed to support your use of the service.

You acknowledge and agree that TrainUp.com shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with use of or reliance on any such content, goods or services available on or through any such third party web sites or services.

We may terminate or suspend your account and bar access to the service immediately, without prior notice or liability, under our sole discretion, for any reason whatsoever and without limitation, including but not limited to a breach of the Terms. If you wish to terminate your account, you may simply discontinue using the service.