- As of May 18, 2016, all URLs in the text have been checked and updated as necessary, comprising about two dozen changes in the text. Accordingly, some Learning Activities have been changed to reflect the new URLs.
- All existing and new eTextbooks from Redshelf and VitalSource will reflect these changes, as will all new paperbacks printed after June 20, 2016.
- For those with paperbacks printed before June 20, 2016, click HERE for the complete list of changes.
Appendix F: Excel Fundamentals.
To download spreadsheet files referenced in Appendix F, scroll down to the SPREADSHEET DOWNLOADS section further down this page.
Excel Fundamentals Videos
- XL01 Interface (10:11)
- XL02 Navigation (3:32)
- XL03 Rows Columns Ranges (7:09)
- XL04 Text Numeric Data Dates (9:06)
- XL05 Basic Data And Formula (8:41)
- XL06 Cut Copy Paste (6:53)
Editing and Formatting Worksheets Videos
Functions and Formulas Videos
- XL09 Formulas Functions Overview (8:08)
- XL10 Cell References Absolute Relative (6:26)
- XL11 Insert Function Wizard (5:57)
- XL12 Functions Examples (5:43)
Appendices A – K are available in an ePub file, updated with changes for Edition 2.1. Click here to download: Appendices
To view ePub files, you may use one of the following:
- Adobe Digital Editions. Click here for download: adobe.com
- Readium, which is Google Chrome browser extension. Click here for download: readium.org
- iBooks on an iPad. Click here for info: iBooks
These spreadsheet files are referenced in the Additional Learning Activities (ALAs) for Chapter 6 (page 115 of the text). Click on the file name to download.
These spreadsheet files are referenced in the Additional Learning Activities (ALAs) for Appendix F. Click on the file name to download.
- ExcelFundamentals_Activity_Coffee.xlsx (ALA 1)
- ExcelFundamentals_Activity_Coffee_MultiYear.xlsx (ALA 2)
- ExcelFundamentals_Activity_ProductQuantitySold_Trend.xlsx (ALA 3)
- ExcelFundamentals_Activity_ProductSalesEstimates.xlsx (ALA 4)
- ExcelFundamentals_Activity_EmployeeOverhead.xlsx (ALA 5)
These spreadsheets are referenced within Appendix G. Click on the file name to download.
These spreadsheet files are referenced in the Learning Activities (LAs) at the end of Appendix G. Click on the file name to download.