MODULE 04
Files as evidence: CSV and Excel
6 submodules. Work through them in order; each one includes guided practice.
4.1Read and inspect a CSV
- See the CSV behind the table
- Find and inspect a CSV file
4.2Preserve identifiers and reconcile the import
- Preserve identifiers during import
- Validate the imported population
- Optional: compare the csv module after core practice
4.3Write and reopen the selected workpaper
- Write and reopen the review CSV
- Complete the connected task after the Excel lessons
4.4Choose the intended workbook sheet
- Choose the Excel sheet before reading
- Read and inspect the workbook tables
4.5Distinguish formulas, stored results and display
- Find headers and separate report totals
- Distinguish formulas, cached results and display
4.6Write an inspectable workbook
- Write and reopen a three-sheet workpaper
- Add a formula and readable number formats