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.
It’s no secret that being a power user in Excel has its perks. Research shows that users who truly know how to use the power of Excel can potentially increase their salary by up to nearly $4,000 per year (dependent on their career). If you don’t believe me, have a look at this awesome infographic from Skilledup showing you how you can benefit from learning Excel. (more…)
Excel has many different tools that can be made more efficient or optimized simply by combining different concepts, tools or functions. Of course, there is no exception when it comes to Excel slicers. By default and out of the box, Excel slicers are made to provide you with the option to filter any field within a pivot table or a standard table using a visual selection tool. This tool allows the user to select any value and will then filter your entire pivot table or table by the value selected (note: you can also select multiple records for any given slicer as well). I will mention that unfortunately, out of the box, Excel slicers are available only in Excel 2010/2013. Let’s have a deeper look at what you are going to learn in this premium Excel slicer tutorial. (more…)
It has been far too long since I last posted on my blog. Between removing the popcorn ceilings throughout our entire upstairs of our home and just the general craziness of the holiday season, I’ve had very little time to do anything. One of my goals in 2015 will be to try and post once a week to my blog. That seems like such an easy feat but for some reason I always seem to struggle to stay consistent in getting the content out on such a reserved schedule. That all being said, I’m excited to get back into the swing of things and today I’ll be showing you how you can use the option button form control in Excel to control your dashboard number formatting. (more…)
