In this article we will show you how to give a good-looking initial formatting to an Excel spreadsheet. Please feel free to download the spreadsheet files we will use in this article: This is how a blank sheet looks like when you open a new Excel file. What we...

INDEX and MATCH are two of the most interesting Excel functions. The INDEX function can return an item from a specific position in a list. The MATCH function can return the position of a value in a list. The INDEX / MATCH functions can be used together, for the...

Lookup Functions VLOOKUP and HLOOKUP are among the most frequently used tools in Excel, because they allow users to transfer large quantities of data based on a given criterion. Please feel free to download the spreadsheet files we will use in this article: In the picture we have here,...