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.3 (21 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.
868 students enrolled
$50
Take This Course
  • Lectures 36
  • Contents Video: 3.5 hours
    Other: 1 min
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2013 English

Course 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.

What are the requirements?

  • Microsoft Excel 2010 or 2013

What am I going to get from this course?

  • Learn The Power Of Tables In Excel

What is the target audience?

  • Users With A Basic Knowledge Of Microsoft Excel

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Excel Tables Overview
Important - Download These First - Working Files
Article
0101 Why Take The Deep Dive Into Tables
Preview
03:21
0102 What You Will Learn
Preview
02:51
0103 Learning The Way You Need
Preview
06:48
0104 Using The Working Files
03:33
Section 2: Skimming The Surface Of Tables
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
Section 3: Working With Table Records
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
Section 4: Formatting Tables
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
Section 5: Calculations In Tables
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
Section 6: Using Table Tools
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
Section 7: Course Closing
0701 What You Now Know
05:36

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, 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.

Ready to start learning?
Take This Course