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 why our fellow Excellers should really start using Excel GETPIVOTDATA. The majority of people that I talk to seem to always be reluctant or scared to use GETPIVOTDATA so I thought I’d have him share some of the super useful things that can be done using this function.
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 and AVERAGEIF. I completely skipped over learning the SUMIF/SUMIFS and AVERAGEIF/AVERAGEIFS formulas and went right into learning pivot tables. I think it was because I was always intrigued and excited about learning an entirely new concept/application within Excel. Once you start to learn how to use pivot tables you’ll realize that all of the manual work is completely removed and you’ll notice your productivity sky rocket. I am going to show you 10 productivity hacks that can be applied to Pivot Tables in Excel 2010 / 2013 and definitely most can also be applied to earlier versions of Excel as well (one of the features may only be applied to Excel pivot tables 2013). (more…)
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?). (more…)
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!
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 of scrap and help address issues that may have caused the spike. (more…)
I use pivot tables everyday to answer pretty much any of the questions my colleagues may have about any type of information or data. The beautiful thing about pivot tables is that they allow you to quickly and easily summarize large sets of data where you will have grouped information for certain fields. (more…)