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

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

Lesson 1-11 from: Microsoft Excel 2013 Expert Skills (167 Video Lessons)
Convert a range into a table and add a total row
Play Video
Play The Video
ExcelCentral Icon ExcelCentral.com
Play
Back 10 Seconds
Slower
Faster
Full Screen View
Online Video Course: Microsoft Excel 2013 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 Expert Skills Lesson 1-11 Convert a range into a table and add a total row.
Description:

This video lesson provides a full introduction to Microsoft Excel'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.

Share on Facebook
Share on Twitter
Share on Google+
Share on Reddit
Share on Tumblr
Share on StumbleUpon
Share by email