ADVANCED EXCEL
These trainings are geared toward teachers who have mastered Microsoft Excel basics
and are ready to take their productivity to the next level.
Four Hour Overview
The friendly, low-stress environment of this training encourages advanced questions and learning, so participants leave confident in their ability to use Microsoft Excel. Participants will work alone or in pairs on computers. They will receive graphic step-by-step handouts from the book Excel Workshop for Teachers to follow along as lessons are presented or the book will be offered for sale at a discounted price. Choose to have the presentation focus on one of the skill sets listed below (based on participants' experience level with Excel):
|
|
Skills Your Teachers Learn...
|
 |
Tools They'll Create
& Use Later...
|
|
- Sort cells
- Create subtotals
- IF statement functions
- LOOKUP table functions
- Relative cell references
- Intersheet formulas
OR
- Lists
- Charts
- Relative and absolute copy
- Merged letters
- Microsoft Map (Windows users)
- or Inserting movies (Version 2001 only)
|
- Checking account worksheet
- Gradebook that flags low scores
- Gradebook that reads other
gradebooks
- Gradebook that assigns grades
|
OR
|
 |
- Class information list
- Chart for students to use
- Behavior modification tool
- Geography worksheets (Windows only)
or Acceleration worksheet (Version
2001 only)
|
|
|
One-Day Workshop (6 hours)
Participants in this training get to take advantage of the full day workshop format to not only learn key Microsoft Excel skills in a fun, hands-on way, but also create a set of curricular documents and tools they can use later. Participants will work alone or in pairs on computers. They will work from the book Excel Workshop for Teachers, which is required and offered at a discounted price, so they can follow along as lessons are presented. The friendly, low-stress environment of this training encourages questions and learning, so participants leave confident in their ability to use Excel. The topics listed below can be covered in more depth, or you can customize the workshop to cover certain skills in more depth or to cover different topics:
|
|
Skills Your Teachers Learn...
|
Tools They'll Create
& Use Later....
|
|
- Sort cells
- Create subtotals
- IF statement functions
- LOOKUP table functions
- Relative cell references
- Intersheet formulas
- Lists
- Charts
- Relative and absolute copy
- Merged letters
- Microsoft Map (Windows users)
- or Inserting movies (Version 2001 only
|
|
- Checking account worksheet
- Gradebook that flags low scores
- Gradebook that reads other gradebooks
- Gradebook that assigns grades
- Class information list
- Chart for students to use
- Behavior modification tool
- Geography worksheets (Windows only) or Acceleration
worksheet (Version 2001 only)
|
|
|
