K200 - Microcomputer Applications in Kinesiology

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)

Find K200 on

K200

Week 7 - Excel

Topics & Projects

Microsoft Excel 2016 logo

Objectives:

Create and enter data into worksheets
Construct basic functions and formulas
Apply cell formatting
Adjust settings and review worksheets for printing
Construct statistical functions
Generate formulas using absolute cell references
Apply cell and number formatting
Create, edit, and format basic charts
Modify workbook print settings
Revise cell contents
Reorganize and edit worksheet tabs
Combine and edit data in grouped worksheets
Construct multiple operator and summary formulas
Design clustered bar charts
Construct date and time functions
Apply logical conditions and formats to data
Modify worksheet formatting
Distinguish data using cell charts and filters
Understand large worksheet print options

Topic Covered in Week 7 - Excel:

Before You Begin - Week 7 - Excel
Projects - Week 7 - Excel
- Microsoft Excel Chapter 3 | Manage Multiple Worksheets
- Microsoft Excel Chapter 4 | More Functions and Excel Tables
- Major Project #2 - Excel
Extra Credit - In Class Savers-Excel Copy

Together We Will Do:

PMT in Excel - In Class Saver
Cover Major Project #2 - Excel

Projects Due:

Go to Week 7 - Excel to see complete list.

Woman celebrating her victory using a computer.

Bit of Humor:

Computer safety feature: The Airbag

Grumpy Cat and Excel

Spreadsheet is a sudoku.

IT giving you a black I.

Further Resources:

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

Weekly Projects:

Chapter 3: Managing Multiple Worksheets

Chapter 4: More Functions and Excel Tables

Major Project:

Major Project #2 - Excel

Further Study:

Excel: