Industrial Deals Best Books of the Year So Far Our favorite denim: shop women's jeans nav_sap_plcc_ascpsc AWOLNATION New Moto G6 64 GB | $299.99. Save with Prime Exclusive Phones. Starting at $39.99 Grocery Handmade Personalized Jewelry modern furniture and decor Book a house cleaner for 2 or more hours on Amazon TheGrandTour TheGrandTour TheGrandTour  Echo All-new Show Mode Charging Dock Kindle Paperwhite GNO Shop now SWMTVT18_gno

Excel 2016 For Dummies Video Training

Season 1

Excel 2016 For Dummies introduces the basic features and functionality of this robust spreadsheet application.

This title is currently unavailable

Our agreements with the content provider don’t allow purchases of this title at this time.

By placing your order or playing a video, you agree to our Terms of Use. Sold by Amazon Digital Services LLC. Additional taxes may apply.

Not available

1. Overview

In this episode, Host Peter VanRysdam and Excel guru Ronnie Wong will introduce you to Microsoft Excel 2016 and let you know what you can expect to learn from this series.

Subtitles and Closed Captions Language: English Runtime: 3 minutes Release date: December 31, 2015

Not available

2. Discover the Interface

Before you can really get started with Microsoft Excel 2016, you need to get a lay of the land. In this episode, Ronnie and Peter review the interface of Excel 2016 including the ribbon, contextual menus, and navigating within a worksheet.

Subtitles and Closed Captions Language: English Runtime: 14 minutes Release date: December 31, 2015

Not available

3. Create a Spreadsheet

Not all data in Excel 2016 is created equally. Excel treats numbers like dates, currencies, and formulas different ways. In this episode, Ronnie and Peter show not only how to input information in to a spreadsheet, but how to tell excel what type of data it is.

Subtitles and Closed Captions Language: English Runtime: 10 minutes Release date: December 31, 2015

Not available

4. Create a Basic Formula

The real power within Microsoft Excel 2016 lies in formulas, which allow you to perform complex calculations instantaneously. Ronnie and Peter show you the different ways to create formulas, as well as how to use the formulas built in to Excel.

Subtitles and Closed Captions Language: English Runtime: 12 minutes Release date: December 31, 2015

Not available

5. Format in Excel

With the ability to hold seemingly endless amounts of data across thousands of rows and columns, working within Excel 2016 can be intimidating. Ronnie and Peter use this episode to break down the available formatting tools within Excel that allow you to style and organize your data.

Subtitles and Closed Captions Language: English Runtime: 16 minutes Release date: December 31, 2015

Not available

6. Print Excel Data

Printing a worksheet in Excel 2016 is not as simple as printing a document. In this episode, Ronnie and Peter not only show you the available print options, but offer tips for formatting your content so it prints in an easy-to-understand format.

Subtitles and Closed Captions Language: English Runtime: 14 minutes Release date: December 31, 2015

Not available

7. Organize a Workbook

It's important to understand the difference between a workbook and worksheets in Excel 2016, as well as how they can interact with one another. In this episode, Ronnie and Peter detail how to create and organize different worksheets while providing tips for sharing data across them.

Subtitles and Closed Captions Language: English Runtime: 14 minutes Release date: December 31, 2015

Not available

8. Adding Charts

Suffering from data overload? Charts are a great way to showcase your information while providing visual interest. Ronnie and Peter review the different types of charts and go through the steps to set them up in Excel 2016.

Subtitles and Closed Captions Language: English Runtime: 17 minutes Release date: December 31, 2015

Not available

9. Automate Tasks with Macros

Making changes to a sheet is one thing, but updating several at once can be time consuming. In this episode, Ronnie and Peter show you how macros can easily automate repetitive tasks to save you time and frustration.

Subtitles and Closed Captions Language: English Runtime: 11 minutes Release date: December 31, 2015

Not available

10. Customizing Excel

Don't like the way the contextual ribbons are laid out or the default fonts in Excel 2016? Well Ronnie and Peter will show you how you can customize those and other features to tailor your experience to your liking.

Subtitles and Closed Captions Language: English Runtime: 12 minutes Release date: December 31, 2015

Not available

11. Overcoming Obstacles in Excel

Getting stuck in Excel 2016? Before you chuck your computer out the window, take a look at some simple solutions to the most common issues users face while using the program.

Subtitles and Closed Captions Language: English Runtime: 16 minutes Release date: December 31, 2015

Customer Reviews

Share your thoughts with other customers
See all 9 customer reviews

Top customer reviews

December 5, 2016
Format: Amazon Video|Verified Purchase
7 people found this helpful
|Comment|Report abuse
September 11, 2016
Format: Amazon Video|Verified Purchase
7 people found this helpful
|Comment|Report abuse
July 17, 2016
Format: Amazon Video|Verified Purchase
20 people found this helpful
|Comment|Report abuse
June 6, 2017
Format: Amazon Video|Verified Purchase
March 4, 2017
Format: Amazon Video|Verified Purchase
One person found this helpful
|Comment|Report abuse
December 28, 2017
Format: Amazon Video|Verified Purchase
June 22, 2016
Format: Amazon Video|Verified Purchase
19 people found this helpful
|Comment|Report abuse
February 1, 2017
Format: Amazon Video