COURSE DETAILS
| Excel Pivot Tables and Filtering
|
| This half day workshop provides an understanding about the value of the Pivot Tables and AutoFilter features within Excel. |
| |
| Relates to: |
| Excel 97, 2000, XP/2002 & 2003 |
| |
| Prerequisites: |
| This course assumes attendees will have the skills necessary to create and format a simple worksheet. |
| |
| Description: |
PivotTables are a great data analysis tool for management. They allow you to create multi dimensional data views by dragging and dropping column headings to move data around.
Microsoft Excel also provides a very simple mechanism (AutoFilter) for filtering/selecting data subsets. AutoFilters can be set up to choose specific values or a range of values. Several filters can be used, each acting further on the current data subset.
|
| |
|
|
QUICK FIND
Contact details
| P: |
08 8221 5517 |
| F: |
08 8221 5518 |
| E: |
info@electus.com.au |
| |
37 Angas St
Adelaide SA 5000 |
| ABN: |
40 074 285 493 |
|
