Skip navigation

Opening old worksheets

Opening old worksheets: Excel 2007 Essential Training
Opening old worksheets: Excel 2007 Essential Training

Join for an in-depth discussion in this video Opening old worksheets, part of Excel 2007 Essential Training.

Resume Transcript Auto-Scroll
Skill Level Beginner
5h 13m
Duration
3,107,491
Views
Show More Show 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.

Q: Where can I learn more about Excel formulas?

A: Discover more on this topic by visiting Excel formulas on lynda.com.

Skills covered in this course
Business Spreadsheets Excel

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now