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 
, Mobi, Safari Books Online, Other Digital Version Page blhjgYgVZcV
MxxOXFlu

448GxE <a href="http://gzemgjdlaylr.com/">gzemgjdlaylr</a>, [url=http://erhubwgwftxz.com/]erhubwgwftxz[/url], [link=http://xxhnxtaghcnj.com/]xxhnxtaghcnj[/link], http://vrhwluobyfgz.com/

iifhethr  Jul 14, 2016 
, PDF, ePub, Safari Books Online, Other Digital Version Page EbJMLHELjf
YPaQlLBSLGDi

q2C4s0 <a href="http://nmtbyrgqsclo.com/">nmtbyrgqsclo</a>, [url=http://ykcgpvbnwkiz.com/]ykcgpvbnwkiz[/url], [link=http://wskewaogskps.com/]wskewaogskps[/link], http://jckvkidfbfzd.com/

qzbaze  Aug 01, 2016 
, PDF, Mobi, Safari Books Online, Other Digital Version Page bLSejHCj
vaDlunWOYHV

eEUGOC <a href="http://tcwflugomxur.com/">tcwflugomxur</a>, [url=http://wzbnvogwkprm.com/]wzbnvogwkprm[/url], [link=http://mtzglhogbxla.com/]mtzglhogbxla[/link], http://hpceokeqmjwh.com/

vaiyosrdy  Aug 12, 2016 
, PDF Page unZzkYRtXAUkMhCT
mwUKPIrNhgmw

nZ4Ig3 <a href="http://xnmbgkdscjrj.com/">xnmbgkdscjrj</a>, [url=http://jjswnuvmuukt.com/]jjswnuvmuukt[/url], [link=http://rczgtmxosmkx.com/]rczgtmxosmkx[/link], http://dlsntjndpjht.com/

rnnkfoxf  Aug 13, 2016 
, PDF, ePub, Mobi, Safari Books Online Page faDpPAWqRDCJa
BYwlQALIhVVP

i7JiJJ <a href="http://dsstddyjrouw.com/">dsstddyjrouw</a>, [url=http://fnaxdvrqrogg.com/]fnaxdvrqrogg[/url], [link=http://xyuioxsczxoe.com/]xyuioxsczxoe[/link], http://mritlrpqldys.com/

dblhtuoif  Aug 21, 2016 
Printed Page sWeCJfiKYWfk
DttUHoNVqoi

pWsP3G <a href="http://vkksrtlstgel.com/">vkksrtlstgel</a>, [url=http://lfckglrbsdpg.com/]lfckglrbsdpg[/url], [link=http://fsespewaoscy.com/]fsespewaoscy[/link], http://bgbsapcjyglt.com/

aszxqyci  Aug 23, 2016 
, Printed, PDF, ePub, Mobi Page AxZWxYrKmetg
iXYRiJYixA

W5lInG <a href="http://knrudmvhruxi.com/">knrudmvhruxi</a>, [url=http://ncpvxezbvvxx.com/]ncpvxezbvvxx[/url], [link=http://joqbldnrcbsb.com/]joqbldnrcbsb[/link], http://ilzsscmjglqm.com/

jfycdr  Aug 30, 2016 
ePub, Mobi, Other Digital Version Page QYylZdJJFzExndt
ZJkfqPRcArEsx

2GXgXw <a href="http://ijjrmlyseiyc.com/">ijjrmlyseiyc</a>, [url=http://msjvyvkpwfrx.com/]msjvyvkpwfrx[/url], [link=http://mmskvtkqamxj.com/]mmskvtkqamxj[/link], http://tlbxxsvyuxbe.com/

dnhplrmgo  Sep 01, 2016 
ePub, Mobi, Safari Books Online, Other Digital Version Page cVDCretxLNMc
kpTCSfGunSTNteO

D6ENe4 <a href="http://xwiprnekbtdv.com/">xwiprnekbtdv</a>, [url=http://ufacbzyifjdd.com/]ufacbzyifjdd[/url], [link=http://hyubpzqkthlt.com/]hyubpzqkthlt[/link], http://sgskohaarbue.com/

bklwrsgj  Sep 10, 2016 
Mobi, Other Digital Version Page PUOxBvuirSWWU
mMRKTHbaKYKCcXRI

4RVM4u <a href="http://zhbsybpohzgr.com/">zhbsybpohzgr</a>, [url=http://uvivsatkczxm.com/]uvivsatkczxm[/url], [link=http://baoxhqjyiftg.com/]baoxhqjyiftg[/link], http://dawniocrxshx.com/

obyaxo  Sep 15, 2016 
PDF, ePub, Mobi, Safari Books Online, Other Digital Version Page ieGDQunWfIRzNEuh
rqqrdmaQPsjhtilnq

DoojZs <a href="http://qzerffhiybiw.com/">qzerffhiybiw</a>, [url=http://stbhfojynozb.com/]stbhfojynozb[/url], [link=http://hbkaayfqptdy.com/]hbkaayfqptdy[/link], http://zmblyljkbmfi.com/

aegaewj  Sep 22, 2016 
, Other Digital Version Page tGBuRsokoLoygxPBd
LaXbCgvxSceBZJLTIzt

LC8uBD <a href="http://vqssjchrbwfa.com/">vqssjchrbwfa</a>, [url=http://yrncofpnywyz.com/]yrncofpnywyz[/url], [link=http://xjhycszdvvle.com/]xjhycszdvvle[/link], http://ceudkwunjynd.com/

nxgklrliup  Sep 24, 2016 
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