Seven Microsoft Excel Tricks You Should Be Using [Infographic]

Seven Microsoft Excel Tricks You Should Be Using [Infographic]

Microsoft Excel is packed with useful data management features that don’t see a lot of use, like pivot tables, index and match, and conditional formatting. If you’re just using excel to sum and chart columns, this graphic can show you some other tools to help you become the spreadsheet ninja you always wanted to be.

Excel picture from Shutterstock

Of course, real spreadsheet ninjas probably already use these features on the reg — but let’s say you’re in training and just want to beef up your Microsoft Excel skills. This graphic from the folks at STL won’t show you exactly how to apply each Excel feature to your graphs, but they do show you how things like Waterfall Charts, Goal Seek and Flash Fill actually work, so you can try them out yourself. The next time you’re working with large quantities of data, give them a try.

Excel Tricks that will Impress Your Boss [STL]

Seven Microsoft Excel Tricks You Should Be Using [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.