If you’ve mastered the basics of Microsoft Excel and you’re looking to boost your spreadsheet skills, this visual guide explains some useful tips and shortcuts you may not have tried.
This graphic, from Quill, features five tips and shortcuts you can use to become spreadsheet pro. You’ll learn an easy way to quickly copy data and formulas down an entire column, have Excel speak numbers as you type them so you never accidentally enter an incorrect value, and freeze panes so you can scroll down massive spreadsheets and still reference data easily. You’ll also learn how to create simple data projections with the Forecast function, and use pivot tables to analyse and summarize large amounts of data. You might know some of these tips, but even if you’re an Excel master, there’s still always something to learn. Check out the full graphic below.