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.