The best way to learn complex tools is by using them.
Step 6: If you only want to display values that meet certain criteria, use the Filters section. Step 5: In the Values section, select the fields that have the values you want to add or calculate. Step 4: In the pivot table editor, drag the rows and columns that you want to summarize to the appropriate box. Step 3: From the pop-up, select New Worksheet and click OK. Step 1: Open the Excel Online sheet and select all cells containing the data you want to look at.
#Creating pivot tables in excel 2013 pfd how to#
Here's a quick overview of how to use pivot tables (we'll dive deeper in the next section). How to Create a Pivot Table in Excel Online That means that you won't have to create a new spreadsheet for each analysis-you can use the same data and manipulate it in the pivot table to get new insights each time.
A pivot table can be used to analyze an unlimited variety of data. Using a pivot table, you can do just that.Īnd that's just a simple example. For example, you might want to see how much money you spent on rent and utilities in the last quarter. To gain more insight and meaning from the data, you need to see it dynamically. This is what is called a flat data-all you're seeing is a sea of rows and columns. At the end of the year, when you sit down to review, you're going to have a tough time sorting through hundreds of entries. Let's say you diligently log all your expenses across the whole year in a single spreadsheet. That's where a pivot table comes in-it filters and summarizes your data based on criteria of your choosing. And when you lose track of the data, you lose track of the meaning behind it. When spreadsheets start expanding beyond a few rows and columns, it becomes difficult to keep track of the data. The examples in this tutorial come from that demo sheet, and you can use it to experiment further once you're ready. You can use our demo sheet to practice: Open the sheet in Excel Online, and click Save to OneDrive to start working on your own copy. Here, we'll walk you through how to create a pivot table in Excel Online. Excel Online makes it easy to create pivot tables that will help you summarize your data and give you more insight into what your raw numbers mean. All rights reserved.Spreadsheets are great for cataloging large pools of data, but it takes a feature like pivot tables to really draw conclusions from the data. MyExcelOnline PODCAST: the Excel Insights From The Excel Experts!Email me if you have any Excel queries: More Episodes
#Creating pivot tables in excel 2013 pfd plus#
SIGN UP TO OUR FREE WEEKLY EXCEL LESSON PLANS TO GET BETTER AT: Formulas, Pivot Tables, Charts, Analysis, Shortcuts plus more here: Jump to the Pivot Table tutorial topic you want to view by clicking on the numbers below:Ģ0:30 SHOW VALUES AS YTD & DIFFERENCE FROM PREVIOUS MONTH ģ5:15 SLICERS & PIVOT CHARTS & DASHBOARDS ĥ5:40 XTREME PIVOT TABLE COURSE STRUCTURE This Excel tutorial can also be used in Excel 2013 and Excel 2007 (Slicers not available in Excel 2007 and Excel for Mac) This will make you more important and extend the reach of your work to a lot more people than before, which means a greater opportunity for a promotion. Watch more free videos and view my comprehensive EXCEL PIVOT TABLE COURSE which has 200+ tutorials: Īfter this free tutorial you will be a able to use Excel Pivot Tables confidently at your work, make insightful business analysis and create interactive Management Reports & Dashboards. In this Excel Pivot Table 2010 tutorial you will learn the basics of building a Pivot Table to more advanced Pivot Table commands like creating a Dashboard with Slicers and Pivot Charts.