Microsoft Excel - Tables Deep Dive

Video description

Microsoft Excel - Tables Deep Dive

Video description

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.

Publisher resources

Download Example Code

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

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

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

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

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

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

Course Closing

What You Now Know 00:05:37

About The Author

About The Author 00:04:21

Start your Free Trial

Self paced

Go to the Course
We have partnered with providers to bring you collection of courses, When you buy through links on our site, we may earn an affiliate commission from provider.