Indiana University Bloomington
K200 - Microcomputer Applications in Kinesiology - School of Public Health-Bloomington

Home

Syllabus

Calendar

All Project Due Dates

Class Resources

Google at IU

OneDrive

IUanyWare
(Use Mozilla Firefox)

Email Ms. Lion

Email Mr. Furman

Find K200 on

Twitter

Facebook

Pinterest Tech Board

IU School of Public Health-Bloomington icon

K200

Week 6 - Excel

Topics & Projects

Microsoft Excel 2016 logo

Objectives:

  1. Create and enter data into worksheets
  2. Construct basic functions and formulas
  3. Apply cell formatting
  4. Adjust settings and review worksheets for printing
  5. Construct statistical functions
  6. Generate formulas using absolute cell references
  7. Apply cell and number formatting
  8. Create, edit, and format basic charts
  9. Modify workbook print settings
  10. Revise cell contents
  11. Reorganize and edit worksheet tabs
  12. Combine and edit data in grouped worksheets
  13. Construct multiple operator and summary formulas
  14. Design clustered bar charts
  15. Construct date and time functions
  16. Apply logical conditions and formats to data
  17. Modify worksheet formatting
  18. Distinguish data using cell charts and filters
  19. Understand large worksheet print options

Topic Covered in Week 6 - Excel:

  • Before You Begin - Week 6 - Excel
  • Projects - Week 6 - Excel
    • Microsoft Excel | Introduction to Excel Chapter 1 | Create Workbooks with Excel 2019
    • Microsoft Excel Chapter 2 | Insert Summary Functions and Create Charts
  • Extra Credit - In Class Savers-Excel

Together We Will Do:

  • First Excel - In Class Saver

Projects Due:

Go to Week 6 - Excel to see complete list.

 

Further Resources:

Projects Due for Week 6: Check All Project Due Dates.

Weekly Projects:

  • Chapter 1: Create Workbooks with Excel 2019
  • Chapter 2: Insert Summary Functions and Create Chart

This image was created by Trevor Liechty - The End of Excel. Type the cell name you see in the Name Box to get to the end of Excel.

Further Study:

Excel: