List of online resources to help home study learners improve their knowledge of Microsoft Excel 2010. Includes official Microsoft Office links and videos.


Microsoft Online Training

Plan payments and savings in Excel 2010
Learn how to figure out payments and savings by using formulas in Excel.


The IF function: what it is, and how to use it
The IF function checks to see if a condition you specify is true or false. If true, one thing happens; if false, something else happens. For example, if you use the IF function to see if amounts spent are under or over budget, the result for True could be “Within budget,” while the result for False could be “Over budget.”


Understand data at a glance with conditional formatting
Sometimes it’s hard to read and interpret data by scanning rows and rows of information. But you can use conditional formatting to make certain data stand out, helping you to analyze data, and to identify patterns and trends.


VLOOKUP: What it is, and when to use it
Learn how to use VLOOKUP to look up a value you want to find in an Excel list or table. Using VLOOKUP is similar to looking up a person’s name in a telephone book to get a telephone number. VLOOKUP looks at a value in one column, and finds its corresponding value on the same row in another column.

Save time by creating and running macros in Excel 2010
Do you find yourself doing the same actions over and over again in your spreadsheets? Did you know you can create macros so that Excel can do that repetitive work for you? Macros are sets of instructions based on actions that you record while you work in your spreadsheet. After you record a macro, you can use it again as the need arises.