ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   keep track of gift certificates sold (https://www.excelbanter.com/new-users-excel/45220-keep-track-gift-certificates-sold.html)

ACharlene

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

Anne Troy

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





All times are GMT +1. The time now is 11:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com