by | Released December 2013 | ISBN: 9781771371872

In this Microsoft Excel – Tables Deep Dive training course, expert author Erin Olsen takes you beyond the basics of Excel, diving deep into creating and using tables in this powerful spreadsheet program. This course is designed for users that already have a basic working knowledge of Excel.You will start out by the learning the basics of Excel tables, such as how to prepare data for tables, creating and naming tables, and converting tables back to ranges. From there, you will move into working with table records, including how to add and delete records, use the data entry form, and sort and filter table records. Erin will teach you how to format tables and modify and create custom and default table styles. This video tutorial will also teach you table calculations, including how to create calculated columns, understand structured references, and work with table rows. Finally, you will learn how to work with table tools, such as moving tables, removing duplicates, and how to create charts from tables.By the completion of this computer based training course, you will be fully capable of creating, using, modifying, and customizing tables in Excel. Working files are included, allowing you to follow along with the author throughout the lessons. Show and hide more Publisher resources Download Example Code

1. Excel Tables Overview
   • Why Take The Deep Dive Into Tables 00:03:21
   • What You Will Learn 00:02:52
   • Learning The Way You Need 00:06:48
   • Using The Working Files 00:03:33
2. Skimming The Surface Of Tables
   • Skimming The Surface Of Tables 00:03:11
   • Why Do We Need Tables 00:02:54
   • Preparing Data For Tables 00:08:15
   • Creating Tables 00:07:33
   • What Changes With Tables 00:04:26
   • Naming Tables 00:06:15
   • Converting Tables Back To Ranges 00:03:17
3. Working With Table Records
   • Working With Table Records 00:11:17
   • Adding And Deleting Records 00:05:43
   • Using The Data Entry Form 00:06:28
   • Adding Columns To Tables 00:03:45
   • Sorting Table Records 00:06:32
   • Filtering Table Records 00:08:16
   • Using Slicers In Tables 00:06:10
4. Formatting Tables
   • Formatting Tables 00:10:10
   • Working With Quick Styles 00:05:50
   • Modifying Table Style Options 00:06:57
   • Creating Custom And Default Table Styles 00:07:49
5. Calculations In Tables
   • Calculating Data In Tables 00:10:19
   • Excel Calculations Refresher 00:04:41
   • Creating Calculated Columns 00:04:46
   • Understanding Structured References 00:05:15
   • Tweaking Absolute References In Tables 00:09:19
   • Working With Table Rows 00:08:04
6. Using Table Tools
   • Working With Table Tools 00:02:24
   • Moving Tables 00:06:02
   • Removing Duplicates 00:08:12
   • Summarizing Table Data With Pivot Tables 00:05:00
   • Creating Charts From Tables 00:04:18
   • Printing Tables 00:03:04
7. Course Closing
   • What You Now Know 00:05:37
8. About The Author
   • About The Author 00:04:21
Show and hide more