Microsoft Excel - How To Automate Spreadsheets with Conditional Expressions and Lookup Tables in Excel 
 
2/3/2010 
ALP Recording 

Click on the image above to watch webcast replay.

 Class Description

The IF function is one many people shy away from, but this is one function that will truly make every Excel user's life much easier. Excel's VLookup is a handy tool that helps you compare data in two spreadsheets.

In this class you will learn how to:

  • Automate decision-making in your spreadsheet using the  IF Function.
  • Use the IF function to test a value in a specific cell to see if that value meets a certain condition.
  • Automate data retrieval and control in your spreadsheet with the VLookup Function.
  • Use the Lookup tool to import data from one spreadsheet to another for comparison purposes.
  • and more!

 Class Handout

 Other Materials of Interest

12359 Sunrise Valley Dr, Suite 130, Reston, VA 20191
©2009 Brittenford Systems, Inc.