Excel: Introduction to Spreadsheets
   

We offer both beginner and intermediate skill levels.  Here are some examples of the topics offered in our Excel Training Workshops..

Beginner Excel Skills:
Recommended Time: 4 hour block

Identify the components of Excel
Working with Workbooks and Worksheets
Entering Data and Editing
Creating Simple Formulas
Formatting Cells
Using Simple Functions: Max, Min, Average, Dates and Times

Intermediate Excel Skills:
Recommended Time: 4-6 hour block

Rotating text- using fill handles
Increase column widths
Copying a range of cells to a none adjacent area
Using drag & drop to move on copy cells
Inserting rows/columns
Entering numbers with a format symbol
Freezing worksheet titles
Absolute versus relative addressing
Using the Functions: Max, Min, If, Lookup, Loan Amortization
Conditional formatting
Copying formulas using drag/fill handle
Formatting: numbers, fonts
Use background colors
3-d pie chart
Changing colors in chart
Goal seeking
Analyzing
Validation: Adding Drop Down boxes to spreadsheets
Macros

Intermediate Excel Skills: Using Excel as a Database:
Recommended Time: 2 hour block

Creating a simple database using an excel spreadsheet
Learning to Use Filters and Sorting
Text to Columns
Data Tracking using the template Wizard