Pivot Table Course (Excel 2003, Excel 2007, Excel 2010 & Excel 2011 for Apple Mac)

This course is aimed at intermediate to advanced users.

If you are not sure what you or your organisations skill level is, download this file , complete the Instructions and Questions sheets and email back to us for a free skill assessment (South Africa and African countries only)

- Click here to go back to the Live Training Home Page

- For details on timing refer to the schedule on the right

- For information on pricing and venue please mail adrian@AuditExcel.co.za or Get Price and Venue details

Search the site

Advanced Excel Training Courses

Contact us for more information on 011 563 3805/ 083 272 2552 or info@AuditExcel.co.za

Excel Course in Rivonia and Sandton, Johannesburg

Download Price and venue and see dates below

11-15 June 2012

18-20 July 2012 (less 5%)

13- 17 Aug 2012 (less 10%)

17- 21 Sep 2012

15-19 Oct 2012

12- 16 Nov 2012

Get Price and Venue details

Watch a video clip of what you will learn

Featured Product

Online Excel training based on the Excel for dummies series.

• Train at your own pace

• Learn from anywhere

• Intuitive and easy to use

• Review and practice what you learnt for a full year

For a sample register by clicking on this link for a trial

Contact Details

Mail: info@AuditExcel.co.za

Call Adrian + 27 83 272 2552

Miricle Solutions cc

PO Box 2683

Rivonia

2128

Who should attend

Contents

Clients include:                                       MTN  ,  Anglogold Ashanti  ,  Old Mutual  ,  Sun International  ,  Sasol  ,  Telkom  ,  International Housing Solutions  ,  TUHF  ,  AFHCO  ,  Naspers  ,  Supersport  ,  Tiso Capital  ,  Standard Bank  ,  ABSA Capital  ,  Nedbank  ,  Gauteng Treasury  ,  South Africa Custodial Services,                                           AND YOU                                   

INTRODUCTION

This application driven half day programme leads delegates through Excel's pivot tables, explaining the functions and its uses. This is a very hands-on, non-intimidating, course – delegates work through various exercises under the supervision, and with the help, of the facilitator to get to grips with the nuances of Excel’s advanced functions

WHO SHOULD ATTEND

o All persons using Excel spreadsheets (either Excel 2003 or Excel 2007)

o All persons involved in using Excel to process large datasets, especially those received from other systems, and converting them into reports to be utilised in the business.

PRE REQUISITE(S)

Delegates should be familiar with Microsoft Excel (though not necessarily expert in the use thereof, as any relevant Excel function pertinent to an exercise will be discussed prior to tackling the exercise).

Excel knowledge required:

1. Basic Excel skills

a. Opening & closing files

b. Moving around the spreadsheet

c. Inserting & deleting rows and columns

d. Inserting text & formulas

e. Deleting cells

f. Copying formulas

g. Printing

2. Basic formulas (+-*/) e.g. =C5+C7+sum(C9:C12), and =D5*D6/12

3. Formatting

If any of these are a problem please visit www.AuditExcel.com where you can get affordable online training to address these areas.

Pricing

Download the following pdf document with the registration documents and pricing for the various course. For inhouse courses please contact us at info@AuditExcel.co.za

Get Price and Venue details

Please email us at info@AuditExcel.co.za with any questions.

OUTCOMES

By the end of the course delegates will recognize areas where they could improve their own spreadsheeting. They will be in a position to immediately apply the lessons learnt to their own models in their own environment. They will immediately be able to save time on their everyday Excel tasks

What the delegates will learn (from an Excel 2003, Excel 2007 and Excel 2010 viewpoint):

• What does the data need to look like for Pivot Tables

• How to (quickly) convert non compliant data into Pivot friendly data

  • Labeling Columns

  • Subtotals

  • Filling in the Blanks

  • Data in rows and not columns

• Exercise: Normalise the data

• Pivot Tables – Step by Step

• Create a Pivot Table

• Introducing Data

• Refreshing a Pivot Table

• Manipulating the Data Portion of a Pivot Table

• Exercise: Working with Data in a Pivot Table

• Manipulating the Rows of a Pivot Table

• Sorting the information in the rows

• Exercise: Work with the rows in a pivot table

• Manipulating the columns in a pivot table

• Combining rows and columns to create meaningful Pivots

• Report Filter (Page Field in Excel 2003)

• Exercise: Combine Data, Rows and Columns in the same pivot Table

• Grouping Data in the rows and columns

  • Manual

  • Dates

  • Numbers

• Simple Charting

• Exercise: Create more meaningful pivot reports and charts

• Creating Calculated Fields within a pivot table

• Exercise: Creating a calculated field in a pivot table

• Creating Calculated Item within a pivot table

• Exercise: Creating a calculated ITEM in a pivot table

• Trying to link into a Pivot Cell (and the GetPivotData function)

• Exercise: Using GetPivotData

• Exercises: Creative Use of Pivot Tables

• Multiple Consolidation ranges in Pivot Tables

• Exercise: Multiple Ranges

• Conditional Formatting on Pivot Tables (Excel 2007)

• Linking to an external database via Pivot Tables

• Exercise: Linking to external Databases via Pivot Tables