Seven Useful Microsoft Excel Features You Can’t Use

Microsoft Excel provides useful data manipulation features that are little used, such as pivot tables, indexing and collation, and conditional formatting. If you’re just using Excel for summarizing and charting, this figure may show you some other tools to help you become the spreadsheet ninja you’ve always wanted to be.

Sure, real spreadsheet ninjas are probably already using these features on reg, but let’s say you’re taking training and just want to improve your Microsoft Excel skills. This drawing from the STL folks won’t show you exactly how to apply every Excel feature to your charts, 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 work with large amounts of data, give it a try.

Excel Tricks That Will Impress Your Boss | STL


Leave a Reply