When you’re first starting out in Excel, becoming efficient is an afterthought. Whether you like it or not, Excel seems to be the tool of choice for data manipulation, charting, reporting, and dashboards in nearly all workplaces simply for the fact that if you know how to use a mouse and a keyboard, you can learn how to use Excel. Excel becomes more and more powerful as you continue to use it and understand the available features. People love dumping there system data and information into Excel because of its flexibility. (more…)
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.
One thing that I love to save is my time. Wouldn’t things just be that much better if you had a little more time? I want to show you a quick and fairly painless method of allowing your spreadsheet/dashboard user to update target numbers to monitor salesperson performance. What is going to save you time is showing you how you can use conditional formatting in Excel and combine it with an input range to build a dynamic key performance indicator table. Instead of having to tediously go in and update target numbers every month from the manage rules options of Excel conditional formatting, you can painlessly update your targets by simply updating your input range. Sounds easy, right? It is. So let’s have a look.
Alright so this is the first week that I’ve attempted to build and create a dashboard all the while creating full blown tutorial videos showing you how to create the dashboard from stage 1. I haven’t received any overly positive responses from my YouTube channel as of yet but I’ll see how valuable this is to you, the readers of my blog. If you’re loving the idea, please let me know in the comments or support the cause by purchasing a copy of the dashboard for $5. Depending on the response, I may not continue as it is an insane amount of work to put everything together in such a short period of time on a weekly basis. Should I continue, I’ll be teaching you more and more Excel dashboard techniques that under normal circumstances you would only learn in paid Excel dashboard courses.
That all being said, let’s learn how to build an Excel HR dashboard. I’ll go through the creation process and simply outline the key points that are really beneficial and that are covered in each video tutorial. Let’s do this!
Working with inventory can sometimes seem like a huge insurmountable job. Determining how well each part is performing and forecasting when you’re going to run out of inventory for each part is not only really difficult but it’s nearly impossible. There are way too many variables that are at play especially if you’re not working off of contracts with your customers. That being said however, there are some ways that you can at least track and review your historical sales and usage trends for your inventory. This will at least allow you to at a very basic level understand what’s actually been happening in the market in the months leading up to today.
