We’ve included four easy Excel spreadsheet tips to make your working life easier than ever thanks to a great link which makes crunching numbers a breeze. Check it out here:  10 Most Useful Microsoft Excel Tips (filtered.com)

1. Filters Explore data in a table quickly. Filtering effectively hides data that is not of interest. Usually there’s a value (e.g. blue cars) that you’re looking for and Filters will bring up those and hide the rest. But in more modern versions of Excel, you can now also filter on number values (e.g., is greater than, top 10%, etc), and cell colour. Filtering becomes more powerful when you need to filter more than one column in combination e.g., both colours and vehicles to find your blue car. Alt D F F is the shortcut (easier than it sounds – give it a go). Conditional Formatting and Sorting serve related purposes.
2. Extend formula down. Get the formula right once and Excel will churn out the right calculation a million times. The + cross hair is handy. Double clicking it will take it all the way down if you have continuous data. Sometimes a copy and paste (either regular paste or paste formulas) will be faster for you.
3. Add multiple rows. Probably one of the most frequently carried out activities in spreadsheeting. Ctrl Shift + is the shortcut, but actually it takes longer than just right-clicking on the row numbers on the left of the Excel display. So Right Click is our recommendation. And if you want to add more than one, select as many rows or columns as you’d like to add and then Right Click and add.
4. Screenshot insert. Excel makes it ultra-easy to take a screenshot of any other open program on your desktop and insert it into a worksheet. Just go to Insert tab, select Screenshot, and you’ll get a drop-down menu displaying a thumbnail of all the open programs. Pick one to insert the full-sized image. Resize it as you desire.