Tutorial Home > Software > Office > Microsoft Office 2000 Projects > Order Forms

Order Forms
Suppose you want to develop an easy way for your customers to order your products, but you're not quite up for creating an online ordering system on your Web site. You can set up a simple order form in Excel that you can e-mail to customers. The form already includes the required formulas so all the customers need to do is choose which products they want. In this series, you will create a simple online form that uses the LOOKUP function to calculate prices based on criteria you set.

  Tutorials
  Preparing a Blank Workbook
  Save and Close the Workbook
  Setting up the Worksheet
  Entering Labels
  Entering Values
  Set Up the LOOKUP Table
  Select the LOOKUP Function
  Enter the LOOKUP Formula
  Modifying the Formula
  Adding Customer Information
  Inserting Graphic Elements