They put flexibility and analytical power in your hands. Go to exercise . I have put this page together to provide everyone with data that you would come across in the REAL WORLD. How To Create Timeline In Excel. Columns in this Data Set: Below is a list of all the fields of data included in the sample data. You follow these steps to make a query a pivot table: First, select a base dataset for pivoting. Here's the layout that I selected. Ideas for creating pivot tables from large data-sets. There are details in the Change All Pivot Charts with Single Cell Filter blog post. So, here we can assume that we got the highest number of flats with 3 BHK configurations per area. In total, we got 79 flats in this project. This sample has data from the 2018 Olympic Hockey teams, from Canada and the USA. Learning to "read" the fields pane takes a bit of practice. Check each section for its sample file download link. Note: This screen shot shows all 6 columns in the Winter Athletes dataset table. I'm also going to add the total price. One option is to show values as a percent of total. 1. Formatting. After creating an empty pivot table the first step is to add fields to the list. Even if you are very good with formulas, pivot tables are faster to set up and require much less effort. Keep Experimenting. There are 514 rows of data in the workplace safety report table. You might encounter several gotchas with this example file or another spreadsheet. The zipped Excel file is in xlsx format, and does not contain any macros. The original sample file has sales data for a fictional office supply company. Here are some of the advantages of using Pivot Tables: Click to download our absolutely FREE Pivot Table Exercise. Swap Region and Color (i.e. You can also learn how to use Excel PivotTables in an article here. Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Basic pivot tables are very simple to set up and customize. Pivot Table is a great tool for summarizing and analyzing data in Excel. We can add charts to existing Pivot Tables or create new charts based on a new Pivot Table. You can create a good-looking, useful report with a pivot table in minutes. Drag the Color field to the Rows area. SQL USE AdventureWorks2014 ; GO SELECT DaysToManufacture, AVG(StandardCost) AS AverageCost FROM Production.Product GROUP BY DaysToManufacture; Here is the result set. Each row shows these 8 manual entry fields, with information about the Olympic participants: Use this data to demonstrate lookup formulas, such as VLOOKUP, XLOOKUP, INDEX and MATCH. Make sure each column has a meaningful label. Ill drag the, To see each political partys counts, I need to drag the same field to the. Right-click a date in the header area and choose "Group": 4. This makes sense, because we are still reporting on the full set of data. When you're finished, you can click the check box again, to hide the transcript. Here, we can note that we got the highest number of flats in the Rainbow block and Strawberry block compared to other blocks. Workplace Safety: Click here to get the workplace safety data file. Sample PivotTable report Sample PivotTable report Learn to use and create PivotTables with this accessible sample PivotTable template, containing worksheets for entering sample customer and sales data, building the PivotTable structure, and viewing and filtering the resulting report. Here, we will take a percentage to see the contribution of different blocks in terms of the product value as below: Go to Value Field Settings, then select Show values as. In that, select % of Column Total.. We can scroll down and see row after row of data. Sample Excel Data Download the Free Sample Excel Data for practices, you can use this Sample Excel Data for various practices like, pivot table, advanced functions and formulas, also macros. To create such a table, first create the two-dimensional table using the tools described earlier for task 2. Home Tutorials Excel How to Use Excel Pivot Tables to Organize Data, Do you find it a challenge to organize data in Microsoft Excel? This option is under the Excel Options Advanced tab Edit Custom List. pivot table sample data. Add it a slicer. It's good data for Data Analyst , Data scientists and Power BI Developers to give it a try. Key Excel Skills page, for training topic ideas, hockey data file, with pivot tables and pivot charts, go to the Create a Pivot Table in Excel page, read about it in my Contextures blog post, Quick way to get interesting data for Excel training class exercises, No privacy concerns about using real data from your employer or your client's company, Useful for testing macros and manual processes - you might discover problems that didn't occur with original test data. You can use undo to go back to original data and pivot. Download. If you base a pivot table on an Excel Table, the table resizes as needed with new data. dragRegion to the Rows area and Color to the Columns area). So now we can see the total quantity and the total price for each product category and product. You may learn more about Excel from the following articles: , Nice to join you people I wish I will perform better, Your email address will not be published. You might prefer to move the data, so the election dates are in chronological order. Office Supply Sales: To get the sample office supply sales data in an Excel file, click this link: Office Supply Sales sample data workbook. The column labels will be carried over to the Field List. Click on Edit Custom List. In the PivotTable practice exercise example, we will find out the average price of the flat in each block by changing the value field settings from Count to Average.. If we want to know what's selling, here's a layout that has the different product categories and then for each region how much we sold. I'll select that one. There are 244 rows of data in the food sales table. In this database, there are 1,000 rows of data encompassing popular data points that HR professionals deal with on a regular basis. We have over a hundred tutorials for you to learn and master Excel Pivot Tables! There are 8 additional columns in the dataset, as described above. CREATE TABLE count_by_color (quality varchar, red int, green int, blue int ); INSERT INTO count_by_color VALUES ( 'high', 15, 20, 7 ); INSERT INTO count_by_color VALUES ( 'normal', 35, NULL, 40 ); INSERT INTO count_by_color VALUES ( 'low', 10, 23, NULL ); And like tables, you can use Excel Slicers to drill down into your data. Learn the BEST Microsoft Excel Tips & Tricks EVER, ranging from Formatting, Layout, Formulas, Tables, Pivot Tables, Working with Data plus Many More! Go to PivotTable Tools -> Analyze -> Insert Timelines. For example, numeric data such as Precinct counts tend to appear to the right in columns. Click on Insert Timeline. 1st Edition. 1. Second, create a temporary result by using a derived table or common table expression (CTE) Third, apply the PIVOT operator. If you would like to download this data instantly and for free, just click the download button below. If you like this Excel tip, please share it. Click on Repeat All Items Labels to show all item labels. You might think of a pivot table as a custom-created summary table of your spreadsheet. With very little effort, you can use a pivot table to build good-looking reports for large data sets. Click on Show in Tabular Form to show the table in a classic format. It's a quick way to get started. On the Insert tab, at the left, there's a Tables group and here's the new tool, which is Recommended Pivot Tables. I think its easier to add the fields first to your source spreadsheet. Verify your columns are properly formatted for their data type. I created pivot tables from this data, and wrote about it in a blog post on hockey player data analysis. When we click on the Pivot Chart, the names of the categories will look like this: Like any other chart, we can control the axis directions and the chart type by clicking on the Design tab. Those are the basic steps for planning, creating, and changing a pivot table. Check out all the free tutorials and VBA code snippets! If youd like to keep up to date with the latest Excel news and directly get emailed the most meaningful Excel tips Ive learned over the years, you can sign up for my free newsletters. If you continue to use this site I'll figure that you are happy with that. Excel builds another two-dimensional pivot table: Again notice total sales ($26,356) is the same in all pivot tables above. Add the Sales field (again)to the Values area. This sample file has fake workplace safety report data. This may be the only time youre allowed to manipulate election data. Follow along and see how easy it is to create a pivot table in Excel. Click OK. Now, you have a blank pivot table and pivot chart in a new worksheet. Then, the Grouping window will pop out where we have to give the starting number for the frequency to get started and the ending number. This sample file has food sales data, from an imaginary food company. Just like with normal spreadsheets, you can sort the data in a PivotTable using the Sort & Filter command on the Home tab. (free sample workbook). To create an Excel pivot table, Open your original spreadsheet and remove any blank rows or columns. 6-1. Then, add the final variable ("Salesperson") and, if necessary, drag this . Excel Pivot Tables (Example + Download) Jul 15, 2015 by azurous in Excel. The Group is an Excel tool which groups two or more rows or columns. These features work the same way as a regular spreadsheet. We can, for example, replace the X and Y axis by Switch Row/Column in the Design tab. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. Your website has been a HUGE help! The Create PivotTable dialog box will appear. If I go down further, we're looking at the product categories and then the product names below that. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); Copyright 2020 MyExcelOnline SLU. In addition, we have to provide a number that will create a frequency. Examples of PIVOT Let's say that you have the following query. 1. Your email address will not be published. 1. Earlier in the example of the PivotTable, we had seen grouping the name of the blocks. You can read about it in my Contextures blog post, and see the game summary on the ESPN website. Similarly, we get for other blocks too. Selecting cells for a PivotTable. Now that pivot table is initialized and assigned with sample data, will further move to showcase the component by organizing appropriate fields in row, column, value and filter axes. Another way to save time if we are planning to update the data source range often is changing the data source range to a table by clicking in Table in the Insert tab or by clicking CTRL+T. Drag the Date field out of the columns area 2. Through my years in the corporate world, Ive been able to pick up on opportunities to make working with Excel better and have built a variety of Excel add-ins, from inserting tickmark symbols to automating copy/pasting from Excel to PowerPoint. Click OK, and Excel builds an empty pivot table starting in cell H4. For example, you can have a field show in either a column or a row. Lets assume we want to analyze a database of cars sold by a car vendor: After we decided to create a Pivot Table, we can see all the column headers these are the fields from our database which we can work with: To start creating our Pivot Table, we can drag the different fields to the following areas: One of the most basic examples of using a Pivot Table is summing values of a specific field based on a criteria that appears in a different field. Find out how to insert pivot tables and how to use recommended pivot tab. Below is a list of our best tutorials on Pivot Tables. Last Updated August 24, 2021. The Donald block got the highest average flat price among other blocks. Creating a PivotTable. Free Example Data Sets For Spreadsheets [Instant Download], Printable Blank Calendar Templates For 2023, Add Total Value Labels to Stacked Bar Chart in Excel (Easy), How To Build Waterfall (Bridge) Charts In Excel, Add Line Breaks In Screentips & SuperTips (Ribbon XML). I am then creating a Pivot Table. The downside to that approach is that we need to know the column headings when we write the query, and the more columns that appear the more code we need to write. You can quickly rearrage the pivot table to suit your needs. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. The first table shows player counts, for each position, plus age, height and weight. We can use a Pivot Table to perform calculations on our data based on certain criteria. A pivot table is a table of statistics that summarizes the data of a more extensive table (such as from a database, spreadsheet, or business intelligence program). We also use third-party cookies that help us analyze and understand how you use this website. Figure 2 - Sample Dataset for Pivot Table Applying the PIVOT Operator. There are 7 additional columns in the dataset, as described above. Textual data, such as Party, would appear in rows. Click anywhere on the Pivot table, and the PivotTable Tools ribbon will be displayed. We can do that by right-clicking the table and clicking on Refresh or by Refresh/Refresh all in the Data group. The pop-up window will automatically select the entire data range and you have the option to choose the place where you want to insert your pivot chart. Also, the PivotTable report will open in a new worksheet. For example, I can take the same data and segment it by voter age group. The zipped Excel file is in xlsx format, and does not contain any macros. File Size 34.05 KB. Our task today is to create a report (using SQL Server PIVOT operator) where each city will be in a separate row, and where we'll count the number of all call outcomes related to each city. We can also change the Chart type: It is important to note that Pivot Charts behave exactly as Pivot Tables, so each functionality that can be used in Pivot Tables, can also be used in Pivot Charts. Examples of Pivot Table in Excel Pivot Table Example #1 - Performing Statistics Measures in Pivot Table Pivot Table Example #2 - How can we Modify the Pivot Tables in Excel Pivot Table Example #3 - Grouping the Fields in the Excel Pivot Table Pivot Table Example #4 - Creating Multi-levels in Excel Pivot Table Food Nutrients: Click here to get the food nutrients data file. There are dataset examples for property insurance data, food sales records, work orders, workplace safety, athletes, and other Excel datasets. Practicing Excel Formulas (VLOOKUP Practice Data), Example Data for Articles or Videos You Are Making. Pivot Table is a great tool for summarizing and analyzing data in Excel. Using a pivot table, I can continue to refine the information by selecting more fields from the PivotTable Field List. There is a table with office supply sales sample data, to copy and paste into your Excel workbook. And this pivot chart shows the age ranges for the Mens and Womens players, from both countries. Click Insert from the main menu, then click Pivot Table from the left side of the Insert . As you can see, there are options to connect an external data source (i.e., MS Access), or place the pivot table within the existing . Verify your columns are properly formatted for their data type. 2. Then, PivotTable changes from Count to Average, as given below: From the above PivotTable example, we can see that we got the average flat price in each block. All the example data is free for you to use any way youd like. Next, the pivot table calculates the Sum of the Revenue column. Excel breaks out sales by Color. Then, to get started, you can download sample Excel file with data for your training sessions. The zipped Excel file is in xlsx format, and does not contain any macros. There are 4 additional columns in the dataset, as described above. Send people to this page, so they can download the sample data, and recreate their problem or error there. You can see Blue is the top seller, while Red comes in last: Notice the Grand Total remains 26356. There are written instructions. Feel free to download the practice spreadsheet below and play with the data. Become an expert in Excel, PowerPoint, Word, and the rest of the Microsoft Office Suite. A blog focused primarily on Microsoft Excel, PowerPoint, & Word with articles aimed to take your data analysis and spreadsheet skills to the next level. Pivot Data(.xls) Download. This website uses cookies to ensure you get the best experience on our website. This sample has fictional commercial property insurance policy data. This one went in as Sum of Total Price. Select cell F5 and change $11.00 to $2000. Most of the All rights reserved. While the Pivot Table has been created, you'd see no data in it. >> FREE DOWNLOAD << THE ULTIMATE PIVOT TABLE GUIDE! The default location for a new pivot table is New Worksheet. Now, we can see that the area category has been formed. Columns Here we will choose the field/s which we would like to base our Pivot Table columns upon. This time it's the quantity, rather than the price. Now it's got the quantity. The zipped Excel file is in xlsx format, and does not contain any macros. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. This sort order will be maintained when data changes, or when the pivot table is reconfigured. It can summarize, sort, group, and reorganize data, as well as execute other complex calculations on it.read more Example, we should perform the sum of the final product value to extract the value of different blocks got as below: Drag the Block Name to Rows and Sum of Final Product Value to Values Fields. The PivotTable will calculate and summarize the selected fields. You can group data into categories, break down data into years and months, filter data to include or exclude categories, and even build charts. This page has Microsoft Excel sample datasets that you can use for testing, Excel training and demos, and other learning activities. represents one sales order. Create Date September 13, 2020. Updates. There are 8 columns of data, including 1 column with a calculation. When you find data you want to include in a pivot table, such as data included in a pivot table tutorial, copy the sample data into an Excel worksheet. Go to Insert tab on Excel ribbon and click on PivotTable button. In this example of a PivotTable in Excel, let us see how it works. Ive added more files recently, so see if theyll be helpful to you too. There are 16 columns of data, including 6 columns with a calculation. The zipped Excel file is in xlsx format, and does not contain any macros. Tables open access to new functionality such as: filtering, automations and styling. Speed. We can also create a group in ExcelCreate A Group In ExcelThe Group is an Excel tool which groups two or more rows or columns. Also, show how to create dependent drop down lists, for categry and food item. Now I've added data for the 2022 team rosters, so you can compare years, teams, and/or player types! Choose your settings, then click OK. This table shows us that the Rainbow block got a higher value than the other blocks. This is the sum of all sales values in the entire data set: 2. Select the table or data range you want to include in the pivot table. Select all the data in the sheet. In our example, the PivotTable shows the amount sold by each salesperson. PIVOT operator syntax. Excel will auto-select your dataset. Using an Excel pivot table, you can organize and group the same data in ways that start to answer actionable questions like: Excel pivot tables allow you to group the spreadsheet by any of your data fields. For example, the picture below shows a voter count by the political party by precinct. We will go to the Insert tab and click on Pivot Table: Next, we will confirm that the selected range is indeed the right range. Below is a list of all the fields of data included in the sample data. Note: This screen shot shows the first 9 columns in the Football Player dataset table. You can see Color is a Row field, and Sales is a Value field: Pivot Tables can apply and maintain number formatting automatically to numeric fields. 1. I'll click OK, and it puts a new sheet in the workbook. Right-click anywhere in the pivot table and select "Refresh". So the first one is showing the cities and then taking the total price and giving me the total sales in each city. But it also has elements of Excel Tables. Get access to 30+ Microsoft Excel & Office courses for ONLY $1. Note: This screen shot shows the first 6 columns in the Insurance Policy dataset table. Each row shows these 6 manual entry fields, with information about the Olympic participants: Winter Athletes: Click here to get the winter athletes data file. So, I found the player rosters online, and got that data into Excel, for analysis. There are 14 columns of data, including 3 columns with a calculation. Swap Region and Color (i.e. For your convenience, here are the quick steps to copy the data from the table below, and paste into your Excel worksheet: Download: You can also get the sample office supply sales data in an Excel file -- click this link: Office Supply Sales sample data workbook. Use Microsoft Excel to generate useful statistics from Pivot Tables. Else, a new worksheet is created with the Pivot Table. Heres how our Data Source looks like: We can present the calculated values in the Values area in different ways, i.e. These cookies will be stored in your browser only with your consent. There are 3 additional columns in the dataset, as described above. Click Rows in the Pivot table editor and add Property Type ( clicks three and four) 5. We can change the calculation by clicking the field after we dragged it into the Values area, then Value Field Settings, which will open a menu where we can choose to sum, count, average and many more calculations: We can segment the data using rows and columns simultaneously by dragging fields to the Rows and Columns areas: We can perform a number of different calculations on the same field by dragging the field several times to the Values area and changing the type of calculation in each of the columns: In the Pivot Table, we can segment based on more than one field by dragging several fields into the Rows area: In order to give the Pivot Table a classic look, where each field is presented in a different column, we will click the Pivot table, click on design and perform the following steps: We can quickly select the way we wish to format a certain value field, by right-clicking the field and then clicking on Format Cells, or directly on Number Format, if we wish to format the values as number and add 1000 separator (4,524,254 instead of 4524254): We can control the way missing values (empty cells) or errors are presented in the Pivot Table by right-clicking one of the cells and clicking on Pivot Table Options, then ticking For error values shows or For empty cells show (as shown in the following example). It & # x27 ; s say that you would like to base our pivot table a... The USA bit of practice click OK. now, you can have a field show in a... Us see how easy it is to add the final variable ( & quot ; Salesperson quot. Can note that we got the highest number of flats in this project think. Best experience on our website a frequency that the Rainbow block and Strawberry compared. The Donald block got a higher value than the pivot table example data for practice 2015 by azurous in Excel, PowerPoint, Word and!: this screen shot shows all 6 columns in the dataset, as described above Microsoft! 8 additional columns in the workbook problem or error there Group '': 4, creating and... The election dates are in chronological order, plus age, height and weight work the same in all tables... Columns upon and for free, just click the download button below by Refresh/Refresh all in the Change pivot. Us Analyze and understand how you use this site I 'll figure that you would like to base pivot..., so the first step is to add fields to the right in columns use recommended pivot.! Looking at the product names below that and Strawberry block compared to other blocks you have a pivot... Total sales in each city the Change all pivot tables from pivot tables and how create!, Let us see how easy it is to show all item labels in columns looks like we. Fictional commercial property insurance policy dataset table flats in this database, there are 3 additional columns in the.... Cell F5 and Change $ 11.00 to $ 2000 blank pivot table to build good-looking reports for data... Make a query a pivot table, and Excel builds an empty pivot table in! Per area shows the age ranges for the 2022 team rosters, so they can download sample file! Categry and food item number that will create a pivot table columns upon on Repeat all labels! Right in columns HR professionals deal with on a regular basis creating an empty pivot table starting cell... A custom-created summary table of your spreadsheet ensure you get the best experience on our.! ; Salesperson & quot ; Salesperson & quot ; ) and, if necessary, drag this number flats! Tool which groups two or more rows or columns Edit Custom list tutorials for you to learn and Excel. Under the Excel Options Advanced tab Edit Custom list that you have a blank pivot table to suit your.! There are 8 columns pivot table example data for practice data included in the Change all pivot charts with cell! Table as a regular spreadsheet suit your needs instantly and for free, just click the download button below or... Top seller, while Red comes in last: notice the Grand total remains 26356 still... New worksheet ( clicks three and four ) 5 menu, then click pivot table starting cell... For free, just click the download button below of WallStreetMojo file is xlsx... To move the data Group original spreadsheet and remove any blank rows or columns to! Xlsx format, and does not contain any macros this database, there are 8 columns. Been formed learn how to use recommended pivot tab from Canada and the rest of columns. Your consent regular basis require much less effort data instantly and for free, just click the check again!, if necessary, drag this table columns upon a date in Football! Row/Column in the sample data into Excel, Let us see how it works uses cookies to ensure you the... Imaginary food company make a query a pivot table starting in cell H4 in an article here columns properly! Charts to existing pivot tables above first, select a base dataset for pivoting will be.... This database, there are 8 additional columns in the workplace safety report table this I! In it large data sets Excel & office courses for only $ 1 Advanced Edit. Can download the sample data, from Canada and the total price put this,.: 4 be carried over to the list you continue to use website... Follow these steps to make a query a pivot table to suit your needs access to functionality. Sample data, to see each political partys counts, for each position, age... That help us Analyze and understand how you use this site I 'll figure that you the... Player types free pivot table to perform calculations on our website see the total sales each... They put flexibility and analytical power in your browser only with your consent one went as... Word, and recreate their problem or error there base a pivot table the first step to!, while Red comes in last: notice the Grand total remains 26356 values as a custom-created table... When data changes, or when the pivot table is reconfigured the amount sold by each Salesperson are 1,000 of!, a new worksheet Jul 15, 2015 by azurous in Excel, for example, the picture below a! Started, you can create a temporary result by using a pivot table starting in cell H4 selected.! And select `` Refresh '' can take the same field to the rows area and choose Group... Data Analyst, data scientists and power BI Developers to give it a try and. This page has Microsoft Excel to generate useful statistics from pivot tables from this data, does. + download ) Jul 15, 2015 by azurous in Excel rows the... Hockey teams, from both countries location for a fictional office supply company popular data points HR... The rows area and Color to the right in columns in either a column or a row blank rows columns. A blog post on Hockey player data analysis datasets that you are happy with.... It 's the quantity, rather than the price down lists, for categry and item. Play with the pivot table is reconfigured highest number of flats in this database, there are additional... Imaginary food company on Repeat all Items labels to show all item labels an article.... Still reporting on the pivot table in minutes, the PivotTable shows the first 6 in. Over a hundred tutorials for you to learn and master Excel pivot table columns upon also third-party! Cities and then the product names below that only with your consent tables above order will be displayed play the., just click the download button below useful statistics from pivot tables this. Us Analyze and understand how you use this site I 'll figure that have! Bit of practice are 4 additional columns in the food sales data, including 3 columns with calculation., because we are still reporting on the full set of data encompassing data! See the total price Rainbow block got the highest number of flats in project... Add the total sales ( $ 26,356 ) is the Sum of total 16 columns data. Pivot table Exercise < < the ULTIMATE pivot table to perform calculations on data. Of your spreadsheet to hide the transcript, height and weight row after row of data in.. Example data for Articles or Videos you are very simple to set up require... From pivot tables and Womens players, from both countries 'll figure that you compare. I created pivot tables apply the pivot table and pivot all sales values in the workplace data..... we can see Blue is the Sum of all sales values in Football... Next, the PivotTable, we have to provide a number that will create a good-looking useful. Several gotchas with this example of a pivot table: again notice sales! Cell Filter blog post Applying the pivot table Applying the pivot table to suit your needs they can sample!, show how to create dependent drop down lists, for each product category and product if I go further! Created pivot tables I can take the same way as a custom-created summary table of spreadsheet. The field/s which we would like to download this data, to copy and paste into your Excel workbook a! Default location for a fictional office supply sales sample data, including 1 with! Two-Dimensional pivot table is a list of all sales values in the workplace safety: click to... Their data type, we can use a pivot table table GUIDE a PivotTable in.! If theyll be helpful to you too the Insert more files recently, so can!, because we are still reporting on the full set of data, to each... Out all the fields first to your source spreadsheet and remove any blank rows columns. Strawberry block compared to other blocks and Excel builds another two-dimensional pivot table to suit needs... Is the Sum of the columns area 2 price among other blocks pivot operator ; ) and, if,. Only $ 1 also going to add fields to the become an expert in Excel a percent total! Excel to generate useful statistics from pivot tables are very good with formulas pivot... Jul 15, 2015 by azurous in Excel, for categry and item!, teams, from Canada and the USA be helpful to you too a derived or... ) 5 seller, while Red comes in last: notice the Grand total remains 26356 website. Clicks three and four ) 5 to make a query a pivot table starting cell... Ok. now, you can also learn how to use Excel PivotTables in an article here sales! By using a derived table or common table expression ( CTE ) Third, apply the pivot table reconfigured! & office courses for only $ 1 like to download the sample data, such as,!