I learned another trick with Excel that you can use for a variety of purposes. This example is using a grade distribution but you can use...

This is a simple formula on today's blog post. You can use this formula to take a look at the formula that is in a particular cell. Much...

Lately I have been on a quest, to improve my Excel spreadsheet skills. I have to take 40 hours of class each year to maintain my CPA...

I am not sure if I knew this one already, but it's a simple trick if all your zip code data is only 5 numbers in length. Warning it does...

The CCC shows how fast your investments in inventory and other resources are being turned into cash from sales.

Can you pay your bills? The Quick Ratio will tell you. A company's Quick Ratio illustrates its ability to pay bills in the short term.

The fifth graph in my dashboard series is EBIT compared to Interest Expense. EBIT/Interest Expense ratio is also call the Interest...

Inventory turns is a pretty common metric so chances are this metric is not new to you. This graph does add a target line shown as a...

Never underestimate the power of a visual representation of your company's data. I have long been interested in how people learn....

We are now at day #2 of my series of graphs for a custom dashboard. I have spent a lot of time selecting the right metrics, the right...

Each day for the next 8 days or so, I am going to write a blog post about a particular graph I created for this dashboard. My goal with...