Excel - Intermediate
Last revised: August 17, 2010
| Instructor's Notes | |||
|
Unit 1 - Excel - Beginning Review |
|
Notes covering Excel basics |
|
|
Managing Large Worksheets Unit 2 - Large Worksheet Sample |
|
Notes for how to navigate, hide, outline and print large worksheets. |
|
|
Unit 3 - Multiple Worksheets Kitchen Workbook |
|
Notes covering the use of multiple worksheets and multiple-worksheet formulas. |
|
|
Unit 4 - Charting |
|
Notes on creating and customizing charts. |
|
|
Unit 5 - Data Tables Faculty Workbook |
|
Notes on using Excel as a database, including sorting, filtering, and subtotals. |
|
|
Unit 6 - Advanced Functions Adv Functions Workbook |
|
Notes covering advanced Excel functions. |
| Recorded Lectures | |||
|
|
No recorded lectures available at this time. | ||
| Assignments | |||
|
|
Unit 1 - Review Assignment Spreadsheets for this assignment "Fresh" Workbook |
|
Basic Excel Review |
|
|
Unit 3 - Multiple Worksheets Assignment Spreadsheets for this assignment OR Workbook InBurger Workbook Copiers Workbook Bakery Region 1 Workbook |
|
Managing and creating formulas across multile worksheets |
|
|
Unit 4 - Charting Assignment Spreadsheets for this assignment Mitchell Workbook |
|
Creating Charts using Excel data |
|
|
Unit 5 - Data Tables Assignment Spreadsheets for this assignment Office Workbook Teahouse Workbook Bowls Workbook |
|
Using data tables to sort, filter and create statistics |
|
|
Unit 6 - Advanced Functions Assignment Spreadsheets for this assignment Modem Workbook |
|
Using advanced functions |
| Handouts & Data Files | |||
|
|
Student Files
How to Download Student Files |
|
Data files for all four tutorials, stored in a self-extracting zip file. Copy this file to your computer. Then, double-click the file and tell the extractor where to store your files. |
