Category: LEARN EXCEL PIVOT TABLES

3 Reasons Why You Need to Start Using Excel GETPIVOTDATA

  I’m super excited today to announce the first guest blogger post on bradedgar.com.  The best part about this is that this guest blogger is a veteran in Excel especially when it comes to Excel Pivot Tables.  The person I am talking about is John Michaloudis who is the Chief Inspirational Officer from My Excel Online.  John is the author/teacher of an amazing Excel pivot table course called The Xtreme Pivot Table Course (disclaimer: affiliate link) which currently has thousands of students and includes literally everything you need to know about pivot tables.  In today’s post I’ve asked John to talk about...

Read More

10 Ways Excel Pivot Tables Can Increase Your Productivity

  When I first started to learn how to use Excel Pivot Tables, I’m not going to lie, I was a little intimidated.  At the time I really wasn’t certain about how and why I should be using them to analyze and summarize my data.  Because I was a newbie I analyzed my data by literally manually selecting the cells that I wanted to summarize in combination with simple formulas like SUM and AVERAGE.  At this point I was still unaware that the majority of the manual interaction with my data set could be eliminated with formulas like SUMIF...

Read More

Creating Pivot Tables 101: A How-To InfoGraphic

You know the saying, “a picture is worth a 1000 words”? Well, I’m hoping that this post can convey to you in a quick, easy and visual fashion how to create a pivot table.  Please do not be shy and share it with everybody you know – or just post it on your social media accounts and maybe even your office cork board (do they still exist?). Even though I use pivot tables on a daily basis, I thought it would be a good idea to get a little bit of help from our friends over at Five Minute Lessons....

Read More

Excel Shortcut: Using Alt + Shift + Right Arrow To Group Your Pivot Table Fields

This is just another quick little image/post that shows how powerful Excel shortcuts can be.  If you have the time, please leave some of your favorite keyboard shortcuts in the comments – I’d love to hear them.  If you have any specific to pivot tables even better.  Thanks for checking the website out as always! Cheers to the...

Read More

Sumproduct Vs. Excel Pivot Tables: Which Method is Best for Calculating Highest Monthly Production Scrap Value

Getting the answers to your most important business questions is imperative for achieving success.  Being able to find the answers to your questions can quickly give you insight into what business processes and procedures need to be fixed in order for you to lower your costs and maximize your returns.  In this post we look at using Excel Pivot Tables versus the SumProduct formula to calculate which month had the highest production scrap within a given year.  Being able to get this information can allow management to dig deeper into why a given month had such a high volume...

Read More