Dear Students,
The Department of Operations and Supply Chain Management will be offering an Excel workshop in March that will take place over two Fridays. Microsoft Excel is one of the most commonly used tools for data analysis and business decision making.
Day 1 Agenda: Excel Fundamentals for Business Analysis
The first day will discuss the over 30 useful formulas, how to use various charts, business report generation, Gantt chart creation, and other data analysis techniques.
Target Skill Level: Beginning to intermediate in Excel
Day 2 Agenda: Decision-Making Using Excel
The second day of the workshop focuses on how to use Excel to make business decisions. Students will build and solve four business cases using Excel tools:
- Case 1: The first case consists of three parts:
(1) P&L Analysis and visualization of data using charts, histograms, and graphs; (2) Breakeven point calculation; and (3) NPV calculation for investment decision
- Case 2: How to use a solver to determine an optimal solution.
- Case 3: Develop and graph sales forecasts.
- Case 4: Develop a simulation model.
If time permits, macro recording and database fundamentals will also be covered.
Target Skill Level: Intermediate to Advanced in Excel
|
|
Workshop Details
| Dates: | | March 2, 2012 (Day 1)
March 9, 2012 (Day 2) |
| Time: | | 9:00am - 4:00pm |
| Place: | | BU 17B |
| Fee: | | $49 (Day 1 Only)
$80 (Both Days) |
Free to OSM Undergraduate majors |
Please note that the workshop requires that you already have basic knowledge in using Excel.
The instructor for the workshop will be
Ms. Dan Yu, a CSCP and Supply Chain Cost Analyst for Dealer Tire. She received her MS in Supply Chain from Case Western University and is also the APICS director of Education.
Workshop Registration & Completion
- If you would like to register for the workshop, you must do so by calling 216.687.4740, or by sending an e-mail to osm@csuohio.edu. Please specify which day(s) you plan on attending.
- The capacity is limited to 40 people per day, based on first-come, first-served registration.
- All materials will be provided.
- Upon successful completion of the workshop, you will receive a Certificate of Attendance.
|
If you are having
trouble viewing this email, please click here.
|
 |
