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 Page hrfkdxga
USA

paper writing services <a href=https://essayonline.us.com>More about the author</a> homework help online https://essayonline.us.com - buy college essays online

JamesSok  Dec 14, 2017 
Mobi Page owinkzvy
USA

cash loan <a href="https://loan.us.org">cash loans</a> bad credit loans direct lenders <a href=https://loan.us.org>cash loans</a>

Best Online Loans   Dec 14, 2017 
Other Digital Version ncmfjlvn
USA

free sex web chat <a href="https://freechatrooms.webcam">free chat rooms</a> sex chat free <a href=https://freechatrooms.webcam>free live sex shows</a> college math homework help <a href="https://bestessaywritingservice.science">best essay writing service</a> best essay writing service <a href=https://bestessaywritingservice.science>best essay writing service</a> payday bad credit loan <a href="https://paydaybadcreditloan.bid">bad credit payday loans</a> payday loans for bad credit <a href=https://paydaybadcreditloan.bid>online payday lenders</a> buy essays <a href="https://buyessays.stream">homework helper websites</a> college essays <a href=https://buyessays.stream>buy essays</a> free sex cam chat <a href="https://freesexcamchat.cricket">free sex cam chat</a> free sexy webcams <a href=https://freesexcamchat.cricket>free webcam sex chat</a> where can i buy essays <a href="https://schoolpapers.trade">solve my math</a> research paper writers <a href=https://schoolpapers.trade>school papers</a> check into cash <a href="https://directpaydayloanlenders.webcam">payday loan direct lenders</a> direct lenders no credit check <a href=https://directpaydayloanlenders.webcam>online payday advance</a> bad credit payday loans direct lenders <a href="https://badcreditpaydayloansdirectlenders.cricket">bad credit payday loans direct lenders</a> bad credit payday loans direct lenders <a href=https://badcreditpaydayloansdirectlenders.cricket>online payday advance</a> webcam porn sites <a href="https://adultcamsites.trade">free adult cam to cam</a> adult cam sites <a href=https://adultcamsites.trade>free sex web chat</a>

JamesSok  Dec 14, 2017 
Other Digital Version oaawxgjs
USA

cash loans <a href="https://loan.us.org">loan</a> cash loans <a href=https://loan.us.org>online loans</a>

Pay Day Loans   Dec 14, 2017 
Other Digital Version lhzdysbn
USA

buy essay <a href=https://buyessay.us.com>buy essay</a> buy essays https://buyessay.us.com - order essay

JamesSok  Dec 14, 2017 
Mobi Page bsbtnksb
USA

cash advance <a href="https://cashadvance.us.org">loans online bad credit</a> online payday advance <a href=https://cashadvance.us.org>cash advance</a>

Payday Loan   Dec 14, 2017 
Safari Books Online newgbadb
USA

small payday loans <a href="https://smallpaydayloans.bid">small payday loans</a> small payday loans <a href=https://smallpaydayloans.bid>payday loans online</a> payday loans bad credit <a href="https://paydayloansforbadcredit.stream">payday loans for bad credit</a> payday loan near me <a href=https://paydayloansforbadcredit.stream>advance payday loans</a> chat sex <a href="https://chatsex.bid">web cam porno</a> porn webcam <a href=https://chatsex.bid>free sex chat</a> help me on my math homework <a href="https://illustrationessay.trade">essay corrector</a> doing homework for money <a href=https://illustrationessay.trade>illustration essay</a> easy payday loans online <a href="https://easypaydayloansonline.science">best payday loans online</a> easy payday loans online <a href=https://easypaydayloansonline.science>easy online payday loans</a> pay to have homework done <a href="https://researchpaperproposal.trade">research paper proposal</a> do math homework for me <a href=https://researchpaperproposal.trade>write my assignments</a>

JamesSok  Dec 14, 2017 
ePub Page fiwcdisu
USA

buy an essay cheap <a href=https://buyessay.us.com>buy an essay online cheap</a> buy an essay uk https://buyessay.us.com - essay buying

JamesSok  Dec 15, 2017 
Mobi Page ovhxodqx
USA

get a loan <a href="https://loan.us.org">loan</a> emergency loan no credit check <a href=https://loan.us.org>loan</a>

Fastest Payday Loan   Dec 15, 2017 
Mobi Page ardivhlz
USA

loan <a href="https://loan.us.org">payday cash advances</a> loans <a href=https://loan.us.org>cash loans</a>

Payday Loans   Dec 15, 2017 
Mobi Page pcrtailm
United States

argumentative essay <a href="https://argumentativeessay.us.com">paper writing</a> argumentative essay <a href=https://argumentativeessay.us.com>homework hotline online</a>

Buying Essays Online   Dec 15, 2017 
Safari Books Online exnwvurd
United States

