Excel 2010 - Intermediate
Last revised: August 19, 2011
| Instructor's Notes | |||
|
Unit 1 - Excel - Beginning Review |
|
Notes covering Excel basics |
|
|
Unit 2 - Managing Large Worksheets 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 | |||
|
|
Unit 5 - Data Tables | ||
Part 1
|
How to define subtotals for a range of data | ||
|
|
Unit 6 - Advanced Functions | ||
|
Part 1
|
VLOOKUP function; How to use the IF function to hide errors caused by missing data | ||
| Assignments | |||
|
|
Unit 1 - Review Assignment |
|
Basic Excel Review |
|
|
Unit 2 - Managing Large Worksheets |
|
No assignment for this unit. Reading only. |
|
|
Unit 3 - Multiple Worksheets Assignment |
|
Managing and creating formulas across multile worksheets |
|
|
Unit 4 - Charting Assignment |
|
Creating Charts using Excel data |
|
|
Unit 5 - Data Tables Assignment |
|
Using data tables to sort, filter and create statistics |
|
|
Unit 6 - Advanced Functions Assignment |
|
Using advanced functions |
| Handouts & Data Files | |||
|
|
Student Files
How to Download Student Files |
|
Data files for all four tutorials, stored in zip files. How to download and extract (unzip) student files. |
