Excel Dynamic Conditional Formatting: Create a User Controlled KPI Dashboard
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...
The Excel HR Dashboard: How to Create a Salary Summary Dashboard in Excel
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...
The Excel Inventory Planning Dashboard Based on Actual Sales
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...
Three 60 Second Excel Custom Number Formatting Videos that will Help you get Noticed in the Office
Last week I had the opportunity to put a little bit of time into building a few videos on my YouTube Channel that focus on how to effectively use Excel custom number formatting. Let's be honest, when I put it that way, it sounds a little bit lame and boring. I can...
Excel in 60 Seconds: Learn How to Display Numbers in Thousands in Excel
It has been quite sometime since I last posted a video on YouTube and to tell you the honest truth, I'm not sure why I don't do it more often. What is even more funny is that my wife has been all over me about doing videos saying that it's really just the best way to...
5 Easy Steps on How to Make an Excel Dashboard
It's no secret that being a power user in Excel has its perks. Research shows that users who truly know how to use the power of Excel can potentially increase their salary by up to nearly $4,000 per year (dependent on their career). If you don't believe me, have a...