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.
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.
Ben is a Microsoft Project, Project Server/Online consultant, and Data Specialist with over 20 years of implementation experience. He has been a Microsoft MVP for nine years, as well as blogging on various project server scenarios, has articles published on the Microsoft Project User Group (MPUG), and is the author of Microsoft Project 2013 Plain & Simple.
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.