Seven Advanced Excel Features 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 Useful Microsoft Excel Features You May Not Be Using

Have you subscribed to Lifehacker Australia's email newsletter? You can also follow us on LinkedIn, Facebook, Twitter and YouTube.

Trending Stories Right Now