Volkers Web Site

Excel 2013 - Intermediate
Last revised: August 2, 2014

Syllabus

Instructor's Notes & Videos  
Unit 1 - Excel - Beginning Review
Unit 1 YouTube Videos
Notes covering Excel basics
Unit 2 - Charting
Unit 2 YouTube Videos
Notes on creating and customizing charts.
Unit 3 - Data Tables
Unit 3 YouTube Videos
Notes on using Excel as a database, including sorting, filtering, and subtotals.
Unit 4 - Multiple Worksheets
Unit 4 YouTube Videos
Notes covering the use of multiple worksheets and multiple-worksheet formulas.
Unit 5 - Advanced Functions
Unit 5 YouTube Videos
Notes covering advanced Excel functions.

Assignments  
Unit 1 - Review Assignment Basic Excel Review
Unit 2 - Charting Assignment Creating Charts using Excel data
Unit 3 - Data Tables Assignment  Using data tables to sort, filter and create statistics
Unit 4 - Multiple Worksheets Assignment  Managing and creating formulas across multile worksheets
Unit 5 - Advanced Functions Assignment Using advanced functions

Handouts & Data Files  
Student Files Data files for all six units, stored in zip files.
How to Download Student Files How to download and extract (unzip) student files.
How to Compress Assignment Files How to use Windows to compress multiple assignment files into one Zip file.

 
MSTC Stevens Point