Excel - Beginning
Last revised: August 17, 2010
| Instructor's Notes | |||
|
Tutorial 1 - Excel Basics |
|
Instructor's notes for Tutorial 1 |
|
|
Tutorial 2 - Formatting a Worksheet |
|
Instructor's notes for Tutorial 2 |
|
|
Tutorial 3 - Formulas & Functions |
|
Instructor's notes for Tutorial 3 |
|
|
Tutorial 4 - Creating Charts |
|
Instructor's notes for Tutorial 4 |
| Recorded Lectures | |||
|
|
Tutorial 1 - Spreadsheet Concepts | ||
Part 1
|
Concepts, Adding labels | ||
|
Part 2
|
Entering numbers, dates and times, entering formulas, copying formulas, using common functions | ||
|
Part 3
|
Review, copying formulas, resizing rows/columns, inserting/deleting rows/columns, moving cells, spell checking | ||
|
|
Tutorial 2 - Formatting a Worksheet | ||
|
Part 1
|
Themes, formatting labels, formatting numbers and dates, custom formats, cell alignment, cell borders | ||
|
Part 2
|
Background images, styles, format painter, table styles, conditional formatting, data bars | ||
|
Part 3
|
Conditional formatting, data bars, hiding rows and columns, headers/footers, controlling page breaks, controlling page titles, shrinking to fit | ||
|
|
Tutorial 3 - Formulas & Functions | ||
|
Part 1
|
Absolute references, functions | ||
|
Part 2
|
IF function, PMT function, fill | ||
| Assignments | |||
|
|
Tutorial 1 Assignment |
|
Assignment sheet for Tutorial 1 |
|
|
Tutorial 2 Assignment |
|
Assignment sheet for Tutorial 2 |
|
|
Tutorial 3 Assignment |
|
Assignment sheet for Tutorial 3 |
|
|
Tutorial 4 Assignment |
|
Assignment sheet for Tutorial 4 |
| Handouts & Data Files | |||
|
|
Competency Checklist |
|
List of competencies (skills) gained in this course, presented by tutorials |
|
|
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. |
