Chapter 4: Organizing Large Amounts of Data
In this chapter, you will learn about managing large amounts of data and how to utilize different sources of data. You will learn some of the more advanced Excel tools used for organizing data, performing calculations, and restricting data entry.
Learning Objectives
- Start a workbook from a template
- Import and Export data
- Change worksheet view options
- Sort and filter data
- Create IF functions
- Apply data validation rules
- Use the Scale to Fit options
- Create and modify tables
Documents
| ex16-c04-ppt.pdf |
| e4-d1-payrolltemplate.xltx |
| e4-d2-payrollperiod17data.csv |
| e4-d6-payroll.xlsx |
| e4-r1-donordata.csv |
| e4-r1-donorlist.xltx |
| e4-r3-studentdata.csv |
| e4-r3-studenthours.xlsx |
| e4-a1-expdata.csv |
| e4-a1-expenses.xltx |
| e4-a3-fbdata.csv |
| e4-a3-feedback.xlsx |
| e4-e1-gradesdata.csv |
| e4-e2-clientdata.csv |
| e4-e2-clienthours.xltx |
| e4-e3-kitsupplies.csv |
| mozart-k525.mp3 |
| video.wmv |
| may_scores.txt |