Class is full - Please register for the September class.
A hands-on Excel class designed to further quality improvement efforts. 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: June 17, 2010
Time: 9:00 am - 3:30 pm
Lunch will be provided.
Fee: $95 for all participants
Refund Policy: Registration fee will be refunded (minus a processing fee) up to June 11, 2010
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
OTHER
Search the Beacon Library for best practices, insights and the latest materials