Excel Course


There is an Excel file that you can download at this site that contains some example sheets of some of the basic functionality of Microsoft Excel. The topics are listed below. Not all topics are complete as this is a work in progress but most of them are. The first sheet contains this Table of Contents with links to a sheet that illustrates the topic. You can download the file and use it as you wish. ExcelCourse.xlsm

Data Overview
Data
Workbooks
Worksheets
EnteringData
Naming
DataValidation
Outlining1
Outlining2
Freeze Panes
CustomViews
Format ConditionalFormat
Formulas Formulas1
Formulas2
Functions Functions1
Vlookup
Strings
RowToCol
IF
ArrayFunctions
Subtotal1
Subtotal2
Lists SortFilter
DuplicatesCOUNTIF()