DATA INSIGHT TRAINING
  • Home
  • Training
  • Resources
  • About Me

INTERACTIVE DASHBOARDS WITH EXCEL PIVOT TABLES

Would you like to save time and increase your productivity by 80%?  We can help you! 
The Pivot Tables 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.  In truth, pivot tables are simple to use and highly effective but are rarely explained properly.  
 
Excel Pivot Tables 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, 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 Pivot Tables also vastly improves the ability of the Excel user to communicate trends and management information effectively.
For more information, get in touch now...
Please contact me
info@datainsighttraining.com
+44 330 223 5910

Course Content

  • Learn how to structure your data correctly
  • 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 Sparklines to visualise trends
  • Learn to use buckets and groupings for frequency analysis
  • Learn to use slicers to quickly change views of your data
  • 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
  • Understand how to apply trending tools and techniques to graphs
  • Create AMAZING interactive, graphical dashboards 
Picture

Course Requirements

A laptop with Excel 2013, Excel 2016, Office 2019 or Office365.  You should have a good understanding  of Excel and the principals of operating Excel.

Course Duration

This is a 2 day course

Course Price

£450 per delegate (UK Mainland)
Please note there is a minimum of 4 delegates required for the course
Price valid until 31 December 2022

Privacy Policy
Copyright datainsighttraining.com
info@datainsighttraining.com
+44 330 223 5910
  • Home
  • Training
  • Resources
  • About Me