UserForms in Excel 2007 and Excel 2010 allow you to add fully configurable dialogue boxes or User Interfaces to your spreadsheets. They are easy to use, reduce typing errors, save time and look great.
Microsoft Word has become the standard word processor for business use, but with it's functionality and ease of use it is also a powerful tool for the home user.
Using List Boxes in Excel 2007 and Excel 2010 you can create visually appealing and very easy to use boxes containing lists of items from which users can select one or multiple items.
Bubble charts created in Excel 2007 or Excel 2010 allow you to show data in three dimensions in a visually stunning chart. This can then be saved as a template to be used to create additional charts.
How to Add a Check Box in a Microsoft Word Document. A useful guide to how to add a check box to a number of Word documents, including lists, questionnaires and surveys.
These are the commands you will find when using the Insert Menu of Excel program. These useful commands will help you navigate around the document you are working on easily and efficiently.
Guide for creating to do lists in Excel 2007 / Excel 2010 using Check boxes and Combo boxes. Use Conditional Formatting using formulas and cell values with icon sets to add visual impact to your list.
A Speedometer, Dial or Gauge chart in your Excel 2007 / 2010 spreadsheet will look impressive, especially in a dashboard. It uses a Doughnut chart and Visual Basic code to create a moving needle.
Though rarely used, it is important to know much about these two menus. There are some vital commands in both that you need to know as an Excel Program user.
Using the Left and Right functions in Excel will make you much more efficient. They are a great way to extract data from inside a cell.