(First published by Neil on 24/09/2019)
Coming Soon. Pivot Tables: From Slicers to Dashboards
Excel PivotTables have been around for a while, however it’s only recently that the full power of PivotTables has been realised. Using PivotTables you can quickly and effortlessly extract and analyse your data in Excel. They are also are interactive; you can filter data using ‘Slicers’ and ‘Timelines’, and from this data you can also create interactive ‘PivotCharts’.
Ultimately, you can create a Dashboard, which is a single ‘interactive’ worksheet that contains all your key information as a visual summary, ‘at a glance’.
On our ‘PivotTables: Slicers to Dashboards’ course we’ll show you how to create PivotTables and Dashboards without the need for installing addins, knowledge of coding or Excel function formulas. Anyone with a basic knowledge of Excel and a thirst for getting something out of their data should sign up for this course.
Topics will include:
- Creating a PivotTable from an Excel Table
- Filtering Data using Slicers & Updating the PivotTable
- Grouping and Formatting Data in the PivotTable
- More on Grouping and Changing Calculation Method
- PivotTable Options, Layout & Filter Pages
- Building Custom Calculations in PivotTables
- PivotTable ‘Built-in’ Calculations
- Using Conditional Formatting in PivotTables
- Creating & Filtering PivotCharts
- Using Timelines & Report Connections
- Creating your Dashboard
- Formatting your Dashboard
- Protecting your Dashboard
Play the trailer for more information:
We have just launched our very own online academy, which will be able to host both FREE and paid-for courses. The technology we’ve used is the very latest version of WordPress, with an add-on called LearnDash. This allows the use of the latest interactive tools, such as H5P, and xAPI (TinCan) content from authoring tools such as Adobe Captivate. I can write another blog about the tech used if anybody is interested but, suffice it to say, we’re happy to be able to ditch things like Moodle and SCORM, which are starting to get a bit long-in-the-tooth.
Paid-for courses, course certificates, and other features will follow; for now, we’ve added our FREE Windows 10 course, which is suitable if you want to complete the whole course, or just dip-in to learn particular things. No sign-up or account is required for this free course. The link is nice and simple: