Home Sample Files e-Books Books Wholesale Forums & Support Contact
Basic Skills
Essential Skills Expert Skills Construction Kits
2016 2013 2010 2007 Apple Mac

Convert a range into a table and add a total row:

Lesson 1-11 from: Microsoft Excel 2016 Expert Skills (0 Video Lessons)
Convert a range into a table and add a total row
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Before you watch your first video you need to know three things!
1. This is a walk-through and not a stand-alone video lesson
The walk-through is intended to be used only with an e-book or paper book. Read and work through the printed lesson first. Only watch the video walk-through if you have difficulty with it.
2. Video walk-throughs do not have a sound track
Reading out the lesson steps (shown in the captions) wouldn't add any value. If a wordy narrative was added it would bloat the walk-through and make it less useful for its intended purpose.
3. Make sure that you use the interactive transcript and e-book button
Jump straight to the step you need to see using the interactive transcript. window. Just click on the step you need. Play with the other buttons too - you'll never have seen some of the features our player has before.
OK - I’ve got it! Don't show this again.
Back 10 Seconds
Full Screen View
Online Video Course: Microsoft Excel 2016 Expert Skills
Session: Session 1: Tables and Ranges
Lesson: Lesson 1-11 Convert a range into a table and add a total row Tables in Excel. Thumbnail from Excel 2016 Expert Skills Lesson 1-11 Convert a range into a table and add a total row.

This video lesson provides a full introduction to Excel 2016's Table feature, which is one of the most important advanced features in Excel. This lesson explains Tables and shows how to create a new Table, apply totals to it, and understand the SUBTOTAL function that is used to create the totals. The SUBTOTAL function is covered in depth in this lesson, including how to switch between SUM and AVERAGE totals and how to include or exclude hidden values in totals. This lesson also explains how to use Quick Analysis to create Tables and subtotals, and how Slicers can be used to filter Tables.