MRS. POOL'S BEARCAT CLASSES
  • 2022-2023
    • Syllabus/Signature Page
    • Photography I >
      • A-Z beginning scavenger hunt
      • Famous Photographers
      • Website Critique
    • 8th Grade Computer Apps
    • 7th Grade Computer Apps
    • Intro to Arts/AV
    • Photography II
  • Classroom Information
  • Extras: Royalty Free Music

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: pdf
Download File

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Proudly powered by Weebly
  • 2022-2023
    • Syllabus/Signature Page
    • Photography I >
      • A-Z beginning scavenger hunt
      • Famous Photographers
      • Website Critique
    • 8th Grade Computer Apps
    • 7th Grade Computer Apps
    • Intro to Arts/AV
    • Photography II
  • Classroom Information
  • Extras: Royalty Free Music