Merging two Excel files using VLOOKUP function - Excel tutorial

Category: Excel tutorials > Functions - Difficulty:

If XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps.

The Choose function allows you to refer to different cells depending on the results of a cell. Often useful as an alternate to the IF function (especially if you are tempted to use nested IF functions).

Learn the basics of Excel 2000 and more including Customizing Excel, Formulas and Functions and Keyboard Shortcuts.

In this tutorial, you will apply formatting options to cells and prepare the sheet for printing....

This video tutorial shows how to use the imaginary function in Excel.