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 assure you however that there are a few tricks in here that will likely get you excited about going to work tomorrow to show it off to your boss. Let’s dive right into the videos that are going to make your workweek a little more bearable by making you look like an Excel guru.
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 help people learn. This week I’m going to run a quick experiment and I’ll be posting a 60 second video every night for the remainder of the week on my YouTube channel just to see if my wife was actually right (and yes I know, she is normally right about everything). I’m going to see what kind of feedback I get from the experiment and if it is positive, I’m going to try and run more short 60 second videos throughout the week, every week.
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 accounts and maybe even your office cork board (do they still exist?). (more…)
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 spend our time doing things that are of actual value. Thankfully Excel offers tab shortcuts that help us easily navigate between workbooks, change the name of workbooks at the drop of a hat and enter formulas, formatting and other Excel goodies onto multiple sheets all at the same time – can you believe it! In this post we are going to look at 3 smart and simple tab shortcuts to make our lives easier and really, just make our day way better. (more…)
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 shape, size and format you wanted.
I’m going to leave this GIF image with you to teach you how you can do this in a few easy steps. Enjoy!
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 current row. That being said this tip is great if you are a heavy mouse user and just love to click things- so here it is. When you are on any cell, you can double click the top/left/bottom/right of your cell to get literally to the beginning or end of that row or column. You need to make sure that you have the 4 point cursor available when hovering over either of the sides of your cell. Here is a quick gif image to show you how this works. Note that the image below is only showing you how to navigate from top to bottom (and from bottom to top) of a column but you can you with the left or right hand sides of the cell to go to the beginning of the row or to the end of the row.
I hope you enjoy this tip as much as I did and I already forget where I came across this but it could be a life changer for some of you and I hope it is.
