Description
Curriculum
Instructor
In today’s world, there are tons of data to manage. Data is coming from many different sources. It is very important to be able to process that data quickly and then summarize it into meaningful information. This course will show you how to take large amounts of data from many sources and processes it into great reports.
On Completion of this course, you’ll be a pro in the following concepts & processes:
- Getting started with Pivot Tables
- Drill down
- Managing the Field List
- Changing the value field settings
- Growing the Pivot Table
- Sorting and Filtering
- Slicers
- Timelines & Pivot Charts
- Creating a report by day, month, qtr,and year
- Updating the pivot table with new data
- Adding your own calculationsthe power of the filter sections
- PowerQuery & PowerPivot
Some exceptional benefits associated with this course enrolment are:
- Quality course material on MS Excel Pivot Tables
- Lifetime access to the course
- Instant & free course updates
- Access to all Questions & Answers initiated by other students as well
- Personalized support from the instructor’s end on any issue related to the course
- Few free lectures for a quick overview
It’s time for you to grab the opportunity and make the most out of this course.
Enroll today!!
Curriculum
- 1 Section
- 14 Lessons
- 2 Hours
Expand all sectionsCollapse all sections
- Excel Pivot Table14
- 2.1Pivot Tables 2020 – 1 – Getting started with your Pivot Table4 Minutes
- 2.2Pivot Tables 2020 – 2 – Drill Down1 Minute
- 2.3Pivot Tables 2020 – 3 – Managing the Field List1 Minute
- 2.4Pivot Tables 2020 – 4 – Changing the Calculation type with Value Field Settings6 Minutes
- 2.5Pivot Tables 2020 – 5 – Growing your Pivot Table with Multiple Fields4 Minutes
- 2.6Pivot Tables 2020 – 6 – Formatting the Pivot Table5 Minutes
- 2.7Pivot Tables 2020 – 7 – Sorting and Filtering the Pivot Table3 Minutes
- 2.8Pivot Tables 2020 – 8 – Creating a Dashboard with Slicers, Timelines and Pivot Charts9 Minutes
- 2.9Pivot Tables 2020 – 9 – Reporting by day, month, qtr, or year within the Pivot Table4 Minutes
- 2.10Pivot Tables 2020 – 10 – Refreshing the Pivot Data with new data3 Minutes
- 2.11Pivot Tables 2020 – 11 – Adding your own calculations into the Pivot Table3 Minutes
- 2.12Pivot Tables 2020 – 12 – The power of the Filter Section in the Pivot Table4 Minutes
- 2.13Pivot Tables 2020 – 13 – PowerQuery12 Minutes
- 2.14Pivot Tables 2020 – 14 – PowerPivot21 Minutes
Tom Fragale
0 Students14 Courses
I am a Microsoft Certified Trainer with over 35 years of professional IT experience, and my passion is teaching people how to get the most out of their computer.
Courses you might be interested in
The ability to study each potential buyer and respond immediately and appropriately to their verbal and physical cues. In this course, you” go through the history of psychology in...
-
15 Lessons
₹449.00
Discover The Hidden Secrets Of Beating Anxiety! On Completion of this course, you’ll be able to: Discover How To Banish Worry & Live An Anxiety Free Life! Learn How...
-
10 Lessons
₹599.00
Secrets They NEVER Taught You In School Or Life! On Completion of this course, you’ll be: Talking In A Way That Your Children Will Listen & Change! Knowing The...
-
13 Lessons
₹599.00
Using the Power of Social Media to Attract a Crowd of Loyal Customers. On Completion of this course, you’ll be: In no longer need to “run an ad” and...
-
39 Lessons
₹449.00