Workshop Books Navigation BarAboutPartnersE-mail JanetMessage BoardWhere's Janet?TutorialsAboutHomeArticle Archive


* PowerPoint


* Word


* Excel


* Access

* AppleWorks


*Palm™

*
Digital Photography
PowerPoint Trainings

BEGINNING EXCEL

Four Hour Overview
The friendly, low-stress environment of this training encourages 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 with Excel):


Skills Your Teachers Learn...

Tools They'll Create
& Use Later...


Excel Training
  • Worksheet basics
  • AutoSum
  • AutoFill
  • Formulas
  • Functions
  • Formatting cells

OR

  • AutoSum
  • AutoFill
  • Formulas
  • Functions
  • Formatting cells
  • Charts

- Family budget
- Game board
- Multiplication table
- Pizza fundraiser

      OR


- Chart for student enrollment
- Simple attendance sheet
- Gradebook
- Seating chart

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....
  • Worksheet basics
  • AutoSum
  • AutoFill
  • Formulas
  • Functions
  • Formatting cells
  • Charts
  • Worksheets inside Word Processing documents

- Family budget
- Game board
- Multiplication table
- Concession stand inventory
- Pizza fundraiser
- Chart for student enrollment
- Chart for students to use
- Simple attendance sheet
- Gradebook
- Seating chart


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...

Advanced Excel Training
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

Advanced Excel Training
- 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)


Contact Information:

Back to Top
To schedule a training, please contact:

Janet Caughlin
Workshop Books
406 S 216 Street
Elkhorn, NE 68022

Phone: 402-850-7354
E-mail: Janet_Caughlin@mac.com

About
 |  Articles  |  Board  |  E-mail Janet  |  Home
Partners  |  Software Tutorials  |  Training  |  Where's Janet?


Problems or comments about this site? E-mail us. We're here to help!

Copyright © 1999 Janet Caughlin. All Rights Reserved. Legal Notices.
You may not copy, republish, redistribute, participate in the transmission of,
create derivations of, alter, edit or exploit in any manner any material from this Web site,
without the express written permission of Janet Caughlin.