5 Of Our Best Excel Tips & Tricks

Microsoft Excel tips and tricks

In a world where data is king, Excel is pretty much a mandatory tool that every employee should be able to navigate with confidence. Released back in 1985 on the Macintosh, it’s fair to say that Excel has come a long way since then. But, do people really know how to use Microsoft Excel or do they continue to underutilise it?

Well, the funny thing is that both beginners and more experienced users tend to discover new Excel tips and tricks on a regular basis. However, that doesn’t mean you’ll find out all the Excel tricks immediately; you’ll have to continue to work on learning more.

So, that you can know how to use Microsoft Excel a bit better, we’ve highlighted 5 of our best tips and tricks for you to take a look at. Read on to discover some Excel tips you might not have known before or visit our Career page to discover more of our blogs.

Flash Fill makes data entry much quicker

Are you someone who hates manual data entry but hasn’t heard of Flash Fill? Well, there’s no doubt that you’re in for a pleasant surprise. Flash Fill was introduced to Excel in 2013 and assists you when inputting information by suggestion values in successive boxes.

A good example of how Flash Fill can help is when you may be inputting dates, names, or email addresses into your spreadsheet. The Flash Fill feature will work out any patterns that are forming and pre-emptively add in what you’re looking for.

So, if you add a lot of email addresses and the employee names to go with them, Flash Fill will remember that in the future and suggest names for you when you add in an email address.

Select all with or without using a keyboard shortcut

If you’ve been holding down the left mouse button and dragging your cursor across the screen to select all of your cells, you’re doing it the long way. Thankfully, two quick and easy methods exist in order to select everything across your Excel spreadsheet.

First, try hitting Ctrl + A on Windows or Cmd + A on Mac to quickly select everything. Secondly, take a look at the grey box to the left of column A and just above row 1; if you click that then you’ll also get the same result.

Now, you’ll almost certainly be saving yourself time and making sure that you never accidentally miss out on selecting part of your spreadsheet.


Open multiple Excel files at once

Are you sick and tired of having to open an Excel spreadsheet, minimise it, open another one, and so on? Luckily, there is a quick and easy solution when it comes to opening multiple Excel files at once. All you need to do is select every file you want to open and then hit the Enter key on your keyboard.

Gain insight with One-Click Forecasting

When you’ve complied any amount of data it’s only logical that you might be thinking about forecasting ahead. Being able to make an accurate projection could be the difference in making a huge profit but it’s not as hard as you may think.

Excel introduced One-Click Forecasting back in 2016 and its enabled us to make future projections much more effectively ever since. After selecting columns on a table, the Once-Click Forecasting feature can be utilised to display a number of different projections in a line or bar chart.

But, the best thing about One-Click forecasting is the fact that you can customise it so that you can get the most out of it for your requirements.

Simultaneously copy and move your cell data

You probably know how to move a column of data in an Excel spreadsheet, right? In case you don’t, select the data cell you want to move and move your arrow pointer to the border of the column and wait for icon to change to a crossed arrow. After that, all you need to do is drag the column to wherever you want it to go.

So, what do you do if you’d like to copy the data in the cell you’re looking to move? Simply press the Ctrl key just before you drag the column and Excel will automatically copy all of the data you’ve selected.

Have you still got unanswered questions about how to use Microsoft Excel or are after more Excel tips? For further information, contact us now and speak to a friendly member of our team. Or, if you’d like to find out more about Saxons Microsoft Office course and how it can help you, visit the Learning Solutions page now.