Microsoft Excel Advanced PivotTables
IC1310

Microsoft Excel Advanced PivotTables

In this Advanced PivotTables Excel course, we teach you how to make the most of this powerful data analysis function. Start with a PivotTable refresher before moving onto some of the advanced features of this tool. Advanced Sorting, Slicers, Timelines, Calculated Fields, Pivot Charts, and Conditional Formatting are just a few of the subjects included in this PivotTable deep-dive. This course is perfect for intermediate users of Excel who are already comfortable using the PivotTable function. 

New Course - Not Enough Reviews Yet
77 student views


Course Goal

  • How to format a PivotTable, including adjusting styles
  • How to create a Pivot Chart and add sparklines and slicers
  • How to create an awesome looking interactive dashboard
  • Understand how to use GETPIVOTDATA
  • How to use 3D Maps from a PivotTable

Who This Training Is For

  • All SAP professionals

Exam/Certificate

  • Certificate of Completion (more certification info)
  • Upon successful completion of this course, receive your Microsoft Excel Advanced PivotTables certificate

This Course is In the Following Learning Paths:

Microsoft Excel
Microsoft Excel

Take this learning path to increase your skills from a spreadsheet novice to an Excel Master. After you complete this pa...

Show All Learning Paths

Instructor

Simon Calder

4.7 Average Rating

100 Reviews

732 Students

21 Courses

Simon Calder

Teaching Business Software

Chris "Simon" Calder was working as a Project Manager in IT for one of Los Angeles's most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course which he sold on DVD via eBay. Fast forward to now and Simon Sez IT has taught hundreds of thousands of students through its online course platform and popular YouTube channel.

Students Also Bought:

SAP S/4 HANA - Basic Navigation
SAP S/4 HANA - Basic Navigation

Your path to specializing in SAP S/4 HANA starts here. Perform hands-on simulations to learn the basics of SAP S/4 HA...

4.5

Average Rating

SAP S/4 HANA Intermediate SAP Skills
SAP S/4 HANA Intermediate SAP Skills

Specialize in SAP S/4 HANA. Open the door to new job opportunities and a command higher wages. Designed for intermedi...

4.6

Average Rating

SAP S/4 HANA - Basic Reporting Skills
SAP S/4 HANA - Basic Reporting Skills

Develop the SAP S/4 HANA skills to become an SAP professional in one of the most in-demand SAP modules. Learn the mos...

4.5

Average Rating

View All Courses

Student Feedback

New Course - Not Enough Reviews Yet

Language: English
Level: Intermediate
Duration: 7.5 hours
Type:  Instructor-led
Category: Management

Training 5 or more people?

Unlimited access for your entire SAP team.

SAP Training for Businesses