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.
Version |
Location |
Description |
Submitted By |
Date submitted |
Date corrected |
PDF |
Page 8
1st paragraph |
Says "see 'Filtering with slicers' on page -." with no page number given.
Note from the Author or Editor: Dear Reader: Thanks for the catch!
O'Reilly: Should say Page 794.
|
Brien |
Oct 10, 2010 |
Jul 22, 2011 |
Printed |
Page 11
3rd bullet point of 3rd paragraph |
The total amount of computer memory that Excel could previously use (prior to Excel 2007) is stated as 1 megabyte. I believe that it was actually 1 gigabyte (1GB).
Note from the Author or Editor: Thanks for the catch.
|
Anonymous |
Jan 22, 2013 |
Jul 19, 2013 |
Printed |
Page 17
2nd sentence of 2nd paragraph |
"there will certainly be a or service pack..."
Either a word is missing before "or", or more likely this word is just extraneous.
Note from the Author or Editor: Thanks for the careful review.
|
Anonymous |
Jan 22, 2013 |
Jul 19, 2013 |
PDF |
Page 68
top line, 1st paragraph |
Says "To save an Excel 2010 or 2007 file to share with someone using the Mac version of Excel... Save As ... 97-2003 ..."
Needs updated. Excel 2008 can open these files. Excel 2011 can open these files. After Excel 2004, this advice has no longer been relevant.
Note from the Author or Editor: If possible, reword thusly:
"To save an Excel 2010 or 2007 file to share with someone using a version of Macintosh Excel older than the 2008 release, ... "
|
Brien Muller |
Oct 20, 2010 |
Jul 22, 2011 |
Printed |
Page 105
NOTE Box bottom of the page |
Shortcut for worksheet formula view listed as "Ctrl+'", should be "Ctrl+`".
Note from the Author or Editor: The reader is correct, it's a typo. The straight single quotation mark should be an accent grave.
Existing: "Ctrl+'"
Should B: "Ctrl+`"
Thanks,
=Mark
|
Andrey |
Apr 19, 2011 |
Jul 22, 2011 |
Printed, PDF |
Page 137
2nd Paragraph |
The term "region" is defined here as a block of "filled cells". Yet the last sentence of the paragraph contradicts this definition by saying that an "empty cell", in the example shown, is part of the region.
Since this is the first place in the book that the term "region" is defined, it would be appropriate to define region here as "a rectangular block of cells bounded by blank rows, blank columns, or worksheet borders". I believe this is the accurate definition, and is, in fact, described this way on page 146, "Current Region".
Note from the Author or Editor: Update the current (2013) edition.
>Chapter 6
>Under the heading "Moving Around Regions"
>Replace the first sentence ("A region is a rectangular ...")
>With the following sentence: A region is defined as a rectangular block of cells bounded by blank rows, blank columns, or worksheet borders.
|
Morris Kranz |
Aug 03, 2013 |
|
Printed, |
Page 151
5th paragraph |
Text states:
"To enter a negative exponential number, type a minus sign before the exponent."
Text continues:
"For example, ?1E6 (1 times 10 to the negative sixth power) equals ?1,000,000 and is displayed in Excel as ?1.00E+06."
Typing a minus sign before an exponent does not convert the value to a negative number; it produces a fraction. In the example, 1 times 10 to the negative sixth power would equal 0.000001 (not negative 1,000,000).
Note from the Author or Editor: There are two errors here. The first sentence should read:
"To enter a negative exponential number, type a minus sign before the number."
"For example, -1E6 (negative 1 times 10 to the sixth power) equals ..."
|
Morris Kranz |
May 13, 2012 |
Jun 29, 2012 |
Printed |
Page 158
4th paragraph |
"The Undo button remebers the last 16 actions you performed". On page 224 "The Undo includes a drop-down list of up to the last 100 actions you performed". Maybe the first text refers to older versions?
Note from the Author or Editor: True. On page 158, the second and third sentences in the 4th paragraph should be changed to read:
"The Undo button remembers the last 100 actions you performed. If you Ctrl-Z repeatedly, each of the last 100 actions is undone ..."
|
Britt Tagmark |
Jul 31, 2011 |
Jun 29, 2012 |
Printed, PDF, |
Page 162
5th Bulleted Paragraph |
Text states:
"You can move or copy nonadjacent worksheets at the same time by pressing Ctrl while you click to select the sheet tabs. Before dragging, release the Ctrl key to move the selected worksheets, or keep holding it down to create copies."
The aforementioned technique as stated will not work. Regardless of the inention to move or copy, both the mouse and Ctrl key should first be released after selecting the worksheet tabs. Then, re-click and drag one of the highlighted tabs to move the group, or click and hold down the Ctrl key while dragging to copy the group.
The description of how to move or copy worksheets using the mouse, is more accurately described in the Inside Out section on page 259.
Note from the Author or Editor: It actually does work sometimes if you keep holding Ctrl, but only sometimes. So, let's make it more accurate and change the quoted errata reference to the following:
"You select nonadjacent worksheets at the same time by pressing Ctrl while you click to select the sheet tabs. Then you can click any selected tab and drag to move the group, or click, press Ctrl and drag to create copies."
|
Morris Kranz |
Jun 17, 2012 |
Jun 29, 2012 |
Printed, PDF, |
Page 225
2nd Paragraph |
Text reads:
"Repeat is valid only if Undo was your last action."
Redo (not Repeat) is valid only if Undo was your last action.
Note from the Author or Editor: Yes, this is an error. Please change the quoted text reference to:
"Redo is valid only if Undo was your last action."
|
Morris Kranz |
Jun 17, 2012 |
Jun 29, 2012 |
Printed, PDF, |
Page 454
2nd Paragraph (Note) |
Text reads:
"You can display all comments on the worksheet by clicking the Show All Comments button on the Page Layout tab on the ribbon."
The Show All Comments button is found on the Review tab (not the Page Layout tab).
Note from the Author or Editor: Yep. Please change quoted text to:
"You can display all comments on the worksheet by clicking the Show All Comments button on the Review tab on the ribbon."
|
Anonymous |
Jun 17, 2012 |
Jun 29, 2012 |
Printed |
Page 518
Last Paragraph |
Text reads: "You need to click the Change Source button to locate the Actual workbook...".
Text should have read: "You need to click the Change Source button to locate the Budget workbook...".
Note from the Author or Editor: Chapter 12, "Saving Linked Workbooks" fourth paragraph:
Existing Text: "You need to click the Change Source button to locate the Actual workbook."
Change to Read: "You need to click the Change Source button to locate the Budget workbook."
|
Morris Kranz |
Apr 03, 2013 |
Jul 19, 2013 |
Printed |
Page 539
2nd Paragraph |
Text states: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different ranges to sum, each with their own criteria".
Actually, the function allows only ONE (1) range to sum. You may specify up to 127 conditional ranges, each with its own criteria, but only one range is summed.
Note from the Author or Editor: Chapter 14, page 2, "The SUMIF, SUMIFS, and COUNTIF functions," second paragraph:
Existing Text: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different ranges to sum, each with their own criteria."
Change to Read: "The SUMIFS function does similar work to that of the SUMIF function, except you can specify up to 127 different conditional ranges, each with their own criteria."
|
Morris Kranz |
Apr 03, 2013 |
Jul 19, 2013 |
Printed |
Page 548
3rd Section - Practical Text Manipulation |
In this section, the author points out that one might want to use the TRIM function on column A to be sure there are no extra spaces.
With that in mind, it should also be pointed out that the result of the formula, =LEFT(A2,SEARCH(" ",A2)), will produce first names, each with one trailing blank space.
If you care about the trailing space, you could embed the formula in the TRIM function (as an argument to the TRIM function), or more simply, edit the 2nd argument of the LEFT function to read "SEARCH(" ",A2) - 1"
By the way, a very minor point just noticed:
The column headings for Last Name and First Name are reversed.
Note from the Author or Editor: The very minor point at the end is the errata in this message. I thought that this had already been corrected, but I didn't see it in the errata list. The graphic in the sidebar needs to be corrected. I can provide it, but not sure how in this system.
The column headers should be, from left to right: Full Name, First Name, then Last Name. Only the headers change, not the contents of the columns.
|
M.K. |
May 28, 2013 |
Jul 19, 2013 |
Printed |
Page 553
2nd Paragraph from Bottom |
Regarding the COUNTBLANK function:
Text states: This function is tricky because formulas that evaluate to null text strings, such as....aren't counted".
I believe the author meant to say "blank" text strings rather than null text strings.
Note from the Author or Editor: Revisited 7/15/13: Change the second sentence under "The COUNTBLANK Function" to read: "This function is tricky because formulas that evaluate to blanks (=" ") or to zero are not counted, but formulas that evaluate to nulls (="") are counted."
|
Morris Kranz |
Apr 20, 2013 |
Jul 19, 2013 |
Printed |
Page 554
3rd Section - An ISERR Example |
Text States: "If the string isn't found, you want the cell to remain empty."
However, if the formula, =IF(ISERR(FIND("12A", A1)), " ", "Yes") evaluates to false, the function will return a blank space, causing the cell to not be empty.
If the intention is to have the cell remain empty, the 2nd argument to the IF function should be a null ("") string, rather than a space (" ").
Note from the Author or Editor: Change the third sentence in the sidebar on page 554, "An ISERR Example," to read:
"If the string isn't found, you want the cell to remain blank."
Also, change the formula shown in the second paragraph of the sidebar (the only difference here is that there is no space between the second set of quotation marks) as follows:
=IF(ISERR(FIND("12A", A1)), "", "Yes")
|
Morris Kranz |
Apr 20, 2013 |
Jul 19, 2013 |
Printed |
Page 755
Figure 22-15 |
The criteria shown in Figure 22-15 will produce a list that includes lot sizes GREATER THAN 2 (acres) only. Lot sizes EQUAL TO 2 will NOT be included.
This does not coincide with the text in the last paragraph on Page 753 which states that homes of AT LEAST 2 acres are desired.
Note from the Author or Editor: On page 753, third sentence: change "at least 2 acres" to "more than 2 acres"
On Page 755, the caption for figure 22-15: change "at least 2 acres" to "more than 2 acres"
|
Morris Kranz |
Jul 13, 2013 |
Jul 19, 2013 |
Printed |
Page 766
2nd parapraph |
Change "[#Age]" to "[Age]"
Note from the Author or Editor: Thanks for the catch. Nice proofreading.
O'Reilly: True. Please delete the "#" as described.
|
Brian Angus |
Sep 09, 2010 |
Jul 22, 2011 |
Printed |
Page 804
2nd paragraph |
Not really a mistake--let's say "Oversight"--but it definitely is SERIOUS.
All I wanted to do was subtract the data is Column B from the data in Column A. So simple--and I had your book to guide me. But still, I churned and churned for hours--getting nowhere.
My problem was that--under "Pivot Table Tools/Options"--when I clicked on "Fields, Items, & Sets", the "Calculate Field" menu selection was greyed out. I tried everything imaginable to tweak the app into cooperating. But no luck!
I have since found the problem and feel that this portion of the book--on "Using Calculated Fields and Items" needs to have a VERY bold note explaining that:
"You cannot create a calculated field or a calculated item in a PivotTable based on OLAP source data."
None of what you describe on pgs. 804-806 will work if the data source is an OLAP cube.
Here is the reference to the relate KB article:
http://support.microsoft.com/kb/234700
Note from the Author or Editor: True. Thanks for the tip!
O Reilly: His suggested note would work great ... if it's possible to add it without page break repercussions.
Thanks,
=Mark
|
Dr. Edward Hanna |
Nov 15, 2010 |
Jun 29, 2012 |
Printed |
Page 840
2nd Paragraph |
Text reads: "Creating Exact-Math Criteria".
Should read: "Creating Exact-Match Criteria".
Note from the Author or Editor: Second paragraph boldface "Creating Exact-Math Criteria"
should read "Creating Exact-Match Criteria".
|
Morris Kranz |
Jul 13, 2013 |
Jul 19, 2013 |
PDF |
Page 862
4th paragraph |
The text in Excel 2010 Inside Out says ", Most of the buttons on the Drawing toolbar aren't available either". The above mentioned quote is true for Excel 2003, but since the current edition of this book is about Excel 2010, I would suggest something like ". The Drawing Tools tab is not available either". There is also a grammar error (I would recommend a period here, instead of the comma that the text uses).
Note from the Author or Editor: >>Change two sentences of the sidebar: "What You Can and Can't Do With a Shared Workbook," to read:
The Conditional Formatting, Scenarios, and Data Validation commands are not available for a workbook in shared mode (although you can still see their effects). Most of the tools on the Insert tab aren't available either.
>> The first sentence above is unchanged except for a period at the end instead of a comma.<<
|
Anthony B Croucher |
Dec 21, 2011 |
Jun 29, 2012 |