Category: LEARN EXCEL SHORTCUTS

27+ Ways to Teach Yourself How to Become the Excel Guru Everybody Relies On

  Why is it so important to become an Excel guru? Because everybody in the world uses Excel. You can either be the person asking for help or you can be the person helping. The best part about being an Excel guru is that you can bring your skills with you wherever you go. Even if where you’re going isn’t hiring you for your advanced Excel skills, it’s a great icebreaker and you’ll quickly become everybody’s new best friend. Here’s a mini library of ways you can teach yourself how to become the Excel guru that everybody relies on....

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

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

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

Read More

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

Read More