Please note that all of the files below should be used in conjunction with the textbook chapter narratives and contexts. All data files have corresponding information, steps, screenshots, tips, and more in the chapters they are embedded in. Each data file has its sources noted in either the textbook narrative or the file itself.

Chapter
Data Files
1. Fundamental Skills
Chapter 1 Practice

2. Formulas, Functions, Cell References
Chapter 2 Data file: Personal Budget

3. More on Formulas, Logical and Lookup Functions
Chapter 3 Data file
Chapter 3 Practice

4. Presenting Data with Charts
Chapter 4 Data file
Chapter 4 Practice: Crude Oil Imports

5. Excel Tables
Chapter 5 Data file: Weather Data
Chapter 5 Practice 1: YouTube Data
Chapter 5 Practice 2: Tourism Data
Chapter 5 Practice 3: Airfare Data
Chapter 5 Practice 4: Audible Data
6. PivotTables & PivotCharts
Chapter 6 Data file: U.S. Dept. of Education
Chapter 6.1: CollegeScoreCard Data
Chapter 6.1: CollegeScoreCard Data Dictionary
Chapter 6.5.A: Practice 1: EIA Imports Data
Chapter 6.5.A: Practice 1: EIA Data Dictionary
Chapter 6.5.B: Practice 2: CFBP Complaint Data
Chapter 6.5.C: Practice 3:CMS Healthcare Data
Chapter 6.5.D: Practice 4: Taxpayer Returns Data Analysis
Chapter 6.5: Fashion Data Practice
7. Multiple Sheet Files
Chapter 7 Data file: Budgeting
Chapter 7 Practice: Sports Data

8. Advanced Logic & Conditional Functions
Chapter 8 Data file: U.S. Dept. of Education, Revisited

Chapter 8: CollegeScoreCard Data, Revisited
Chapter 8 Practice: U.S. Dept. of Transportation

9. Functions for Personal Finance
Chapter 2 Data file: Personal Budget, Revisited
Chapter 9 Practice: Lawn Care Business Data

10. Integrating Microsoft Office Suite Applications
Chapter 10 Data file: Miscellaneous Data

 

 

 

 

Additional data sets:

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Business Computer Information Systems Copyright © 2020 by Emese Felvegi; Barbara Lave; Diane Shingledecker; Julie Romey; Noreen Brown; Mary Schatz; OpenStax; Saylor Academy; University of Minnesota Libraries; and Robert McCarn is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.