Excel 2010 - Beginning
Last revised: July 28, 2011
| 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 | |||
|
|
Unit 1: Spreadsheet Concepts | ||
Part 1
|
Spreadsheet concepts; Rows, columns and cells; Moving the active cell; Selecting cells | ||
|
Part 2
|
Entering labels; Entering numeric data; Entering dates and times; Entering formulas | ||
|
Part 3
|
Entering formulas; Using functions; Copying formulas; Inserting and deleting rows/columns; Moving cells; Printing | ||
|
|
Unit 2: Formatting a Spreadsheet | ||
|
Part 1
|
Themes; Fonts; Text color; Background color; Text alignment; Number formatting; Date formatting; Merging and centering; Cell borders; Sheet background image | ||
|
Part 2
|
Quick styles; Table styles; Conditional formatting; Hiding rows and columns; Print area; Repeating rows/cols on every page (print titles) | ||
|
Part 3
|
Print titles; Headers & Footers; Manual page breaks; Scaling a page to fit | ||
|
|
Unit 3: Formulas and Functions | ||
|
Part 1
|
Absolute vs. relative references; Functions and arguments (concepts); Today function | ||
|
Part 2
|
IF function; PMT function; Absolute vs. mixed references; AutoFill | ||
| 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 zip files. How to download and extract (unzip) student files. |
