Learn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines
Course overview Gain the skills to summaries large amounts of data into meaningful information with the Learn Excel With Pivot …
0 Students
Get access to 3000+ courses including this for a year only at Ā£49. GET NOW
Save 94.86 % - Offer ENDS SOON
Access All Courses for Only Ā£49
14-Day Money-Back Guarantee
-
1 Year
Access -
BeginnerSkill Level -
1 hour, 21 minutesDuration
Access
Skill Level
DurationLearn Excel With Pivot Tables, Pivot Charts, Slicers, and Timelines
Join thousands of learners building a successful career
Course overview
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.
Learning outcomes
- Learn how to summaries data with Pivot Table
- Be able to add graphical representation to your summarized data with PivotChart
- Learn how to update the Pivot Table with new data
- Deepen your understanding of sorting and filtering
- Be able to import data from various sources with Power Query
- Gain an excellent understanding of Power Pivot
Who is this course for?
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.
Entry Requirement
- This course is available to all learners, of all academic backgrounds.
- Learners should be aged 16 or over to undertake the qualification.
- Good understanding of English language, numeracy and ICT are required to attend this course.
Certification
- After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of Ā£39 or in PDF format at the cost of Ā£24.
- PDF certificateās turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.
Why choose us?
- Affordable, engaging & high-quality e-learning study materials;
- Tutorial videos/materials from the industry-leading experts;
- Study in a user-friendly, advanced online learning platform;
- Efficient exam systems for the assessment and instant result;
- The UK & internationally recognized accredited qualification;
- Access to course content on mobile, tablet or desktop from anywhere anytime;
- The benefit of career advancement opportunities;
- 24/7 student support via email.
Career Path
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:
- Data AnalystĀ
- AccountantsĀ
- Financial Analyst
Course Curriculum
-
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
Getting started with your Pivot Table -
Order Your Certificates and Transcripts
Frequently Asked Questions
Most courses do not require prior qualifications unless stated otherwise on the course page. Please check the individual course description for any specific entry requirements.
Learners must usually be 16 years or older to enrol. However, learners under 16 may join with parental or guardian consent.
Yes, if you do not pass the exam on your first attempt, you may retake the exam up to 3 times, depending on the course terms.
You will normally have 1 year of access to your course from the date of enrolment. Course duration may vary, and the estimated study time is mentioned on the relevant course page.
Yes, our courses are available worldwide. You can enrol and study from any country as long as you have an internet-connected device.
