Excel 2013: The Missing Manual

Errata for Excel 2013: The Missing Manual

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.


Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted
Printed Page XXIV
Feedback paragraph

The sentence reads: "On our Feedback page, you can get expert answers to questions that come to you while reading, share your thoughts on this Missing Manual, and find groups for folks who share your interest in Dreamweaver." The book is about Excel 2013 not Dreamweaver.

Carl Paulus  May 18, 2013 
Printed

I am working through your missing manual for Excel 2013 and was working on pivot tables. I first read your manual then made a copy of the data to put what I had learned into practice. I started getting a problem with the grand total when filtering the columns for Ship Country and Ship City. I assumed it was me so I returned to your spreadsheet supplied with the manual but I still had the problem. I tried the e-mail address emailus@missingmanuals.com but got a message back to say the address was no longer valid. Will send detailed description to a valid e-mail address..

Russell Frearson  Apr 15, 2014 
Printed Page XXIV
5th paragraph under Feedback

"... folks who share your interest in Dreamweaver." This should say Excel, not Dreamweaver, because this is the Missing Manual for Excel 2013.

Bryan Leed  May 14, 2014 
ePub Page 1
all over

Errors are everywhere. The cut off words almost render the reading useless

timothy koerner  May 02, 2013 
Printed Page 20
Last paragraph

The book says "To see the list of possibilities, right click the status bar (Figure 1-8). Table 1-2 describes the options." The actual figure being referred to in the book is Figure 1-18. The actual table being referred to in the book is Table 1-1.

Carl Paulus  May 26, 2013 
Printed Page 24
Paragraph underneath Figure 1-19

The book says: "To get out of backstage view and return to your worksheet, press Esc or click the arrow-in-a-circle icon in the top-right corner of backstage view." The arrow-in-a-circle icon is actually at the top-left corner of the backstage view, as can be seen in Figure 1-19

Carl Paulus  May 27, 2013 
Printed Page 29
TIP at bottom of page

2nd sentence says "Usually, .xlsx and .xlsb are just as fast." I think it should be "Usually, .xlsx and .xlsm are just as fast."

Craig Jones  Apr 13, 2014 
PDF Page 273
1st paragraph

Your 1st paragraph has has a sentence that reads "you can use the AVERAGE() function, which counts all text cells as though they contain the number 0" The function that counts cells that contain text (and FALSE) as 0, TRUE as 1 is actually AVERAGEA().

Lily Humdinger  Aug 11, 2014 
Printed Page 349
Box at bottom labeled POWER USERS' CLINIC - Advanced Text Lookup

your formula =VLOOKUP(B2, B15:F81, 2, FALSE) ***AND*** the latter formula using the & and * Wildcard would both return the UNIT PRICE of the item and NOT the Product Name.

Craig Jones  Apr 21, 2014 
Printed Page 475
FIGURE 16-6

The last statement, "Excel calculates the rest automatically, using the financial functions you learned in Chapter 10" is incorrect.. I looked at the formulas for the table in the figure and the formulas are not shown in the Chapter 10. For example, how do you decipher the following code for the first line: =IF(Values_En=IF(Pay_Num<>"",DATE(YEAR(Loa=IF(Values_Entered,Loan_Amount,"") etc. I tried to get all the code but the template prevented me from doing this because I could not enlarge the text boxes. You should remove this statement altogether because many readers will go to the template and try to use the same code in their own programs. I explored this template because the book did not show me how to create a range of cells if you are given the number of cells. For example, if the number of payments is 60, how do you generate a table with 10 columns and 60 lines with a simple statement without manually selecting this range of cells on the worksheet? P.S. On page 306, POWER USERS 'CLINIC, top line: CUMPIPMT( ... )" should be written CUMIPMT(...) ".

Manuel Portal Jr  Oct 30, 2014 
Printed Page 794
Figure 26-3

Figure 26-3 identifies a summary amount value within the table of $4,300.00 (cell: E19) for a Seattle Male and $2,530.00 (cell: F19) for a Seattle Female. The correct values should be: E19: $2,270.00 & F19: $3,675.00

Alan Openshaw  Jan 31, 2014