Errata

Microsoft Excel 2013: Data Analysis and Business Modeling

Errata for Microsoft Excel 2013: Data Analysis and Business Modeling

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, PDF Page 4
1st paragraph, 1st filename reference

The filename "Statestemp.xlsx" does not correspond to the filename provided in the companion data.

The appropriate companion data is shown as "States.xlsx." The easiest fix is to update the filename in the companion data set.

 Chris Constantin  Feb 04, 2014 
Printed, PDF Page 5
2nd paragraph, 1st line

Instructions for task refers to an inaccurate function. The following updates the error.

CURRENT:
"If you choose Name Manager on the Formulas tab and select Define Name from the menu shown
in Figure 1-6,"

REVISED:
"If you choose Defined Names on the Formulas tab and select Define Name from the menu shown
in Figure 1-6,"

 Chris Constantin  Feb 04, 2014 
Printed, PDF Page 6
1st paragraph, 2nd line

CURRENT:
The book instructs the reader to enter =A2:B7 in the Refers To area.

REVISED:
Should be revised to instruct reader to enter =A2:C7 in order to match Figure 1-9. Additionally, book should indicate the reader make this an absolute cell reference.

 Chris Constantin  Feb 04, 2014 
Printed, PDF Page 7
Last Paragraph, 1st Line

This line references the Historicalinvesttemp.xlsx file while the companion data lists the file as Historicalinvest.xlsx. This is similar to the error with Statestemp.xlsx file name.

File name should be Historicalinvest.xlsx

 Chris Constantin  Feb 06, 2014 
Printed Page 8
1st paragraph, first sentense

The first sentence "Select the B8:B89 cell range and then choose Formulas and Create From Selection."

Should be

"Select the B7:B89 cell range and then choose Formulas and Create From Selection."

If you don't include the header names Stocks, T.Bills, and T.Bonds, the name formula doesn't work as it can't read the names it should reference to. I did exactly in the book a couple of times before I realized I'm missing the another row on top.

 Rowena  Mar 02, 2014 
Printed Page 16-17
Last sentence

The Lookup.xlsx file provided is incorrect. It is a lookup for product price, not tax rate.

 Paula Shubock  Mar 04, 2014