MRS. POOL'S BEARCAT CLASSES
  • 2021-2022
    • Syllabus/Classroom Forms
    • Multimedia
    • Digital Production
    • 8th Grade Computer Apps >
      • You're Hired!
      • Photoshop >
        • Green Screen
        • Create your own Magazine Cover
        • Layer Basics
        • Selection Tools: Melon Head
      • Media/Technology Career Presentation
      • Travel Agent Project
      • Microsoft Comprehensive Project
      • Intro to Computers Notes
    • 7th Grade Computer Apps >
      • State Project
      • Spring MS Excel
      • Spring MS Word
      • Location/Destination PPT
      • MS Word Projects
      • MS Word Formatting
      • Intro to Computers Notes
  • 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
  • 2021-2022
    • Syllabus/Classroom Forms
    • Multimedia
    • Digital Production
    • 8th Grade Computer Apps >
      • You're Hired!
      • Photoshop >
        • Green Screen
        • Create your own Magazine Cover
        • Layer Basics
        • Selection Tools: Melon Head
      • Media/Technology Career Presentation
      • Travel Agent Project
      • Microsoft Comprehensive Project
      • Intro to Computers Notes
    • 7th Grade Computer Apps >
      • State Project
      • Spring MS Excel
      • Spring MS Word
      • Location/Destination PPT
      • MS Word Projects
      • MS Word Formatting
      • Intro to Computers Notes
  • Classroom Information
  • Extras: Royalty Free Music