If you’re like many accounting managers, you’re open to any Microsoft Excel tips and tricks that come your way, especially with the release of Microsoft Office 2019 and continual updates to Office 365 in the cloud.
Excel is the preferred tool for budgeting and planning across accounting and finance functions. Here are some quick tips for excel to bring more agility, functionality and usability to your Excel spreadsheets.
Excel now has the power to finish your tedious info-typing session. Just start typing in the column to the right of your data.
Excel will then gather suggestions to fill the rest of your cells after typing a few examples. To accept Microsoft’s suggestions, press enter.
Sparklines are a built-in feature of Excel that allows you to display small charts inside individual cells. These can be line charts, bar charts or simple win/loss charts. To create a Sparkline chart, select the range of numbers you’d like to include, click the “Insert” menu, then choose one of the chart options. Select a location range, which must be located along a single row or column in the same worksheet as your data range. Sparklines can help you easily display trends in your data in a compact format.
To efficiently switch between the cell data and formula, use the Ctrl+tilde (~) keystroke. This allows you to rapidly check formulas when working in a large spreadsheet.
Select any cells in your data range/ table and then press ALT+F1 on your keyboard. Now you have an instant chart
You can turn data cells into a table quickly! All you have to do is click within the parameters of your data and press Ctrl+T. Now you have an instant table displaying your data.
There you have it! You are ready to be a rock star at your next accounting presentation! Check back soon for more easy tips and tricks for accounting and finance jobs.