Join Rudolph Rosenberg for an in-depth discussion in this video Using PivotTables, part of Financial Analysis: Analyzing the Top Line with Excel.
…So, what is a pivot table?…A pivot table is a tool provided by Excel that instantly turns your…spreadsheet full of data into a table that automatically summarizes for…you any number you're looking for.…Now, let's look at how to use pivot tables.…To do that, let's again use our sample dataset.…While you have the dataset projected on screen,…go to the insert menu at the top of your screen and then click on pivot table.…Once you do that, a window opens.…
You will see that Excel automatically selects the range of data that you…will be using.…If we scroll down to the bottom of the page, you will see that it…has automatically selected all the rows you have and all the columns you have.…Let's make sure that you have the option, new worksheet selected, and click okay.…The pivot table is automatically created on a different page.…This page is currently called sheet 1.…Let's rename it to, Pivot.…Now, you can see on the right side of your Excel page,…there is a new section that has been created.…
And in this section is the list of all the fields that you have in your dataset.…
Also check out the companion course, Financial Analysis: Analyzing the Bottom Line with Excel.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Preparing your revenue information
- Comparing past performance
- Analyzing customer data
- Analyzing product information
- Identifying exceptional revenue