| |
| EVENT DETAILS |
|
| COURSE TITLE |
MORE POWER TO YOUR PIVOT: PRACTICAL USES FOR EXCEL PIVOT TABLES |
| DATE |
Thursday 19 April 2012 |
| VENUE |
The Oxford Belfry |
| SPEAKER |
Simon Hurst |
| COURSE CODE |
AP19A2 |
| COURSE FEE |
£90+VAT. (Click here for information on the Flexiticket discount scheme - fees as low as £39.60+VAT per place) This course, if booked individually, is available to IT Faculty members for £60+VAT each. For details of these other courses click here. Phone 01737 223999 for more details. |
| TIMING |
| Registration |
Course starts |
Coffee |
Course ends |
| 09:00 |
09:30 |
11:00 |
12:30 |
|
| OBJECTIVES |
PivotTables are one of Excel's most powerful features but they seem to divide Excel users into fanatical advocates and those who just don't see the point.This course will explain how PivotTables can be useful to almost any Excel user. Starting with the basics of using a simple PivotTable to summarise financial data it will show how PivotTables can simplify a range of practical Excel tasks from identifying best selling products to consolidating branch data and acting as the engine for an automated performance dashboard. |
| WHO SHOULD ATTEND? |
If you use of Excel includes summarising, analysing, auditing and reporting on any form of financial data you should find this course of value. |
| TOPICS |
- Introduction to PivotTables - from raw data to your top ten products in 5 minutes with no formulae
- Dealing with data - different ways of getting at your data and keeping it updated automatically. Consolidating data from different parts of your organisation
- Manipulating PivotTables - sorting, filtering, grouping and formatting
- Advanced techniques - ad hoc groupling, adding formulae and working with values
- PivotTable as report engine - using a PivotTable to automate the production of management reports
- Latest PivotTable developments - conditional formatting, Excel 2010 slicers and PowerPivot - the most significant Microsoft Office development of the millennium?
- Using a PivotTable to create an automated performance dashboard
|
Click here for booking form (pdf)
|