college essay prompts <a href="https://collegeessays.us.com">college essays</a> college essay help <a href=https://collegeessays.us.com>college essays online</a>

Write Essay Online   Dec 15, 2017 
Mobi Page fnrcabhb
USA

the best online payday loans <a href="https://payday.us.com">quick cash loans</a> fast cash loans <a href=https://payday.us.com>payday cash loan</a>

Easy Payday Loan   Dec 15, 2017 
PDF Page cldffkaj
USA

custom essay writing <a href=https://writemyessay.us.com>write essay online</a> buy an essay https://writemyessay.us.com - write my essay

JamesSok  Dec 15, 2017 
Mobi Page jwclyxxg
USA

online loans <a href="https://loan.us.org">get a loan</a> same day payday loans online <a href=https://loan.us.org>payday loan</a>

Payday   Dec 15, 2017 
ePub Page mdgdkuky
United States

college essays <a href="https://collegeessays.us.com">college essays</a> buy online essays <a href=https://collegeessays.us.com>college essays</a>

The Assignments   Dec 15, 2017 
Other Digital Version hxlmdixy
USA

best cash loans online <a href="https://payday.us.com">payday</a> payday <a href=https://payday.us.com>best cash advance loans online</a>

Best Online Loans   Dec 15, 2017 
ePub Page mhxgkiol
USA

free erotic chat <a href="https://freechatrooms.webcam">free chat rooms</a> free chat rooms <a href=https://freechatrooms.webcam>free sex chat</a> payday loans <a href="https://quickloans.trade">quick loans</a> quick loans <a href=https://quickloans.trade>quick loans</a> small payday loans <a href="https://smallpaydayloans.bid">loans online instant approval</a> payday express <a href=https://smallpaydayloans.bid>same day payday loans no credit check</a> free sex chat sites <a href="https://freesexcamchat.cricket">free sex cam chat</a> live free sex chat <a href=https://freesexcamchat.cricket>free sex cam chat</a> free sex chat <a href="https://chatsex.bid">free sex webcam</a> hot porno show <a href=https://chatsex.bid>chat sex</a> sex chat cam <a href="https://freewebcamsex.stream">free sex webcam</a> free sex webcam <a href=https://freewebcamsex.stream>free sex webcam</a> college essay help <a href="https://collegeapplicationessay.bid">college essay help</a> college application essay <a href=https://collegeapplicationessay.bid>college essay help</a>

JamesSok  Dec 15, 2017 
Safari Books Online fytkwxsd
US

buy essay online <a href=https://essayonline.us.com>online essay writer</a> write essays online <a href=https://essayonline.us.com>write my essay online</a>

JoeSok  Dec 15, 2017 
Other Digital Version ywpmyvem
USA

cash loan <a href="https://loan.us.org">loan</a> loan <a href=https://loan.us.org>loan</a>

Direct Lender Loans   Dec 15, 2017 
Mobi Page dbypblms
USA

essay corrector <a href="https://illustrationessay.trade">mechanical engineering homework help</a> illustration essay <a href=https://illustrationessay.trade>essay help</a> loan cash <a href="https://cashadvanceloan.bid">easy cash payday loan</a> cash advance lenders <a href=https://cashadvanceloan.bid>cash advance loan</a> easy online payday loans <a href="https://easypaydayloansonline.science">easy payday loans online</a> easy online payday loans <a href=https://easypaydayloansonline.science>easy payday loans online</a> research writing <a href="https://researchwriting.stream">research papers</a> research essay <a href=https://researchwriting.stream>pay someone to do your homework</a>

JamesSok  Dec 15, 2017 
Safari Books Online mnjpifgu
United States

college essays <a href="https://collegeessays.us.com">college essay prompts</a> buy essays <a href=https://collegeessays.us.com>assignment writing service uk</a>

Paper Writer   Dec 15, 2017 
Mobi Page lgzudamd
US

more information <a href=https://paydayloans.us.org/>as example</a> loans for bad credit <a href=https://paydayloans.us.org/>payday loans online colorado</a>

JoeSok  Dec 15, 2017 
ePub Page viktevuf
USA

bad credit payday loans direct lenders <a href="https://loan.us.org">loan</a> online loans <a href=https://loan.us.org>payday loans online</a>

Spotloan   Dec 15, 2017 
ePub Page wgcyjees
United States

pay to write research paper <a href="https://researchpaper.us.com">research paper</a> website that does your math homework <a href=https://researchpaper.us.com>research papers</a>

Homework For Pre K   Dec 15, 2017 
ePub Page hcrqjhrb
US

help writing essays for college <a href=https://buyessays.us.com>buy essays online</a> buy essay online <a href=https://buyessays.us.com>website for essays</a>

JoeSok  Dec 15, 2017 
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