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 | |
File Size: | 415 kb |
File Type: |

e4-d1-payrolltemplate.xltx | |
File Size: | 9 kb |
File Type: | xltx |

e4-d2-payrollperiod17data.csv | |
File Size: | 2 kb |
File Type: | csv |

e4-d6-payroll.xlsx | |
File Size: | 11 kb |
File Type: | xlsx |

e4-r1-donordata.csv | |
File Size: | 2 kb |
File Type: | csv |

e4-r1-donorlist.xltx | |
File Size: | 9 kb |
File Type: | xltx |

e4-r3-studentdata.csv | |
File Size: | 0 kb |
File Type: | csv |

e4-r3-studenthours.xlsx | |
File Size: | 8 kb |
File Type: | xlsx |

e4-a1-expdata.csv | |
File Size: | 1 kb |
File Type: | csv |

e4-a1-expenses.xltx | |
File Size: | 9 kb |
File Type: | xltx |

e4-a3-fbdata.csv | |
File Size: | 1 kb |
File Type: | csv |

e4-a3-feedback.xlsx | |
File Size: | 9 kb |
File Type: | xlsx |

e4-e1-gradesdata.csv | |
File Size: | 2 kb |
File Type: | csv |

e4-e2-clientdata.csv | |
File Size: | 2 kb |
File Type: | csv |

e4-e2-clienthours.xltx | |
File Size: | 8 kb |
File Type: | xltx |

e4-e3-kitsupplies.csv | |
File Size: | 1 kb |
File Type: | csv |

mozart-k525.mp3 | |
File Size: | 607 kb |
File Type: | mp3 |

video.wmv | |
File Size: | 11649 kb |
File Type: | wmv |

may_scores.txt | |
File Size: | 0 kb |
File Type: | txt |