Volkers Web Site

Disclaimer: This website was last updated in January 2016--MATERIAL MAY BE DATED.

Excel 2013 - Intermediate
Last revised: August 2, 2014


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.

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