Errata
The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".
The following errata were submitted by our customers and approved as valid errors by the author or editor.
Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted By | Date submitted | Date corrected |
---|---|---|---|---|---|
Printed | Page xxxiii 1st paragraph |
The URL given for the practice files is easy to misread. The capital letter 'I' which appears after the 'k' in the word 'LinkId' is easy to mistake for a lowercase 'L'. Note from the Author or Editor: |
Microsoft Press | Oct 17, 2010 | Sep 09, 2011 |
Printed | Page xxxvii 2nd paragraph |
The URL given for the book's errata page is easy to misread. The capital letter 'I' which appears after the 'k' in the word 'LinkId' is easy to mistake for a lowercase 'L'. Note from the Author or Editor: |
Microsoft Press | Oct 17, 2010 | Sep 09, 2011 |
Printed | Page 74 Numbered paragraph 4 |
At the end of the numbered paragraph 4 after the closing parenthesis in the formula, insert the following: Note from the Author or Editor: |
Anonymous | Jul 15, 2011 | Sep 09, 2011 |
Printed | Page 79 Last line of text |
The cell reference to D1 should be to D21. |
Curtis Frye |
Mar 16, 2011 | Sep 09, 2011 |
Printed | Page 133 3rd paragraph |
The description of the exercise states: ?In this exercise, you?ll ? create an AGGREGATE formula to summarize the visible cells in a filtered worksheet ??. However, the exercise does not apply the formula to a filtered worksheet, but an unfiltered worksheet, diminishing the demonstration of the formula. Note from the Author or Editor: |
Jess Rose | Aug 25, 2011 | Sep 09, 2011 |
Printed, PDF, ePub, Mobi, , Other Digital Version | Page 133 Procedure Step 2 |
Step 2 of the procedure contains the following text on Safari: |
Curtis Frye |
Sep 16, 2013 | |
Printed | Page 189 First line of second paragraph |
The word "orksheets" should be "worksheets". |
Curtis Frye |
Mar 16, 2011 | Sep 09, 2011 |
Printed | Page 206 Step 27 |
When you click "Solve" the Solution does not recognize the "integer" constraint on Cell E8. Cell E8 comes up as 13.25 and cell E5 comes up as "20". These values do not match what is in the book on page 207 (which shows 14 and 18 respectively). It is my understanding that "integer constraints" are quite demanding, but the results I get appeared right away (calc time not a factor). Note from the Author or Editor: |
Anonymous | Oct 15, 2010 | Sep 09, 2011 |
Printed, PDF, | Page 207 United States |
Step 27: The Solver Results are wrong in the book. What is the correct results. I have used Step by Step in Excel 2007, after correcting the three mistakes (changing the three entries with equal signs to >=) and I get the same answer as in Excel 2010. Could you respond back with the correct results, so everyone knows? I want to make sure my results are correct. Note from the Author or Editor: |
Anonymous | Oct 14, 2013 | |
Printed | Page 239 Text of Step 1 |
The reference to Sheet2 should instead be to the worksheet named PivotTable. |
Curtis Frye |
Mar 16, 2011 | Sep 09, 2011 |
Printed | Page 339 Text of Step 12's result step |
Delete the words "and then removes the highlight from cells C3:C9." The sentence should read "Excel formats the cells' contents in bold." |
Curtis Frye |
Mar 16, 2011 | Sep 09, 2011 |
Printed | Page 437 |
The URL given for downloading the eBoook has typo. Note from the Author or Editor: |
Patricia | Mar 07, 2012 | Jul 20, 2012 |