Microsoft Excel - Tables - Deep Dive
4.7 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
880 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Microsoft Excel - Tables - Deep Dive to your Wishlist.

Add to Wishlist

Microsoft Excel - Tables - Deep Dive

Learn how to use Table in Excel. An in-depth course from Infinite Skills that takes you beyond the basics
4.7 (26 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
880 students enrolled
Last updated 1/2017
English
Price: $50
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Learn The Power Of Tables In Excel
View Curriculum
Requirements
  • Microsoft Excel 2010 or 2013
Description

This Microsoft Excel – Tables Deep Dive training course from Infinite Skills 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.

Who is the target audience?
  • Users With A Basic Knowledge Of Microsoft Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 36 Lectures Collapse All 36 Lectures 03:28:08
+
Excel Tables Overview
5 Lectures 16:34
Important - Download These First - Working Files
00:01




0104 Using The Working Files
03:33
+
Skimming The Surface Of Tables
7 Lectures 35:49
0201 Skimming The Surface Of Tables
03:11

0202 Why Do We Need Tables
02:54

0203 Preparing Data For Tables
08:15

0204 Creating Tables
07:33

0205 What Changes With Tables
04:26

0206 Naming Tables
06:14

0207 Converting Tables Back To Ranges
03:16
+
Working With Table Records
7 Lectures 48:05
0301 Working With Table Records
11:16

0302 Adding And Deleting Records
05:43

0303 Using The Data Entry Form
06:27

0304 Adding Columns To Tables
03:44

0305 Sorting Table Records
06:31

0306 Filtering Table Records
08:15

0307 Using Slicers In Tables
06:09
+
Formatting Tables
4 Lectures 30:43
0401 Formatting Tables
10:09

0402 Working With Quick Styles
05:50

0403 Modifying Table Style Options
06:56

0404 Creating Custom And Default Table Styles
07:48
+
Calculations In Tables
6 Lectures 42:23
0501 Calculating Data In Tables
10:19

0502 Excel Calculations Refresher
04:41

0503 Creating Calculated Columns
04:46

0504 Understanding Structured References
05:14

0505 Tweaking Absolute References In Tables
09:19

0506 Working With Table Rows
08:04
+
Using Table Tools
6 Lectures 28:58
0601 Working With Table Tools
02:24

0602 Moving Tables
06:02

0603 Removing Duplicates
08:11

0604 Summarizing Table Data With Pivot Tables
05:00

0605 Creating Charts From Tables
04:18

0606 Printing Tables
03:03
+
Course Closing
1 Lecture 05:36
0701 What You Now Know
05:36
About the Instructor
Infinite Skills
4.4 Average rating
36,301 Reviews
678,674 Students
331 Courses
High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.