Category: EXCEL ADVANCED

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

4 Easy Steps to Using the Excel Option button for Dynamic Dashboards

In business, I often see disputes between the finance and operations departments on which metric is a more important indicator of performance.  Operational leaders (more often than not) like to see their numbers in terms of units/quantities and the finance executives/leaders want to see everything in dollars or currency.  This is where the Excel option button form control comes in handy (note that if you are part of a finance team, you can also use this logic to switch between local currency versus your company’s global standard currency).  I’m going to show you how you can use the option button...

Read More

Excel Customer Aged Receivables Dashboard: Summarizing Your Aged Receivable Data To Help You Make Quicker Decisions

Building an Excel customer receivables dashboard came to me when I realized that most companies seem to really make use of their invoice information to look at their customer credit performance.  Reviewing how your customers are doing in terms of making their payments plays a significant role in having a successful company because this is your lifeline for actually getting the bills payed.  This cash flow plays an integral part in the business and also allows your company to grow. So, What Does This Dashboard Do Exactly? The customer receivables dashboard allows you to load up your customer contact...

Read More

11 Reasons Why You Should Check Out The VLOOKUP Book From Chandoo.Org

I recently purchased a copy of Chandoo’s The VLOOKUP Book and realized that it was the first piece of material that I had read that covered pretty much all of the bases when  it came to the Vlookup formula and other lookup formulas in general.  Because I was able to learn something from this book I figured you may be able to benefit from purchasing the book.  Since I believe in Chandoo’s products and what he is doing, I decided to become an affiliate (the links in this post are affiliate links) and to provide you with some insight...

Read More