PivotTables: From Slicers to Dashboards
What you'll learn
- Excel PivotTables
- Intermediate skills in Microsoft Excel
Excel PivotTables have been around for a while, but 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 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’.
Each lesson in the course is accompanied by the Excel file used in the demonstration with step-by-step instructions, and also has an Excel exercise for you to practise in your own time.
Disclaimer – although we have made every effort to ensure that the methods and techniques shown are Best Practice, we accept no liability for any costs that may be incurred as a result of incorrect use of Microsoft Excel. Microsoft Office is now continuously updated by Microsoft, with new features appearing at any time, sometimes unannounced; we shall endeavour to keep the course up to date, but you may find that some features have changed or are not yet covered on the course.
Who this course is for:
- Business users
Linda is a versatile and committed IT professional with over 25 years experience of training and supporting adult learners. She has developed many successful training programs for a range of organisations, including the Open University, Bedford College, Chamber of Commerce and Knight Frank. Linda has been praised for her open approachable style both in the classroom and when coaching colleagues. She has trained mostly desktop PC products including Microsoft Office and Adobe Captivate, but has also covered various business skills, adult literacy, and personal development subjects.