5 Intermediate Excel Practice Tips To Learn
Think you have a good grasp on the basics of Excel and looking for more information to practice on? Here are some intermediate level excel practice tips for you to consider when exploring the rest of Excel’s capabilities:
- Generating unique values
In cases where you need to have unique values filtered from your data, you should be making use of the Advanced filter feature. Select the data column and locate the data tab. Choose advanced so that the relevant window pops up. Choose copy to another location and specify the intended location using the area choosing button. Choose the Unique records option to generate unique values, which will function primarily by revealing the contrast between the original data and the data with unique values.
- Autocorrect
One of the most helpful nifty excel practise tips is to substitute the time wasted from typing complicated terms repeatedly by making use of autocorrect. This way, whenever you type in certain characters, it will autocorrect it to the complicated term instead. To access and start using this, go to your File tab. Choose options and locate your Proofing option. Once you have done that, choose Autocorrect options. Under the replace text with correct text, type in the needed information as you wish.
- Flash Fill
Apart from making use of autocorrect, Excel also has a pattern detection ability. If you have patterns in your data correction, Excel will automatically detect and fill in the rest of your data for you. But if you need to turn Flash fill on manually, you can do so by choosing the Data tab and selecting Flash fill or hold down CTRL and E. As a general recommendation- it’s best to allow flash fill automatically. You can do so by selecting the File tab and choosing Options. Once done, click advanced and click on the automatically flash fill box option to make sure it’s selected.
- Pivot Tables
The most popular of all excel practise tips are to make use of Pivot tables to create lists/tables as a means of data summary when there are large amounts of data to work through. This way, you won’t have to worry about using any additional formulas and slowing your spreadsheet down. Pivot Tables can be found under the Insert tab of your excel workbook. Make sure to make changes according to the requirements you need.
- Picture Compression
If you deal with images on a frequent basis, you may find that your excel file is slow to load and send in emails or servers. What you can do is to keep your workbook file size small so that you can send it across quickly. You can do so by compressing your images according to web viewing requirements so the images are at a lower resolution. Choose the file tab and hit save as. Under the options, choose compress pictures and adjust your resolutions accordingly in the relevant area.