Optimize Daily Usage of Microsoft Excel
Recent research by Burning Glass revealed that nearly 8 in 10 middle-skill jobs now require digital proficiency – and jobs that require digital skills pay an average of 18% more than those that don’t. Essentially, the more literate you are digitally, the more money you will make. This means paying extra attention in class (instead of skipping it) might actually benefit you in the long run. If classes aren’t a viable option, here are seven beneficial skills to help switch up your tech game:
Easy as pie Charts
If you’d still like stakeholders to continue investing in your business, bombarding them with endless numbers and decimal points might not be the wisest thing to do. It might be better to compile the data into a comprehensive chart. Enter the Recommended Charts tool that offers a basic visuals that depict the latest data trends. More than one set of numbers? No problem, since you can insert multiple charts onto one sheet. After entering the data into the column headers, head to Insert > Chart > Chart Type and choose whichever one you’d like.
This tool helps you highlight any points of interest within your dataset, for example, you are presenting the latest numbers on project efficiency – any numbers lower than 80% are highlighted in red, making it easier for everyone in the office to not only see but also understand the dataset. If red isn’t your favorite color, the formatting is fully-customizable. Select the cell, click Home > Conditional Formatting > Add and voila!
Lessen the time needed to sift through and compile numbers from small data sets while also reducing time needed to create charts. Select the data, then click on the icon in the bottom right corner and bring up the Quick Analysis menu – this comprises a variety of tools such as formatting, charts, tables, totals and Sparklines.
After Excel picks up on the pattern within your data, Autofill fills in the other rows and columns for you. This saves you time by removing the need of having to manually enter row upon row of data. Just click and hold the lower-right column of the cell and drag the column the down.
After making yourself comfortable, allow this Microsoft Powerpoint-compatible data exploration and visualization tool to help decipher large datasets to create interactive, presentation-grade reports. With Power View, not only are you saving copious amounts of working time but also minimizing any human errors that could affect the accuracy of the report. For Excel 2013, click Insert > Report.
When it comes to data analysis, Pivot Tables might be one of the most powerful yet intimidating tools in Excel’s arsenal. Summarize large amounts of data in lists or tables without having to use a single formula. Head over to Insert > Pivot Tables and select the data range, then select the fields in the top-half of the right-hand sidebar to generate the table.
If you think using Excel was challenging, try working across multiple sheets and workbooks, now that’s a challenge. With the help of VLookUp, you can create reports and/or summaries by collating data from the multiple sheets. For example, sales professionals can pull information on item descriptions, prices, inventory etc. without having to endlessly wander between rows and columns. Start off by selecting the VLOOKUP formula in the formula menu, then enter the cell containing the reference number. Then enter the range of data you want to pull the data from, the column for the data point you’re looking and click either “True” or “False”.
It’s safe to say that Excel is one of the most commonly used business software on the market. And yet not everyone is able to fully utilize it. For any questions on the previously mentioned, or other features on Excel give us a call and allow us to help elevate your user status from beginner to pro.