Microsoft Excel 2013 has a host of special features that make navigating, organizing, researching and presenting data simple and efficient for users. But, with all those tools clattering around the old productivity tool chest, a few inevitably get lost. For instance, have you ever performed a VLOOKUP to peck out buried bits of information from a huge haystack of numbers? You probably know how to create Pivot Tables, but what about combining multiple spreadsheets into one super Pivot Table to access more of your reports faster? Or how about setting up a spreadsheet with conditional formatting so that data of a specific nature becomes recognizable at a glance? These special settings and more make up our list of Microsoft Excel 2013 Tips and Tricks You Need to Know.
Short for “vertical lookup,” VLOOKUP takes advantage of vertically-aligned tables to quickly find data associated with a value the user enters. If you know the name of a product, for instance, and you want to quickly determine its price, you can simply enter the product name into Excel and VLOOKUP will find the price for you. To the novice Excel user, however, setting up VLOOKUP can look like an intimidating process — but it needn’t be.