Making Excel Work for You!

Organize Info, Manage Lists, Analyze Data!

3 Sessions - Come to One Session or All!

Each session will explore practical applications of MS Excel for teachers. You will learn how to save time by using spreadsheets to better organize information; summarize and analyze data with a few simple clicks (student info, PASS, etc); represent data visually (great for PAS-T); and more!

Flexible session formats will accommodate all interests and skill levels.

Excel 1: Getting Started - Thursday, April 3, 3:45-5:00

If you do not use Excel at all, this session will help you feel comfortable with some spreadsheet basics. When you leave, you will know how to

  • create a spreadsheet and import class rosters (use for attendance lists, homework checks, field trip lists, locker combinations, form returns, behavior tracking, etc.)

  • edit and format cells

  • set row heights and column widths

  • format page and print settings

Excel 2: Summarizing & Analyzing Data I - Thursday, April 24, 3:45-5:00

Once you are using Excel spreadsheets, you will want to use its capabilities to summarize and analyze data. This is very useful for analyzing MAP and PASS data as well as any other information that you maintain for classes, such as field trip lists, form/information collection, etc. In this session we will work with

  • functions and formulas

  • sorting and filtering data

  • creating charts and graphs in Excel

Excel 3: Summarizing & Analyzing Data II - Thursday, May 15, 3:45-5:00

This session will continue to work with Summarizing and Analyzing Data (from Session 2) and will extend to using the VLOOKUP function and pivot tables.

If there is something specific you want to learn in Excel, please use the form link below to let me know.