Microsoft Excel is one of the most popular programs around. It is used in home, schools and businesses all over the world for everything from household budgets to product inventory and payroll. Most office roles require some level of expertise in Microsoft Excel, so it’s a good program to be familiar with to improve your job prospects. Most people have a basic understanding of Excel, but the following five Excel tricks can help you get ahead of the curve!
If you are presenting data to stakeholders, you are going to want to make it look professional by creating a visualization. The Recommended Charts tool offers users a way to create a basic chart, which can paint a clear picture of the data trends that you are trying to demonstrate. In order to access this feature, select “Insert > Chart > Chart Type.”
This feature can be a huge time saver, because it removes the need to manually enter row after row of data. Using this tool, Excel is able to recognize patterns within your spreadsheet. Following these patterns, it will automatically fill in rows and columns for you. This feature can be found by clicking and holding the lower-right column of the cell and dragging down the column.
Power View is an interactive visualization tool used for interactive data exploration. This tool can quickly collate and analyse large datasets in order to create interactive reports that you can use for your next presentation or meeting. You can access Power View by selecting “Insert > Reports.”
If you are a sales professional juggling multiple spreadsheets and workbooks at once, VLOOKUP can help make sense of it all. This tool will allow you to collate data and bring all of your sheets together, creating intelligent reports and summaries. To use this tool, you need to summon the VLOOKUP formula in the formula menu and enter the cell that contains your reference number. Next, enter the range of cells you want to pull data from, the column number for the data point you want, and either “True” or ‘”False.”
This tool allows you to easily highlight points of interest within your dataset. You can use conditional formatting to highlight certain cells a different colour if they are below a certain threshold. This tool offers limitless customization options. To use this tool, select the cell you want to format and click “Home > Conditional Formatting > Add.”
Get in touch with Grade A if you want to learn any more handy Excel tips and tricks – our IT solutions experts in Ottawa are always happy to help!