Five Extremely Useful Microsoft Excel Tricks [Infographic]

Five Extremely Useful Microsoft Excel Tricks [Infographic]

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.

Excel Tips, shortcuts, and hacks to streamline spreadsheets like a pro [Quill]

Five Extremely Useful Microsoft Excel Tricks [Infographic]

The Cheapest NBN 50 Plans

Here are the cheapest plans available for Australia’s most popular NBN speed tier.

At Lifehacker, we independently select and write about stuff we love and think you'll like too. We have affiliate and advertising partnerships, which means we may collect a share of sales or other compensation from the links on this page. BTW – prices are accurate and items in stock at the time of posting.