Microsoft KB Archive/932714

= Microsoft Office Excel 2007 Step by Step Comments and Corrections =

Article ID: 932714

Article Last Modified on 11/7/2007

-

APPLIES TO


 * Microsoft Office Excel 2007 Step by Step, ISBN 0-7356-2304-X

-



SUMMARY
This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Microsoft Office Excel 2007 Step by Step, 0-7356-2304-X.

The following topics are covered:


 * CDROM: \Appearance\acbluprt.jpg missing from companion content
 * CDROM: \Printing\ConsolidatedMessenger.png missing from companion content
 * Page xiv: Incorrect sample file name
 * Page 4: Incorrect reference to Compatibility Pack on the Companion CD
 * Page 17: Incorrect path to sample files
 * Page 23: Incorrect path to sample files
 * Page 29: Incorrect path to sample files
 * Page 43: Reference to Sales tab which does not exist
 * Page 50: Additional step needed between steps 3 and 4
 * Page 63: &quot;LastWeekMiles' should be &quot;MilesLastWeek&quot;
 * Page 72: Incorrect chapter referenced
 * Page 126: Upper-right field referenced in place of lower-right field
 * Page 223: Focusing workbook referenced in place of Editing workbook



CDROM: \Appearance\acbluprt.jpg missing from companion content
The \Appearance\acbluprt.jpg file is missing from the Companion Content. The following file is available for download from the Microsoft Download Center:

acbluprt.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

CDROM: \Printing\ConsolidatedMessenger.png missing from companion content
The \Printing\ConsolidatedMessenger.png file is missing from the Companion Content. The following file is available for download from the Microsoft Download Center:

ConsilidatedMessenger.exe

For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

Page xiv: Incorrect sample file name
On page xiv, the third item in the Chapter 13 section reads:

&quot;Macros\Performance Dashboard.xlsx&quot;

It should read:

&quot;Macros\Performance Dashboard.xlsm&quot;

Page 4: Incorrect reference to Compatibility Pack on the Companion CD
On page 4, the last sentence of the second paragraph reads:

&quot;If you want to open Excel 2007 files in Excel 2000, Excel 2002, or Excel 2003, you can install the Microsoft Office Compatibility Pack for Office Word 2007, Excel 2007, and Office PowerPoint 2007 file formats from this book’s companion CD.&quot;

It should read:

&quot;If you want to open Excel 2007 files in Excel 2000, Excel 2002, or Excel 2003, you can install the Microsoft Office Compatibility Pack for Office Word 2007, Excel 2007, and Office PowerPoint 2007 file formats from http://www.microsoft.com/downloads.&quot;

Page 17: Incorrect path to sample files
On page 17, the first sentence of step 5 reads:

&quot;Use the navigation controls to display the My Documents\Microsoft Press\Excel SBS\Setting Up\Creating folder.&quot;

It should read:

&quot;Use the navigation controls to display the My Documents\Microsoft Press\Excel SBS\Creating folder.&quot;

Page 23: Incorrect path to sample files
On page 23, the USE section in the blue box reads:

&quot;the Route Volume workbook from the My Documents\Microsoft Press\Excel SBS\Setting Up\Creating folder.&quot;

It should read:

&quot;the Route Volume workbook from the My Documents\Microsoft Press\Excel SBS\Creating folder.&quot;

Page 29: Incorrect path to sample files
On page 29, the USE section of the blue box reads:

&quot;the Route Volume workbook and the Exception Summary workbook from the My Documents\Microsoft Press\Excel SBS\Setting Up\Creating folder.&quot;

It should read:

&quot;the Route Volume workbook and the Exception Summary workbook from the My Documents\Microsoft Press\Excel SBS\Creating folder.&quot;

Page 43: Reference to Sales tab which does not exist
On page 43, step 3 reads:

&quot;On the tab bar, click the Sales sheet tab.

The Sales worksheet appears.&quot;

It should read:

&quot;Create a new worksheet titled &quot;Sales&quot; and select it.&quot;

Page 50: Additional step needed between steps 3 and 4
The Service Levels workbook contains an additional mispelling that is not addressed in the instructions on page 50.

Change:

&quot;3. Click Add to Dictionary. Excel 2007 adds the word to the dictionary and displays the next questioned word: TwoDay.&quot;

To:

&quot;3. Click Add to Dictionary. Excel 2007 adds the word to the dictionary and displays the next questioned word: withn.&quot;

Additionally, a step should be inserted between steps 3 and 4:

&quot;Click Change. Excel 2007 corrects the word and displays the next questioned word: ThreeDay.&quot;

Page 63: &quot;LastWeekMiles' should be &quot;MilesLastWeek&quot;
On page 63, Step 5 contains a reference to an incorrect sheet.

Change:

&quot;5. Edit the cell range in the Refers to field to =LastWeekMiles!$C$4:$H$4, click OK, and then click the check button next to the Refers to field.&quot;

To:

&quot;5. Edit the cell range in the Refers to field to =MilesLastWeek!$C$4:$H$4, click OK, and then click the check button next to the Refers to field.&quot;

Page 72: Incorrect chapter referenced
On page 72, the &quot;See Also&quot; section reads:

&quot;For more information about the VLOOKUP function, see “Looking Up Information in a Data List” in Chapter 15.&quot;

It should read:

&quot;For more information about the VLOOKUP function, see “Looking Up Information in a Data List” in Chapter 7.&quot;

Page 126: Upper-right field referenced in place of lower-right field
On page 126, step 18 reads:

&quot;Click the upper-right field down arrow and then click 3/14/2007.&quot;

It should read:

&quot;Click the lower-right field down arrow and then click 3/14/2007.&quot;

Page 223: Focusing workbook referenced in place of Editing workbook
On page 223, the block below the image reads:

&quot;CLOSE the Focusing workbook.&quot;

It should read:

&quot;CLOSE the Editing workbook.&quot;

Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.

Additional query words: 0-7356-2304-X 978-0-7356-2304-0

Keywords: KB932714

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.