Advanced Excel Pivot Tables

Are you just using the basics of Pivot Tables? Probably you could save yourself an extra one or two hours or a day by mastering these advanced Pivot Table concepts! 

What you'll learn

  • Learn the A-Z to maximize Pivot Tables potential
  • Best practices to manage pivot reports data
  • Analyze large sets of data, swiftly. You'll be surprised how effortless your reporting can be!
  • Create noticeable management reports that answer business questions on the fly
  • Build fully dynamic Excel dashboard -no formulas, no VBA -all from ground up
  • Create custom branded slicers that align to your corporate colours
  • A full introduction to Excel Power Query for data preparation -you'll love this
  • Interact with Power Pivot -an overview

$19

Buy Now

This course includes

  • 2.5 hours on-demand video lessons
  • Downloadable practice files
  • Certificate of completion (digital)
  • Access on mobile, anytime
  • Immediate start -don't wait!
  • Lifetime access with updates

Description

Are you looking for an effortless way to summarize your data?
You need to integrate Pivot Tables to your reporting workflow.

This course breaks down how to use this power and time-saving tool for a beginner to advanced Excel Pivot Table features, including how to leverage it to create simple but visually rich and interactive dashboards.

Throughout the course, we share practical demonstrations that help you grasp how these tools are used in the real world.

This powerful Excel feature cuts the time you spend on formulas in half!

Whether you’ve used it before or not, I guarantee there’s something for you. You’ll be surprised how much you’re leaving on the table

I have finally completed the course and how excited I am! Your delivery is superb with very simple and clear illustrations. I had interacted with pivots and dashboards before, but this has taken me off to another trajectory.
Charles OnsongoData Analyst
Charles Onsongo

Course content

  • Inserting your first pivot table
  • Perfecting your source data structure
  • Changing the default Field List appearance
  • Design layouts and styles that enhance report readability
  • Changing base function from SUM, etc.
  • Point and click to refine/filter data in multiple views giving answers to business questions on the fly
  • Control multiple reports with one slicer
  • Adjusting slicer properties and orientation
  • Branding a slicer with your corporate colours
  • Display percentage share without manually computing it
  • Show % change such as year on year growth rates
  • Running balances
  • Ranking items
  • Percentage running totals for Pareto analysis
  • You have dates but you want quarterly reports, how do you do that within a pivot report!
  • We show you how to group invoice days outstanding into ageing ranges, or employee ages for planning purposes

You have over 20 product lines, or 30 outlets and you want to focus on the top 5 revenue earners or bottom 3 outlets to inform your marketing choices. We’ll show you how to dynamically create such reports

This lesson shows how to create a complete dashboard by leveraging on the features that pivots avail, key among them the slicers and pivot charts. NO FORMULAS INVOLVED Learn to tidy up the charts for a professional finish

  • Ever wondered if you could create a pivot report from more than one data source? How about automating (no coding) the data preparation process?
    We’ll introduce you to these power tools -Power Query & Power Pivot

What others said

I do appreciate the value of Knowledge and simplicity of passing the information to learner . I recommend every one to watch it and take it

Mohammad H

This was excellent course to help save on time and resources and create great and presentable reports. keep it up

Peterson M

Super Fast Reporting

Want to change the way your boss views your reports and you in general?

$19

Start Exploring Now

30-Day Money-Back Guarantee

If you’re unhappy within the first 30 days, for whatsover reason, we’ll refund your fee 100%. No questions asked.

Clear any doubts

The concepts in this course work with all versions from 2010 and above. Only the screen windows will vary slightly, but I’ll highlight where to go for your version

Absolutely not. Just have a mindset to learn, roll up your sleeves and let’s get rolling!

You have immediate access once you complete payment. And yes, you have unlimited access henceforth.

You pay only one for the course. No annual renewal fee.

We’ve put every effort to make this course relevant and practical. All we ask is that you really give the course a good go. Should you be unsatisfied for whatsoever reason within the 30 days window from day of purchase, we’ll be happy to refund in full. No questions asked!

Once you have completed the course, you’ll acquire official Certification from DCA and you can download or share in your social circles.