If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
keep track of gift certificates sold
I'm new to Excel and would like to set up a way to keep track of gift
certificates sold (date, amount, who for, who from, therapist), date when it was redeemed, etc. Can anyone offer any advice? I am using Microsoft Office Excel 2003. Thank you in advance for any advice or suggestions offered. Charlene |
#2
|
|||
|
|||
In Row 1, across the top, type your column headings: date, amount, who for,
who from, therapist Click on cell A2 and hit Window--Freeze panes. Click on Column A, and Format--Cells and choose a date format you like. Click on Column B, and Format--Cells and choose a number format you like. Start typing in your gift certificates. Were you looking for something more than that? ************ Anne Troy www.OfficeArticles.com "ACharlene" wrote in message ... I'm new to Excel and would like to set up a way to keep track of gift certificates sold (date, amount, who for, who from, therapist), date when it was redeemed, etc. Can anyone offer any advice? I am using Microsoft Office Excel 2003. Thank you in advance for any advice or suggestions offered. Charlene |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Track Changes Won't Stay Off | Wyoh | General Discussion | 1 | April 13th, 2005 10:20 PM |
Fade sound track on last slide in series | Fred Worthington | Powerpoint | 1 | March 11th, 2005 09:22 AM |
Disable Track Changes problem | Melissa | General Discussion | 1 | October 7th, 2004 09:34 AM |
Weird things with track changes | pd | New Users | 4 | July 15th, 2004 03:05 AM |
Formula for average units sold based on # days in month sold | John Sebastian | Worksheet Functions | 1 | December 29th, 2003 07:46 PM |