Microsoft Excel for Program Administrators [BOS]

Click on the register button to sign up for this event.

Click on the print icon to see a printer-friendly view of this event.

Overview

For Program Administrators to learn MS Excel for generating spreadsheets and charts.

Details

This developed 3 hour workshop is meant especially for program coordinators/ administrators who want to get a handle on how the Microsoft Office program Excel can help in one's daily work. Excel is a spreadsheet program which can organize text and numeric data in ways that a plain word processor cannot. This basic level course will explain how the program works, how to set up simple calculation formulas, how to create tables for arranging data in ways that are useful, how to create simple graphs and charts and also offer some sample spreadsheets with practical tips that you can put to use right away in your program. We also will go over how to export data from SMARTT/COGNOS into Excel so you can view your data in a variety of ways, and how to edit your budget worksheets for program planning.

When

March 27, 2008 from 01:00 pm to 04:00 pm

Where

• 100 Morrissey Blvd., Boston, MA 02125 Wheatley 4th Floor, Room 167
• University of Massachusetts, Boston, MA 02125

Click for map and directions

Registration Deadline

Mar 13, 2008 at 4:00 PM

Topics

SMARTT, Technology, Trainings for Directors

Multi-session attendance required

no

Contact info

Akira Kamiya
akira.kamiya@umb.edu
617 287-4070

Indicators of Program Quality

IPQ7 - Program leadership, management, and accountability

Learning objectives

By the conclusion of the training, participants will be able to ... 1. Create, and add formatting of cells for multiple data types in basic EXCEL spreadsheets. 2. Develop basic formulas, (such as addition, multiplication, division) within EXCEL that meet the needs of ABE program administrators and be able to locate help in Excel for more complex formulas. 3. Locate existing reports from SMARTT / COGNOS, import these reports to EXCEL and add basic formatting, sorting, inserting columns or rows, etc. 4. Locate relevant DOE budget documents on the web (such as Budget Detail Pages. Request for Funds Form, Amendment Form, etc.) and save and edit these files. 5. Identify sources for EXCEL templates to assist in program administration.

Presenters

Esther Leonelli
Akira Kamiya

Presenters Bio

The workshop will be co-presented by Esther Leonelli, former Coordinator of Notre Dame Education Center and Akira Kamiya, Computer Technologist for ALRI, Greater Boston area SABES

Prerequisites

Be involved in ABE Program Administration

Host RSC

Boston Region

PDPs

no