technology • training • team building

             

Microsoft Excel Training

All modules assume an average understanding of the Windows environment.  Each module lasts the time noted.  You can put modules together to fill the time you have allotted.

Each session may be delivered either lecture style or in a computer class-room.  If you do not have a computer classroom in your office, one is available to rent in downtown Phoenix.

During your free needs analysis, we will work together to plan a strategy that fits your Excel training needs.  Please contact us. 

Click on the topic below to link to a short description of the topic:

The Excel Environment (1 hour)

Working with Calculations (1 hour)

Increasing Workbook Efficiency (2 hours)

List Management (2 hours)

Linking Data (2 hours)

Charting (2 hours)

Increasing Workbook Accuracy (1 hour)

The Excel Environment (1 hour)

Navigating and Selecting

Entering Text, Number, and Date Data

Editing Techniques

Sheet Tab Concepts

To the Top

Working with Calculations (1 hour)

Simple Formulas

Functions

AutoSum

Autocalculate

To the Top

Increasing Workbook Efficiency (2 hours)

Copying

Autofill

Absolute vs. Relative Cell References

If Statements

To the Top

List Management (2 hours)

Database Tools in Excel

Sorting

Filtering

To the Top

Linking Data (2 hours)

Linking Data within Excel

Linking Excel Data to Word and PowerPoint

To the Top

Charting (2 hours)

Understanding the Charting Process

What the Different Charts Communicate

Using Worksheet Data for a Chart

Modifying the Chart and Chart Elements

To the Top

Increasing Workbook Accuracy (1 hour)

Error Tracking

Protecting Your Data

Possible Class Topics