Advanced Excel: PivotTables and Pivot Charts

Would you like to save time and increase your productivity by 80%?  The PivotTables tool is one of the most powerful yet intimidating features in Excel.  Sadly, many otherwise experienced spreadsheet fans avoid them because they seem too complicated at first glance but the real problem is that PivotTables are rarely explained properly.  

Excel PivotTables make it easy to summarise and aggregate data in Excel.  Once you've mastered them, Excel does the work for you, easily analysing business data and creating management reports with a couple of clicks of the mouse, using drag and drop interactions, thereby saving you time and allowing you to be more productive.  

The ability to use Pivot Charts and  graphs to highlight data through conditional formatting using PivotTables also vastly improves the ability of the Excel user to communicate trends and management information effectively.
On this two-day course you'll discover that PivotTables are an easy and convenient way to build intelligent, flexible summary tables, allowing you to quickly derive insight from your data.  Learn how to easily format and create powerful graphs to highlight PivotTables and create AMAZING dashboards!
Workshop Content
  • Learn to create PivotTables with a couple of clicks of the mouse
  • Learn to understand trends by Year, Quarter, Month, Week and Weekday
  • Create Top and Bottom 10 analysis 
  • Easily calculate percentage contributions, running totals and difference from calculations
  • Create custom calculations and formulas for PivotTables
  • Create Sparklines to visualise trends
  • Learn to use buckets and groupings for frequency analysis
  • Learn to use slicers to create interactive dashboards
  • Create calculated fields for key metrics and ratios
  • Learn best practices for creating Excel business graphs
  • Create column, bar, line, pie and area graphs
  • Highlight key data with conditional formatting
  • Learn to use data bars, colour scales and icons in PivotTables
  • Learn to create Combination Charts and to effectively visualise your business data
  • Understand how to apply trending tools and techniques to graphs
  • Create AMAZING interactive, graphical dashboards

 
Unit Standards
SAQA US ID 116943:  Use a Graphical User Interface (GUI)-Based spreadsheet application, enhance the functionality and apply graph / charts to a spreadsheet.
NQF Level 4
3 Credits
Duration
2 days
Requirements
Good knowledge of Excel, preferably having completed Introduction to Excel and Intermediate Excel. 

Your own laptop with Excel 2007, 2010 or 2013.
(If you do not have your own laptop, we can provide one for you to use for the course)  
Cost
R3 600 per person excluding VAT
Price is for training in Gauteng.
Price is for in-house training for 6 people or more.
Assessment and Moderation R500 excluding VAT per person.
Valid until 31 December 2017.

We are happy to discuss all your training needs and work with you to meet your requirements.