I have developed and used this courseware for over 25 years to teach Excel Intermediate to over 2, 000 students. It is intended to be used as a student workbook only as part of an instructor controlled lecture.
The material is to be used in an "8 to 12" hour intermediate course in Microsoft Excel.
The courseware covers the following topics:
The Excel Interface Overview
Using the Flash Fill Feature
Protecting Your Work
Automating Your Work
Working with Range and Cell Names
Sorting a Database
Filtering Data in a List
Introduction to IF( ) Functions
Nesting IF( ) Functions
Creating Formulas between Sheets in a Multi-Sheet File
Creating Links between Different Workbook Files
Using the Data Validation Feature
Tracking Changes to a Workbook
Introduction to Visual Basic for Applications (VBA)
Creating VBA Macros using the Macro Recorder
Multiple digital workbook files accompany this courseware.
Reasonable cost "site licensing" available for student workbooks.
I also have Excel Basic, Excel Advanced and Visual Basic for Applications courseware available.