10 tips for mastering Excel
![ramsac Artboard 3](https://www.ramsac.com/wp-content/picasso/2021/10/ramsac-Artboard-3-650x280.webp)
Posted on January 2, 2020 by Louise Howland
The first version of Microsoft Excel was introduced in 1985. 35 years later it is now used by millions of us on a daily basis, in a plethora of job role. And yet few of us have ever received any formal training in its use. This blog provides ten time-saving tips to help the uninitiated up their Excel game and is based on my own favourite tools and shortcuts that I use on a daily basis.1. Select all
As someone who sorts data quite often, I find using the select all button really helps to ensure you are sorting on all columns and rows. There is nothing worse than spending hours working on a large dataset only to realise somewhere along the way you sorted on just some of the columns and all your data has become misaligned. To select all the cells in a table simply click the triangle in the corner of your spreadsheet![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-tip-1.webp)
2. Freezing columns and rows
When dealing with large spreadsheets full of data it is sometimes hard to remember what information is in each column, but by freezing the top row, you are able to scroll down your spreadsheet while the top row remains stationary. To do this click on the view tab at the top of excel then Freeze panes, you can then determine whether to freeze the top row, first column or multiple columns depending on your current selection.![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-tip-2-300x207.webp)
3. Autofill and Flash fill
These are both great time savers, as they make filling in cells with the same data or a pattern much easier. For example, if you type the date in one cell and then want to carry that on down through the column, you start by typing the date then move the cursor to the bottom-right corner of the cell. When a plus sign appears (+), click and drag down to select all the cells you need to fill. You can also highlight the cells you want to fill by clicking the fill button of the Home tab, this will give you various options including a flash fill.![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-tip-3.webp)
![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-tip-3a-273x300.webp)
4. Pivot Tables
Pivot tables are a great way of summarising data from complex and lengthy spreadsheets. To create one it is important that all columns and rows are properly titled then click PivotTable on the insert tab, which will create a new sheet on your spreadsheet containing the PivotTable wizard, where you can build your table. If you are unsure where to begin Excel can recommend a PivotTable for you. Both options can be found on the insert tab.![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-tip-4.webp)
5. Wrap text/merge and center
I have grouped these two tips as I think they both fall into a similar category. Let’s start with Wrap Text, this can be used where the contents of the cell is longer than the width of the cell. By wrapping the text you can display longer text in a cell without it overflowing to other cells. It displays the cell contents on multiple lines, rather than one long line. To wrap text simply chose the cell you want to wrap and on the Home tab chose the Wrap Text button. Below is an example of the wrapped and not wrapped text.![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-tip-5c.webp)
![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-tip-5b.webp)
![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-tip-5e.webp)
![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-tip-5d.webp)
6. Text to columns
I use this functionality all the time, it is very useful when you have multiple rows of data in one column that needs to be split across multiple columns. See below for an example of before using text to a column and after.![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-blog-tip-6-image-1-300x129.webp)
![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-blog-tip-6-image-2-300x102.webp)
![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-blog-tip-6-image-3.webp)
![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-blog-tip-6-image-4-300x249.webp)
7. Concatenate data
Concatenation is really the reverse of the Text to Columns functionality it is pulling data from multiple columns into one column (and I use it just as often as Text to Columns!) To concatenate data you need to choose an empty field that you would like your data to be in and then click on the function button. You can then search for the function by typing Concatenate.![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-blog-tip-7-image-1-300x221.webp)
![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-blog-tip-7-image-2-300x275.webp)
8. Removing duplicates
This is a useful tool when working on a large data file where you want to remove duplicate values from a column. To do this highlight your data click on the Data tab and click on Remove Duplicates. This then brings up a wizard where you can identify which column you want to remove duplicates from, once you click ok excel will remove any duplicate rows from your data.![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-blog-tip-8-image-1.webp)
![](https://www.ramsac.com/wp-content/picasso/2022/01/excel-blog-tip-8-image-2-1-300x202.webp)
9. Highlight duplicates
This is a useful tool when you don’t want to remove duplicates from![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-blog-tip-9-image-1.webp)
10. Charts/graphs
![Excel view from Screnshoot](https://www.ramsac.com/wp-content/picasso/2021/10/excel-blog-tip-10-image-1.webp)
![](https://www.ramsac.com/wp-content/picasso/2022/01/Anywhere-any-time-Banner-Draft-15-300x45.webp)