Displaying Tables with Excel

Focused View

Ben Howard

1:35:28

0 View

1-Course Overview

1 -Course Overview.mp4

01:33

2-Tables What Are They and Why Use Them

2 -Introduction to tables.mp4

07:54

3 -Table Construction.mp4

03:16

4 -Demo Table Construction.mp4

04:27

5 -Table Summary.mp4

00:55

3-Create and Manage Tables

6 -Creating Tables.mp4

05:01

7 -Demo Creating Tables.mp4

03:32

8 -Demo Importing Data into a Table and Empty Tables.mp4

03:20

9 -Managing Tables.mp4

01:33

10 -Demo Managing Tables.mp4

04:53

11 -Formatting Tables.mp4

01:32

12 -Demo Formatting Tables.mp4

03:37

13 -Summary.mp4

01:19

4-Working with Table Data

14 -Working with Table Data.mp4

02:38

15 -Duplicates and Sorting Demo of Duplicates.mp4

05:44

16 -Demo Sorting Data.mp4

03:31

17 -Filters and Slicers.mp4

01:15

18 -Demo Filters.mp4

07:15

19 -Demo Slicers.mp4

05:55

20 -Demo Total Row.mp4

03:59

21 -Demo The Autosum Function.mp4

01:22

22 -Demo Importing Data into a Table and Empty Tables.mp4

03:02

23 -Referencing Table Data.mp4

05:57

24 -Neat Table Features.mp4

05:28

25 -The Quick Access Tool.mp4

02:11

26 -Summary.mp4

00:54

5-Exploring Other Excel Capabilities

27 -Exploring Other Excel Capabilities.mp4

03:25

Description

This course explores Excel Tables, explaining how to turn them to your advantage to quickly gain insights into data. The course discusses what tables are, why you should use them, how to set them up, and then how to manipulate the data in them.

What You'll Learn?

Learning how to effectively communicate and display data in Excel is challenging. In this course, Displaying Tables with Excel, you will gain the ability to find insightful information regarding your data stored in Excel. First, you will learn what tables are and when to use them. Next, you will discover how to create tables and format them. Finally, you will explore how to manipulate the table data to provide meaningful insights and answer all those difficult data related questions that your co-workers and managers keep asking! When you’re finished with this course, you will have the skills and knowledge to use Excel Tables in order to correctly analyse your Excel data.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Ben Howard

Instructor's Courses

Ben is a Power BI & Data Specialist with a healthy interest in Microsoft BI and planning tools. He has over 30 years of customer and implementation experience, has been a Microsoft MVP for 14 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis. He is actively engaged in providing consultancy to UK FTSE companies, and co-runs the Manchester Power BI User Group.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.