Interactive Dashboards with Excel Pivot Tables

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...

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

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