On September 14th, 2017, we published revised versions of our Privacy Policy, Terms of Service and Website Use Policy and published a Cookie Policy. Your continued use of Lynda.com means you agree to these revised documents, so please take a few minutes to read and understand them.

Laying out your PivotTable

In your Pivot Tables options tab,…in the first grouping under Pivot Table, you have the ability to name your Pivot Table directly here. So I can…change it from the default to EatCake Pivot Table.…Under here, you can find other Pivot Table options, but we'll save that for a more advanced…movie.…Under your active field,…it will default to add up the items…in the body of your Pivot Table in here, but what you also could do is go to your Field Settings tab and change…the type of calculations that's being done…on those values. If you wanted to count…the individual values that you see, want to average them, find the maximum or minimum in the area, you can also show that…here.…

Also, you could show the value in different formats. So you have lots of choice and options of…what data is included here in your active fields.…You can group your data,…for better selection than sorting, you can sort it,…so that it can be presented alphabetically, or in other sorting manners.…You can also set up your data so that it's automatically updated from an external source.…

Resume Transcript Auto-Scroll

Author

Released

1/31/2007

Like the other applications in Microsoft Office 2007, Excel 2007 boasts upgraded features and a brand-new look. In Excel 2007 Essential Training , instructor Lorna A. Daly introduces the new version in detail. The training begins with the essentials of using the program, including how and why to use a spreadsheet, how to set up and modify worksheets, and how to import and export data. Lorna then moves on to teach more advanced features, such as working with functions and macros. Exercise files accompany the tutorials.

Skill Level Beginner

5h 13m

Duration

3,082,442

Views

Show MoreShow Less

Q: When trying to apply the techniques from the “Relative and absolute referencing” video to a worksheet other than the exercise file included with the title, the formulas did not work for the entire worksheet. The formulas would only work when going through the worksheet row by row. What could be causing this to happen?

A: When trying to apply formulas to a whole workshee, here is a tip to try:

If you want to always refer to the same cell then use an absolute reference. For example, always pulling the value from cell A3 would be referenced as $A$3. This will never change no matter where you copy it to in the spreadsheet.

If you want to reuse the same formula, but with values in different cells, use the relative reference, A3. This way formula =A3*B3 will become =A4*B4 as you copy it down a column.

Q: In the chapter 7 video "Sorting and Grouping" at approximately 4:05, the author says to go to cell 5 on the worksheet and click on Subtotal to subtotal the grouping. My screen will not allow me to click on the Subtotal option at the top of the page. Is this an issue with my version of Excel?

A: It seems that there is an error in the instructions in this video. The video should have instructed users to do the subtotaling first, then create the table.