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...
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...
How to Create a Button Link in Excel – Link Between Worksheets
When we are building dashboards in Excel, we often want to build links between worksheets or spreadsheets. To do that we can use hyperlinks. This was kind of a life changing concept to me because it allowed you to build and style your own buttons into whatever...
Excel Navigation Shortcut: Double Click Your Way to Faster Spreadsheet Navigation
This is an incredibly easy and simple tip and an Excel navigation shortcut that I quite honestly had no idea existed until just recently. I've always used Ctrl + left/right/down/up arrow to quickly get to the top/bottom of my current columns or start/end of my...