Excel is a vital tool for boosting your efficiency and productivity when you’re dealing with large amounts of data and calculations. This course is a journey through the key topics for Excel power users and majors on Macros and Pivot Tables…
Microsoft Excel Pivot Tables Course
Excel Pivot Tables Course
Pivot Tables are one of Excel’s most powerful features. And one of the easiest to learn! You can summarise and analyse huge amounts of data easily and rapidly. Take our one day Pivot Tables course to go from zero to hero. We start from first principles and go on to produce calculations and dynamic reports. You don’t need to know anything about Excel formulas to attend our Pivot Tables course.
All our courses are available online with Zoom or Teams. You are welcome to attend our training centre, or we can come to you. Call 020 7920 9500 today for further details.
Create Great Pivot Table Reports
How are you doing your regular reports? Crunching numbers with calculators and hundreds of bits of paper is no fun. And it’s always against the clock. We’ll show you how to do it with Excel Pivot Table reports. Update your source data, click to refresh your analytical reports and you’re done for another reporting cycle. Easy!
But there’s more to Pivot Table calculations than just a simple SUM or COUNT. We’ll demonstrate the use of calculated fields and items and how to take advantage of the Show Values As options to calculate percentages, comparatives and differences. These are great for showing calculations like variance on previous month or market share etc.
After you’ve crunched your numbers, we’ll show you how to help everyone interpret your data by introducing data graphics like Slicers, Timelines, Charts, Data bars and Traffic lights.
Related Posts
Functions are the backbone of most worksheets. But there are around 500 worksheet functions in Excel! Our course covers the most important Excel functions. The ones you will actually use time and time again…
The aim of BI (business intelligence) is to make sense of the vast amounts of data that organisations hold. Our Power BI courses help you analyse and visualise your data and thus guide effective business decision making…
Get the best from Excel, it’s one of the most used office applications. But, at the same time, it’s one of the most under-used. Come along on our Excel Intermediate course and open the door to what Excel can do for you…
There’s been quite a few changes to Excel in recent years and they’re easily missed. Our New Functions course covers functions like XLOOKUP, FILTER and many more. Number crunchers should check out our Power Query course…