Using Microsoft Excel for Effective Capacity & Performance Management
16th October, The Hatton, Hatton Garden, London
20th October, Regus Building, Edinburgh Park, Edinburgh
Capacity and performance practitioners traditionally used SAS to undertake analysis and reporting. However, Microsoft Excel is widely available but its capabilities are often surprisingly underused, especially its ability to analyse and report on capacity and performance data. Topics covered include:
- Pivot tables: Manipulating data quickly and effectively; Dealing with gaps in data; Summarising; Creating interval records from event records
- Filtering: Custom filters
- Batch modelling: Look-up tables; Gantt charts
- Surface plots: Combining 24 hour profiles with monthly growth
- Forecasting functions: FORECAST; GROWTH; Moving averages; Linear regression with trendlines and the Data Analysis wizard
- Creating GIFs: Saving charts separately from the workbook; Creating HTML
- Automation: Creating Visual Basic modules through keyboard macros
- Charts: Dealing with too much data; General tips
This seminar gives practical advice on how to undertake a multitude of tasks using Excel. The workshop is platform independent, using various sources of data in demonstrations, and focuses on providing a value-for-money approach to capacity and performance analytical tools. The workshop includes coffee/tea/juice/pastries on arrival, refreshments throughout the day and lunch.
Tutor
Neil McMenemy, Principal Consultant, Capacitas.Agenda
| Session title | Time | |
| Registration | 09:00 - 09:15 | |
| Introduction: Excel - the ultimate modelling tool? | 09:15 - 09:30 | |
| Pivot tables and Filtering | 09:30 - 10:50 | |
| - Coffee/Tea - | 10:50 - 11:10 | |
| Batch modelling & Surface plots | 11:10 - 12:30 | |
| - Lunch - | 12:30 - 13:30 | |
| Forecasting functions & Creating GIFs | 13:30 - 14:50 | |
| - Coffee/Tea - | 14:50 - 15:10 | |
| Automation & Charts | 15:10 - 16:30 | |
| Questions & Answer session | 16:30 - 16:55 | |
| Summary and closing remarks | 16:55 - 17:00 |
Venue
The Hatton51 - 53 Hatton Garden
London, EC1N 8HN
Directions
Regus Building
10 Lochside Place
Edinburgh Park
Edinburgh, EH12 9RG
Directions
Fee
*** Special discount for this first workshop only ***
The fee for this workshop is £450+VAT. To register please email Excel for Capacity & Performance Workshop, or call 020 7841 7431.
Comments from attendees of previous seminars
- "Great idea to hold a short themed seminar; allows people to get the main ideas and areas for further work, training, etc."
- "Case study was interesting"
- "Good question/answer section, showing good knowledge and experience of participants"
- "Clarity of presentation of method reassuringly honest"
- "Interesting morning and very cost effective"
- "Well worth my time"
- "I am genuinely satisfied"