Course info
Oct 17, 2019
1h 34m
Your 10-day individual free trial includes:

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.

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.

About the author
About the author

Ben is a Power BI & Data Specialist with a healthy interest in Microsoft Project with over 30 years of customer and implementation experience. He has been a Microsoft MVP for 13 years, is a frequent speaker at several European conferences, and blogs and creates videos on a semi-regular basis.

More from the author
Analyzing and Visualizing Data with Power BI
1h 26m
Oct 12, 2021
Optimize Power BI Reports for Mobile Devices
1h 45m
Jan 15, 2021
More courses by Ben Howard
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone. My name is Ben Howard, and welcome to my course, Displaying Tables in Excel. I'm a data consultant, and I'm constantly analyzing data in order to gain useful insights and information from it. Excel has been around for many years, but the features regarding data analysis are relatively new. This course will start by explaining what a table is and why you should consider using them, how to create a table from a range of data, and then finally how to use the inbuilt table tools such as totals, filtering, and sorting. At the end of this course, you'll be able to utilize tables in order to manage your Excel data and to answer questions easily, such as how many customers do I have or what's the largest revenue value. Okay, so the examples I've chosen are sales related, but of course you can add your own references in here for the biggest, smallest, average, etc. Ultimately, you'll be able to answer almost any question regarding your data. In terms of prerequisites, you should be familiar with working with and entering data into a cell, and of course the concepts or a row and a column. After that, you'll learn why you should use tables, and then how to create one, and finally how to work with the table and the data, i.e., answer those pesky questions that your managers and coworkers keep asking you. I hope you'll join me on this course, Displaying Tables in Excel, at Pluralsight.