Booking options
£18
£18
Get a 10% discount on your first order when you use this promo code at checkout: MAY24BAN3X
On-Demand course
1 hour 21 minutes
All levels
Gain the skills to summaries large amounts of data into meaningful information with the Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course. In this course, you will develop a comprehensive understanding of the PivotTable and PivotChart and explore how they work.
In this Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course, you will learn the steps to create your Pivot table and Pivot chart. We'll show you how to use Pivot tables to summarize large amounts of data. You'll also learn how to use PivotChart to provide visual representation to your summarized data. We will then take you through adding sorts, filters, timelines and slicers to create dynamic dashboards. You will also learn how to use the slicer to slice and dice your data the way you want.
Professionals who want to learn how to summaries large sums of data into meaningful information using Excel Pivot and Charts can take this course. The program will provide learners with in-demand knowledge and skills, allowing them to take advantage of outstanding employment opportunities.
The Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines course provides essential skills that will make you more effective in your role. It would be beneficial for any related profession in the industry, such as:
Learn Excel With 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 | ||
Certificate and Transcript | |||
Order Your Certificates and Transcripts | 00:00:00 |