Recorded Workshops: Microsoft Excel

Introduction to Excel
Duration 1:50
Date: 6/1/09
LOGIN

In this workshop, participants will learn the basics of using Microsoft Excel versions 2003 and 2007. Together we will create a basic schedule and explore other classroom uses of the software. This workshop will cover an overview of Excel, navigating the workspace, entering and formatting text, using Autofill, working with columns and rows, and printing and saving files. This class is designed for teachers who have not used Excel before.

Introduction to Excel 2003 or 2007
Duration 1:56
Date: 3/9/09
LOGIN

In this workshop, participants will learn the basics of using Microsoft Excel versions 2003 and 2007. Together we will create a basic schedule and explore other classroom uses of the software. This workshop will cover an overview of Excel, navigating the workspace, entering and formatting text, using Autofill, working with columns and rows, and printing and saving files. This class is designed for teachers who have not used Excel before.

Introduction to Office 2007
Duration 1:58
Date: 12/2/08
LOGIN

This class provides an overview of the new version of Office 2007 - Word, Powerpoint, and Excel. It will highlight the major changes from previous versions and show new features of this suite of programs.

Duration 1:39:27
Date: 10/15/07
LOGIN

Excel spreadsheets and worksheets allow teachers and students organize data, track progress and do calculations. Learn how to create a basic spreadsheet, use auto-fill, and organize cells with boarders, shading, and formatting. Class will also cover how to set the print area and use headers and footers for making it all look great in print. Participants will be given a follow up assignment due via email one week after the class date. Participants who complete the assignment on time will receive verification for 3 hours of staff development. Check with your district to see if professional growth hours are available for participation in CTAP live online classes.

Using Excel as a Gradebook
Duration 1:56:58
Date: 4/24/07
LOGIN

In this class, you will learn how to use Excel to create a gradebook for your class. Beginning skills in Excel for formatting cells will be explained along with how to use formulas to total assignment points, and average the students grades. Class will be demonstrated on a PC, but Mac users are welcome.

Creating Charts in Excel
Duration 1:36:31
Date: 11/20/06
LOGIN

In this workshop, participants will learn the basics of using the chart wizard in Microsoft Excel to create a pie chart and a bar chart. This workshop will cover an overview of Excel, entering and formatting text, using Autofill, working with columns and rows, using AutoSum, and printing and saving charts. Ideas of how to use charts with your students will be shared. This class is designed for teachers who have limited experience with Excel.

="_blank" href="http://breeze.scoe.net/p93329144/">Excel for Beginners or "Excel, that's scary!
Duration 1:48:59
Date: 3/9/06
LOGIN

The class will take participants through the basic functions of the MS Excel application. Participants will learn how to use Excel's formulas to create several different spreadsheets that will automate mathematical computations. Prospective teachers who do not already understand Excel's basic formulas and how to use them are the focus of this class. Additional time may also be filled with examples of how Excel can be used in the classroom by instructors and students.

Looking Good in Excel
Duration 1:42:08
Date: 2/20/06
LOGIN

This workshop will cover Excel basics such as navigation, auto-fill, borders and shading, formatting, centering text across rows, Headers and Footers and making it all look good in print. We will cover these skills by making a weekly schedule or monthly calender... Follow up assignment is to create your own calender or schedule and submit no later than Wednesday, December 27, 2006, by 5:30 PM. This class will be taught on a MAC and is open to both MAC and PC users.

Using Formulas in an Electronic Gradebook with Excel
Duration
Date: 2/15/06
LOGIN

This workshop will cover an overview of Excel, special cell formatting, using relative and absolute formulas, Autofill, saving as a template, and using the gradebook. This class is designed for teachers who have experience with Excel.

Creating Charts in Excel
Duration 1:55:53
Date: 1/31/06
LOGIN

In this workshop, participants will learn the basics of using the chart wizard in Microsoft Excel to create a pie chart and a bar chart. This workshop will cover an overview of Excel, entering and formatting text, using Autofill, working with columns and rows, using AutoSum, and printing and saving charts. Ideas of how to use charts with your students will be shared. This class is designed for teachers who have limited experience with Excel.

Creating a Schedule in Excel
Duration 1:52:14
Date: 1/11/06
LOGIN

In this workshop, participants will learn the basics of using Microsoft Excel while creating a basic schedule. This workshop will cover an overview of Excel, navigating the workspace, entering and formatting text, using Autofill, working with columns and rows, adding gridlines, and printing and saving files. Thanks, CTAP Region 3