LOGIN
username   password   
Welcome
Excel:Beyond the Basics
Overview

Excel for Quality Improvment: Beyond the Basics
      
A hands-on Excel class designed to further quality improvement efforts.  

           computers

Going beyond the basics in Excel,
this full day of training will enhance participants' 
data analysis skills and data display techniques










Prerequisites:

• Completion of "Excel for Quality Improvement: Basics for Beginners"
• In absence of completion of the above-mentioned course, participants should have a working knowledge of Excel, with the ability to navigate, filter/format/sort, insert simple functions (e.g. MEAN, SUM), and graph data

Learning Objectives:
1. Datasheet design/tips, including the use of pull down options and data validation
2. How to analyze and display data using Pivot tables and graphs with auto filters
3. Use functions/formulas beyond averages, e.g., IF, MIN, MAX, STDEV, ROUND
4. Understand how Excel handles time

Date: September 16, 2010
Time: 9:00 am - 3:30 pm
Lunch will be provided.

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

 

Agenda

9:00 am Welcome and Review

9:15 am  Formulas Beyond the Basics
- MIN/MAX
- MEDIAN
- STDDEV
- GEOMEAN
- FREQUENCY
- CONFIDENCE
- ROUND
- IF

10:30 am Data Collection Form -Design tips
- Pull-down option menus
- Data validation
- Simple macro

11:15 am Aggregating and Analyzing Data
- Pivot Tables

12:15 pm LUNCH

1:00 pm Displaying Data
- Adding auto-filters to graphs

2:00 pm Time
- Basic functions with time

3:15 pm Q & A

3:30 pm Adjourn

 

Event Details
Event Type

OTHER

Credits

6

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

 

Materials

 

 

Upcoming Events
1 Compass West - Sept 2010, 09/09/2010
The Oakland Conference Center
1 Excel:Beyond the Basics, 09/16/2010
Unitek Computer Training Center
1 Excel: Basics for Beginners , 10/05/2010
Unitek Computer Training Center
Calendar of Events
« September 2010 »
SuMoTuWeThFrSa
 234
56781011
121314151718
19202122232425
2627282930 
Documents and Resources

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

Keywords:
Initiative:
Topics:
File Type: