Use PivotTables and PivotCharts with comfort and ease
One of the most powerful features in the Excel package, Pivot Tables are widely recognised for their applications – but very rarely is their full functionality ever harnessed. In fact, current estimates show that as few as 12% of Excel users ever utilise Pivot Tables – with only a handful of that 12% harnessing the full range of functionality available to them.
Harness The Power Of Pivot Tables in Microsoft Excel 2003, 2007 and 2010
Join us for this exciting one-day workshop, which not only covers all the best functionality of Pivot Tables, but also provides you with meaningful, practical solutions to day-to-day problems - and discover how to:
create powerful summary reports in seconds rather than hours
build ad-hoc query tools with ease
enhance your executive reporting
filter reports to reveal the top 10 customers or products in terms of profitability
add dynamic charts to reports
quickly summarise daily data by month, quarter or year.
Please note: This workshop requires only a basic familiarity with Excel.
Delegates who have attended Front Foot's 'Get the Best out of Excel' workshop, or use Excel frequently, will have no difficulty in grasping the information contained in the workshop.
Creating a Pivot Table Report with Multiple Columns
Creating a Pivot Chart
Understanding Data Sources for Pivot Tables
Using Excel Data from the Same Workbook
Using Excel Data from another Workbook
Using Data from Databases
Queries
OLAP Cubes
Creating a Pivot Table Report from Data in an Access Database
Using Other External Data Sources
Using Pivot Table Tools and Formatting
Using the Layout Dialog Box in the Pivot Table and Pivot Chart Wizard
Understanding the Pivot Table Toolbar
Customizing the Pivot Table Toolbar
Using the Pivot Table Menu
Setting Pivot Table Options
Format Options
Data Options
Formatting Pivot Tables
Autoformatting a Pivot Table
Changing the Number Format
Changing Other Formats
Applying Formatting to a Pivot Table Report
Working with Pivot Table Components
Using Drop Areas
Using the Column Drop Area
Using the Data Drop Area
Using the Page Drop Area
Using Settings for Data Fields
Using Different Summary Functions
Sort Options
Understanding and Using Pivot Charts
Understanding Pivot Charts
Creating a Pivot Chart
Create a Pivot Chart from an Existing Pivot Table
Create a Pivot Chart from Scratch
Understanding and Changing Pivot Chart Types
Understanding a Pivot Chart's Structure
Creating a 3-D Pivot Chart
Using Pivot Tables with Multidimensional Data
Using Multidimensional Data
Understanding Multidimensional Data
Flat Data
Relational Data
Multidimensional Data
Creating a Pivot Table from a Cube File
Working with OLAP Pivot Tables
Booking facilities for this workshop are provided by
FRONT FOOT.co.za
If you are in any doubt as to the authenticity of the site you are redirected to, please feel free to call us on
011 880 4808, and someone will be there to do the registration on your behalf.
When you register online, using the links above and below, you will be able to pay using our secure credit card facility. Alternatively, you are welcome to make payment by EFT after you have downloaded your invoice.
Once your registration has been fully submitted, you will receive a confirmation email containing your invoice and a map and directions to the venue. We kindly request that you please add frontfoot.co.za to your safe senders' mailing list in your junk mail to ensure that you receive all the communications for this event timeously.
Please note that your registration for this workshop is subject to the terms and conditions as laid out here.
Front Foot Strategic Consulting has been awarded accreditation status as a provider of Education and Training in terms of the National Qualifications Framework Act, 2008.
All Front Foot Microsoft workshop presenters are Certified Microsoft Application Specialists.
Book for 2 or more delegates to attend the same workshop and we'll give you a 10% discount.
ATTEND 2 WORKSHOPS
Book for and attend any 2 workshops or events and we'll give you a 10% discount on the total ticket price
OUT-OF-TOWN DISCOUNT
If you fly in from out-of-town to attend any Front Foot Workshop, we'll give you a 15% discount
For more information on discounts please contact Adele on 011 880 4808 or email adele@frontfoot.co.za
IN-HOUSE WORKSHOPS
All Front Foot Workshops are available in-house, at a location of your choice, at your convenience.
For more information on in-house workshops please contact Adele on
011 880 4808 or email adele@frontfoot.co.za
Terms and Conditions Apply. E & OE. Subject to change.
Join The Decision Makers Database at no-charge today and we promise to do everything we can to keep you in touch, and up-to-date, with the latest in local and international training and development opportunities, and to give you unparalleled access to all the business news and information you need to be a Corporate Superstar.
