The Simplest Ways to Make The Best of a Sparkline in Excel
How do you make the best of a sparkline in Excel? Well I've decided to answer that question in this post. Excel sparklines are ideal for quickly plotting trends especially when you are looking at a data set / series or a report. There are several features that you...
10 Ways Excel Pivot Tables Can Increase Your Productivity
When I first started to learn how to use Excel Pivot Tables, I'm not going to lie, I was a little intimidated. At the time I really wasn't certain about how and why I should be using them to analyze and summarize my data. Because I was a newbie I analyzed my...
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...
Creating Pivot Tables 101: A How-To InfoGraphic
You know the saying, "a picture is worth a 1000 words"? Well, I'm hoping that this post can convey to you in a quick, easy and visual fashion how to create a pivot table. Please do not be shy and share it with everybody you know - or just post it on your social media...
3 Smart and Simple Tab Shortcuts To Make Your Life Easier
As humans, we are always looking for smarter, better and quicker ways of doing things - especially the repetitive and often annoying day to day tasks. There are days where we quite literally wish we had a monkey by our sides to perform these tasks, allowing us to...
5 Incredible Number Formatting Tricks That Will Impress Your Boss
I know what you’re thinking. What’s so incredible about number formatting? I can honestly say that this part of Excel can allow you to do some pretty amazing things with data display and this post might help you discover how to come up with some other impressive ways...