![]() In fact, this spreadsheet extends down for 688 rows of sales data, for all of January and February ( you can download a copy of the spreadsheet here). The data we'll work with in this example is an Excel table that has two months of daily sales data for a team of four sales people, broken down by product. Change the layout of your PivotTable report to reflect different views on the same data.Add fields from your data to your PivotTable layout so you can see that data in summary form.Insert a PivotTable using that data into a new worksheet inside your workbook.Set up your data in Excel so it is in a format that is compatible with creating a PivotTable.This lesson takes you through the following steps to build an Excel Pivot Table" Making and Using Pivot Tables in Excel What you'll learn in this lesson
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |