![]() In the above spreadsheet, the blank row at line 17 would be a problem. That is not to say you cannot have some blank cells, but an entire blank row will cause problems. Make sure your source data has no blank rows. Though you can filter data in this table, we're about to see how PivotTable can make things much more efficient. Notice that all the rows do not fit on the current page – now imagine there were even more columns. This is a simple data set, but large enough with which to work. We've also provided the worksheet shown in the examples so you can follow each step as you read.įirst, imagine a simple dataset like the following. ![]() ![]() We will also cover the basics of how to view the same data in different ways using the PivotTable feature. (Note: PivotTable is the trademarked term for Microsoft Excel's pivot table function)īy the time you finish this article, you should have a firm grip on how to create a pivot table in Excel. If you have never used pivot tables in Excel or would like to build on your basic knowledge, you're in the right place. It allows you to analyse and visualise data in various ways that can provide deep insights. The PivotTable function is one of the most widely used features of Microsoft Excel.
0 Comments
Leave a Reply. |