Category: EXCEL BEGINNER

101 of the Most Shared Excel Articles You Need to Read

Are you overwhelmed by the amount of Excel articles on the web? If you said yes, then we are definitely on the same page and I’m willing to bet there’s a few or many following behind us. Over the past couple of weeks I’ve set out to find the most shared Excel articles on the web and I’ve decided to put together a list showing you only articles that have been shared 100 or more times. I’ve created this list using an amazing tool called Buzz Sumo which allows you to find the most shared content on the web for...

Read More

8 Search Techniques You Can Use Right Now to Find the Best Excel Content On The Internet

You spend a lot of time navigating and searching the internet trying to find high quality Excel content. I know because I’ve been there and it always seems like it takes longer than it really should to find the exact feature, formula or solution to your Excel problems or questions. Trying to find specific Excel skills that you’re interested in learning can become quite a feat. I know and you know that there are a lot of great Excel websites out there with tons of information but sometimes it just comes down to getting your searches just right. In this...

Read More

Be More Valuable in the Office: 5 Ways to Increase Your Efficiency in Excel

When you’re first starting out in Excel, becoming efficient is an afterthought. Whether you like it or not, Excel seems to be the tool of choice for data manipulation, charting, reporting, and dashboards in nearly all workplaces simply for the fact that if you know how to use a mouse and a keyboard, you can learn how to use Excel. Excel becomes more and more powerful as you continue to use it and understand the available features. People love dumping there system data and information into Excel because of its flexibility. If you are here now, that means that...

Read More

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 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...

Read More

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 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...

Read More