Microsoft Excel PivotTables
Two day business data analysis and management reports using Excel PivotTables
The ability to analyse and interpret data has become a key competitor differentiator in business. The PivotTables workshop teaches numerous methods of analysis and techniques such as comparison, trend, ranking, variance, contribution, frequency, pareto, visual and the creation of dashboards. These techniques allow delegates to gain new insight and intelligence from data, improving decision making and productivity.
• Learn to create PivotTables
• 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
Time: 08:00 - 16:00
Venue: Henley Business School, Sandton
Cost: R1,450 per day including VAT (R2,900 for full course)
More info:
Henley Business School is conveniently situated just off the Rivonia Road off-ramp
