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 [Autogenerated] Hello, everyone. My name is Ben Out. 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 a relatively new this course will start by explaining what a table is and why should consider using them how to create a table from a range of data. And then, finally, how to use a inbuilt table tour, 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 dough I have or what's the largest revenue value. Okay, so the examples I've chosen the sales related. But of course, you can add your own references in here for the biggest, smallest average, etcetera. 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 concept of a row on a call. After that, you'll learn why you should use tables and then house craven and finally, how to work with the table in the data. I answer those pesky questions that your managers and co workers keep asking. I hope you'll join me on this course, displaying tables in Excel at floor site.