Excel and PivotTables

Navya Kannan
A free video tutorial from Navya Kannan
Software Asset Management Specialist
4.4 instructor rating • 4 courses • 231,312 students

Lecture description

In this lecture, you will understand what makes Microsoft Excel ideal for Data Analytics. You will understand the benefits of using Excel.

Finally, you will know the points to remember when you get your data ready for importing to a PivotTable.

Learn more from the full course

Data Analytics with Excel PivotTables

Step by Step, easy to comprehend guide on how to use Excel PivotTables with examples

52:28 of on-demand video • Updated September 2016

  • Understand the importance of Data analytics in today's business.
  • Understand the types of Business analytics and real life examples of Business analytics
  • How to use Excel PivotTables to easily and effectively work on your reports and make your data visually more appealing.
  • You will learn the different features of PivotTables like Grouping, Calculated Field, Calculated Item, Slicers, PowerPivot and Charts
English Module Three: An introduction to Excel and PivotTables. In this module, you will learn why Excel is considered as one of the most preferred tools for performing data analytics and an introduction to Excel PivotTables. Let us understand the benefits of Excel which makes it an ideal tool for data analysis. Excel is very user-friendly and is a tool that is easily available. It is widely used across organizations. It has inbuilt features that make data analytics through Excel very easy. It is a great tool for analyzing and visualizing data. Its capability to perform various types of calculations, a collection of statistical functions, data analysis tool pack and good visualization of data make it an obvious choice among users. Excel is vast and has a number of features available to perform a wide variety of tasks. This course takes you through one of its powerful features, that is, the PivotTables and how it can be used to perform business data analytics. When you have a huge data with thousands of rows and columns, it becomes difficult to focus on that particular data which can help you find the answer to your query. Analyzing your data appropriately can help you make good business decisions. But for that you need to know where to start from. An Excel PivotTable makes data easy to comprehend, help summarize a huge chunk of data, helps visualize data in a better way and draw trends and patterns out of that. With the pre-defined functions within the PivotTables, it helps make calculations in an easier and quicker way. Allows to reorganize the data to answer different questions. Hence, you can understand that Excel PivotTable is one of the most powerful features of Excel to help you with data analysis. These can help you by recommending and then automatically creating PivotTables for your data. PivotTables are very important to summarize, analyze and present your data. In Excel, you can find the PivotTable options under the Insert ribbon in the Table's panel. While creating a PivotTable, it is important to keep the following points in mind. A PivotTable is able to handle data which is in a rectangular format. Hence, make sure that your data follows that. Make sure that the data has table headers and there are no blank rows or columns in between. You can have a blank cell in between but a full row or column should not be left blank. Your data should be consistent. For example, if you have a date column, make sure that all the values in that column are dates. Or if you have a quantity column, all the values in that column should be number. The worksheet can be in a table form or normal range. Your source data can be in a worksheet or an external database file. In this module you learned what makes Excel ideal for data analytics, benefits of using Excel, how to get your data ready for importing to a PivotTable.