Common Applications for Microsoft Office

I often see people asking similar questions. Rather than provide every single answer here, I thought I'd provide a quick overview of what I feel is the best method for producing certain types of applications, and how to proceed.

Please check the list of downloads at to see if there are any downloads that appeal to you. Wherever possible, I have tried to denote that there's a related free download available. Our downloads and this page may be updated from time to time, so check back often.




Cookbook or Recipes Collection

Use Word; try to use a set amount of recipes per page, such as 1 or 2. Make sure you apply Heading 1 style to each title so you can easily create a Table of Contents.


Invoices or Order Forms

Use Excel with drop-down data validation and  VLOOKUP. Try the tutorial.


Raffle Tickets

Use Word with Excel and mail merge.


Membership Directory

Use Excel to store the data and mail merge to get the data into membership directory layout. debuted on May 26, 2005. provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved