Advanced Excel: Pivot Table, Pivot Charts, Slicers and Timelines
Learn how to use Slicers, Timelines, Pivot Tables, and Pivot Charts in Excel. Get the skill of dynamic data analysis and quickly produce informative dashboards.
Course Highlights
Pivot Table is an excellent Excel feature. It’s an efficient way to summarise data. You can create interactive dashboards and make reports. This Advanced Excel Pivot Table course provides a range of skills required for successful Pivot Table creation. Here, you’ll learn how to make interactive summary reports with Excel Pivot Tables, Pivot Charts, Slicers and Timelines.
This training will enrich your knowledge of Excel and Pivot Tables. It will teach you step-by-step how to create and use a Pivot Table in Excel to summarise, analyse, and present large data sets. You’ll learn how to drill down into a Pivot Table and use the field list. In addition, you’ll learn how to change the calculation in a value field and include multiple fields in a Pivot Table. The Advanced Pivot Tables program will also discuss formatting, sorting, and filtering the Pivot Table.
The course is filled with an in-depth look into creating effective Dashboards with Slicers, Timelines and Pivot Charts. Besides, the Advanced Pivot Tables Course will explain how to filter and display a Pivot Table by day, month, quarter and year. You’ll learn to refresh or update a Pivot Table with new data. You’ll also understand how to add calculations in the Pivot Sheet in Excel. The course will introduce you to different Pivot Filters. You’ll learn how to filter data in Excel with Pivot Table to present different sets of values. Finally, you’ll understand what is PowerQuery in Excel and how PowerQuery and PowerPivot work together.
Learning outcome
- Proficiently create and manage Pivot Tables and Pivot Charts
- Utilise Slicers and Timelines for interactive data filtering
- Employ advanced formatting techniques for clear data presentation
- Harness PowerQuery and PowerPivot for enhanced data analysis
- Develop dynamic dashboards for effective data visualisation
- Incorporate custom calculations within Pivot Tables
- Master the use of the Filter Section for refined data manipulation
Course media
Why should I take this course?
- Develop your proficiency with Advanced Excel to improve data analysis
- Improve your ability to create dashboards and reports
- Boost productivity when organising and displaying big datasets
- Improve job opportunities with in-demand Excel skills
- Keep up with the times in today's data-driven business world
Career Path
- Data Analyst
- Financial Analyst
- Business Intelligence Specialist
- Management Consultant
- Operations Manager
- Marketing Analyst
- Supply Chain Analyst
Requirements
- Basic knowledge of Excel functionality
- Familiarity with Pivot Table concepts
- Access to Microsoft Excel software
- Access to a computer or digital device with internet connectivity.
Course Curriculum
Course Curriculum
| Advanced Excel: Pivot Table, 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 | ||
Don't just take our word for it
1 Year Access 
15 Students 
1 hour, 21 minutes