
Dive deep into the realm of Excel with our meticulously designed course on “Excel Pivot Tables, Pivot Charts, Slicers, and Timelines“. Unlock the secrets of powerful data visualisation tools like Dashboards, Slicers, and Timelines, while mastering the art of reporting by varying time intervals. Whether you wish to streamline your reporting tasks or augment your analytical capabilities, this course will provide you with the tools and techniques to extract insights from data seamlessly.
Highlights of the Dynamic Excel Gantt Chart and Timelines :
The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace.
You are taught through a combination of
To successfully complete the course you must pass an automated, multiple-choice assessment. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.
Upon successful completion, you will qualify for the UK and internationally-recognised certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £9 and Hardcopy Certificate for £15.
The Dynamic Excel Gantt Chart and Timelines is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.
Excel Pivot Tables, Pivot Charts, Slicers, and Timelines | |||
Getting started with your Pivot Table | 00:04:00 | ||
Drill Down | 00:01:00 | ||
Managing the Field List | 00:02:00 | ||
Changing the Calculation type with Value Field Settings | 00:06:00 | ||
Growing your Pivot Table with Multiple Fields | 00:04:00 | ||
Formatting the Pivot Table | 00:05:00 | ||
Sorting and Filtering the Pivot Table | 00:03:00 | ||
Creating a Dashboard with Slicers, Timelines and Pivot Charts | 00:09:00 | ||
Reporting by day, month, qtr, or year within the Pivot Table | 00:04:00 | ||
Refreshing the Pivot Data with new data | 00:03:00 | ||
Adding your own calculations into the Pivot Table | 00:03:00 | ||
The power of the Filter Section in the Pivot Table | 00:04:00 | ||
PowerQuery | 00:12:00 | ||
PowerPivot | 00:21:00 | ||
Assignment | |||
Assignment – Excel Pivot Tables, Pivot Charts, Slicers, and Timelines | 00:00:00 |
Unlock the full potential of Microsoft Excel with the New Functions in Microsoft Excel course and take your spreadsheet skills …
1
Unlock the true potential of data with the Excel Data Analysis course, designed to sharpen your ability to extract valuable …
0
Mastering MS Word is an essential skill for anyone aiming to create polished and professional documents with ease. The MS …
1
$427.70 Original price was: $427.70.$27.30Current price is: $27.30. ex Vat