Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
skus in columm a for each sale, qty. of skus sold, each sale in co | Excel Worksheet Functions | |||
Help with keeping track of payments | Excel Discussion (Misc queries) | |||
HELP!!! EXCEL TRACK CHANGES CONUNDRUM! | Excel Discussion (Misc queries) | |||
Teplate to Track sales of multiple products on per client basis. | Excel Discussion (Misc queries) | |||
I need to create gift certificates in excel how do I number each . | Excel Worksheet Functions |