LOGIN
username   password   
Welcome
Excel: Basics for Beginners - October 5, 2010
Overview

Did you ever want to learn how to create charts in Excel, or learn how to link spreadsheets? Well now is your opportunity to learn how to use Excel to report on your data in a comfortable environment. Join us for a full day of Excel training at the Unitek Computer Education Center in Fremont. You will learn how to design a data collection tool, insert formulas, aggregate and analyze performance improvement data as well as review the basics of navigating around a spreadsheet. Class size is limited so we encourage you to sign up early.

 

 

The class will meet from 9 am - 3:30 pm. Registration and coffee begins at 8:30 am. Lunch will be provided.

Registration fee is $95 for all class participants.
Registration fee includes a full day of programming, lunch and CEUs.

Refund Policy: Cancellation must be received in writing prior to September 28, 2010 to qualify for a refund minus a processing fee of $15.00.

Class Objectives:
Understand how to navigate around an Excel spreadsheet
Know how to insert a formula
Design a data collection tool
Understand how to aggregate and analyze performance improvement data
Learn how to format

Agenda

9:00 am Welcome & Review
- Goals for the day (Participants' perspective)

9:10 am
Open a spreadsheet
- Excel coordinates
- Columns, rows, and cells
- Tabs, naming
- Worksheet
- Navigation
- Copying

10:10 am Basic Formulas
- SUM
- AVERAGE
- %
- COUNTIF
- = What you want to do (location, location)

11:20 am Design a Data Collection Form - Aggregating and Analyzing Data
- MR#, DR#, date, indicator 1, indicator 2, indicator 3 - Y/N/NA
- Sizing columns and rows
- Formatting
- Sorting & Filtering

12:15 pm LUNCH

1:00 pm Graphing your data
- Grabbing Data
- Graphing wizard
- Copy & Paste
Make formatting changes

3:15 pm Q & A

3:30 pm Adjourn

Event Details
Event Type

OTHER

Credits

When and Where
Date:
10/05/2010
Starts:
09:00
Location:
Unitek Computer Training Center
Address:
4670 Auto Mall Parkway Fremont, CA 94538
Parking:
Free parking on site.
Initiatives Covered

 

Materials

 

 

Upcoming Events

 

Documents and Resources

Search the Beacon Library for best practices, insights and the latest materials

Keywords:
Initiative:
Topics:
File Type: