Excel has some pretty neat tricks but auto-fill is definitely one of our favourites!
Auto-fill saves you a lot of time by filling in the rest of a sequence without you needing to type anything.
For instance if you were trying create a spreadsheet and need all of the months lined up in a row, you only need to type in ‘January’ and use auto-fill to gain the other 11 months.
You can use the auto-fill feature by clicking, holding and dragging the bottom right corner of the cell downwards. Check out our screenshots below for visuals!
Filtering is handy to have on an application like Excel where there’s usually so much data to process.
By highlighting your data and selecting the ‘Filter’ option in the ‘Data’ tab, you’ll notice that the top cell of your data will be given a drop down menu.
This drop down menu lets you filter your data alphabetically, by colour, by selection or even with text filters!
Below are some screenshots of filtering actually in use!
In Excel, it’s easy to write the same thing twice when you’re working with so much data and using a wide selection of cells.
Accidentally adding duplicates to a list is a common mistake, but can also be problematic when trying to obtain correct results on a spreadsheet.
Excel offers a ‘Remove Duplicates’ feature which you can use to completely erase any duplicates that you missed!
So now you can type in your data without the worry or making a mistake, just simply highlight your data, and select ‘Remove Duplicates’ in the Data tab.
In the screenshot below, you’ll see that we’ve purposes duplicated the employee ‘James’ to show you how to remove duplicate feature works!
So there are our top 3 Excel tips! We hope they help you in your future Excel use!
If you would like to see more Office 365 and Windows 10 tips, check out our Top 3 Cortana Tips from last week!