excelhelp

If you tend to avoid venturing away from Excel’s home tab, where you feel most comfortable, you are missing out on some features that could make your life easier. The Excel 2016 Data Tab, for example, is packed with useful functionality. In this post, we will review the functionality available in the “Get & Transform,” […]

Usually there is a silent lament mixed with anticipated joy in the business industry when there’s an upgrade to the Microsoft Excel application. New software or an upgrade typically means that a change has been made to make your work life a little easier. However, the actual result can be of the contrary. Users have […]

The VLOOKUP function is one of the staple functions that Microsoft Excel users rely upon for finding values in a table. With the VLOOKUP function, a value can be looked up in the leftmost column and a related value can be returned from another column. The Syntax for VLOOKUP is VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup […]

Excel users frequently have a need to lookup data in one spreadsheet and use it in another. To make this job easier, Excel offers built in functions for finding information: INDEX, MATCH, and VLOOKUP. The advantages and disadvantages of these functions are presented below. INDEX INDEX returns a value from a range or an array […]

Imagine that you’re 12 worksheets into a financial plan and you need to sum all the subtotals from each worksheet. The thought of creating some long formula that will probably need to be changed later may make you cringe. You know there must be an easier way to do this and, fortunately for you, there […]