Category: LEARN EXCEL DASHBOARDS

3 Creative Ways to Use Special Fonts to Enhance Your Excel Spreadsheets

How could you use a font to enhance your Excel spreadsheets? I know that it’s tough to believe but special fonts actually offer a ridiculous amount of possibilities when it comes to building visual displays of any nature in Excel. The more you begin to understand Excel and how objects interact, the more use you will find of these silly fonts. When it comes to the office, you’ll be able to take some of these tactics and apply them to your spreadsheets and I’ll guarantee you end up turning some heads (hopefully the people that truly matter). # 1...

Read More

The Excel Sales Trend Dashboard

THIS WEEK’S EXCEL TIPS TIP # 1: How to Create Mini Chart Overlays on Your Dashboards TIP #2: How to Add Data Callouts to Your Excel Dashboards Charts for High/Low Values TIP #3: How to Add Excel Data Validation to Your Dashboards THE FEATURED PRODUCT   For decades, managers and executives around the world have been monitoring sales trends to capture and understand sales cycles in their industries.  In this Excel Sales Trend Dashboard, I’ve created a dashboard that automatically pulls your raw data from a table and displays the monthly sales trends for the data that you’ve added....

Read More

Excel Tutorial: 3 Tips on How to Create an Automated Budget & Expense Tracker

THIS WEEK’S EXCEL TIPS TIP # 1: Keep Your Dashboard Header Visible Using Freeze Panes TIP #2: Create Buttons in Your Header to Navigate Between Worksheets TIP #3: Use a Nested SUM & IF Formula to Summarize Your Detailed Expenses   THE FEATURED PRODUCT           It always seems that no matter how hard you try, there is always an easier way to do something.  My wife emailed me one day this week asking if I’d be able to build her something in Excel that could handle the tracking of all of her departments expenses and then...

Read More

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 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...

Read More

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 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...

Read More