Errata for Microsoft® Excel® 2010 Step by Step
Submit your own errata for this product.
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 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'.
Change:
"go.microsoft.com/fwlink/?LinkId=191751"
To:
"http://go.microsoft.com/fwlink/?Linkid=191751"
Note from the Author or Editor:
Error corrected. Will be fixed in next printing. |
Microsoft Press |
Oct 17, 2010 |
Sep 09, 2011 |
| 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'.
Change:
"go.microsoft.com/fwlink/?LinkId=191751"
To:
http://go.microsoft.com/fwlink/?Linkid=191751
Note from the Author or Editor:
Error corrected. Will be fixed in next printing. |
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:
, and press Enter.
Note from the Author or Editor:
Yes, we should make the suggested correction. |
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.
Also, by placing this function even with the first row of data (cell J3), you are violating your own important tip on page 130 to place your SUBTOTAL (or in this case AGGREGATE) even with or above headers. When I attempted to apply a filter (to demonstrate the AGGREGATE function), this cell was hidden!
Note from the Author or Editor:
The reader filters the worksheet later in the exercise (steps 3-5), so the value of the AGGREGATE function does change. The second note, that the formula result is obscured by the filter, is absolutely correct. I'll have to change the sample file so the Summary heading is in cell J1 and the formula is typed into cell J2. I'll need to take a new screen shot for the reprint.
The images on pages 134 and 135 were replaced to reflect this change.
Also on page 133, we made the following changes:
In step 2, change the reference to cell J3 to cell J2.
In the result step following step 2, change the reference to cell J3 to cell J2. |
Jess Rose |
Aug 25, 2011 |
Sep 09, 2011 |
| 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).
So please advise.
Note from the Author or Editor:
In Excel 2010, the Ignore Integer Constraints option is turned on by default. To turn the option off, in the Solver Parameters dialog box, click Options. On the All Methods page of the dialog box, uncheck the Ignore Integer Constraints box and click OK.
We can add a note using the text above on page 205 below step 8 and delete the image near the top of page 206 to make room for it. |
Anonymous |
Oct 15, 2010 |
Sep 09, 2011 |
| 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.
The capital letters 'FWL' which appear after the '.com/' should be in lowercase.
Change:
"http://"go.microsoft.com/FWLink/?LinkId=224345"
To:
"http://"go.microsoft.com/fwlink/?LinkId=224345"
Note from the Author or Editor:
This is an error. Please have the editorial team update the URL to the correct one, which might be different from the original in the book. |
Patricia |
Mar 07, 2012 |
Jul 20, 2012 |
|
| |
