Using Icon Sets in Excel

To create a table that displays a colored object rather than a value follow these steps:

1. Create a table.
2. If your table will be a yes or no then use either a zero or one as the value.
3. Select all values (zeros and ones).
   
4. Click on Conditional Formatting in the Home tab.
5. Move your cursor over Icon Sets and then select an Icon type.
6. To have only the icon displayed, click on Conditional Formatting in the Home tab
7. Click on Manage Rules.
8. Click on Edit Rules
9. Select the Show Icon Only check box in the lower right of the form.

Watch this video to see how it's done.

Excel 2003 Menu: UBit Menu

Tired of the 2007 Microsoft Office Ribbon? Want your 2003 Office Menu?
Go to http://www.ubit.ch/software/ubitmenu-languages/
Install the Ubit menu and then open an MS Office product like Excel.
I believe this is a temporary fix and I would recommend that everyone learn how to get around in version 2007 of Microsoft Office with the new Ribbon.

Use an Input Form in Excell

If you need someone to input information into Excel, but they are not Excel savvy create a Data Input Form. This Data Input Form will allow a user to input data easily, similar to a form in Access.
First, you will need to build your Excel workbook as you would like it formatted, organized, and formulated to connect with other worksheets inside your workbook.
After you have created your workbook with all the necessary columns follow my video tutorial.

1. Click on the Customize Quick Access Toolbar on the Quick Access Toolbar at the very top of the page to the left of the MS Office button.
2. From the drop down menu click More Commands...
3. From the Choose commands from drop down box select All Commands
4. Scroll down to Form... in the commands box below
5. Select Form... and then click the Add>> button and click OK
   
6. Now click the Form button on the Quick Access Toolbar and then you'll define the form according to how you created your worksheet.
7. Input your first data set.
8. Click the New button and that data now appears on your sheet.