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
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
OTHER
Search the Beacon Library for best practices, insights and the latest materials