Coupon database7/11/2023 On August 12th you can simply trash all the coupons in this envelope and delete them from your database. ![]() Let’s say an envelope houses coupons that expire from –. While this may require some manual sifting through coupons, the number you have to search through is greatly reduced from splitting them up into one-week expiration periods.ĭon’t forget to delete coupons out of the database once you’ve removed them from their envelopes!Īn additional benefit of the database is that it’s easy to trash expired coupons. If you are new to Excel, or simply don’t use it that often, the filter option is found under the “Data” grouping on the ribbon:įinal Step: Once you’ve identified the coupons you are going to use, all you have to do is retrieve them from the various envelopes they are stored in. Obviously the biggest advantage of this database system is being able to filter the data and find specific coupons quickly and efficiently that you are going to use on your next shopping trip. Unfortunately in the below case these coupons are for separate products. If you filter on Purina for brand, you can see there is a manufacturer and Target coupon. This will bring up all the coupons you have for cheese, including the details of the coupon.Īs you can see below, the only coupons in our database being displayed are coupons for cheese:Īs you may know, some stores let you use both a manufacturer and store coupon on products. If you need cheese, all you have to do is filter on the “Type” heading for cheese. ![]() For example, you would have an envelope that holds all your coupons that expire –, –, and so on.Ĭongratulations, you’ve successfully sorted all your coupons using an Excel database! Step Three: Once you enter all the coupons, sort them in envelopes that have expiration dates spanning a given week. Below is an example of the database once populated (click image for full-size image): This has to do with how the physical coupons are sorted. Once this data is entered, the envelope location column will automatically populate. The following data needs to be populated for each coupon: Step Two: Enter all your coupons into the databaseĮntering the coupons goes relatively quickly once you get the hang of it. Our solution was creating a database so we could easily sort through the coupons we have and discard those that have gone out of date. That’s why coupons can be effective for advertisers very few will take the time to learn how to maximize savings by using them. Obviously everyone wants to save the most money with as little time or effort as possible. ![]() One problem we ran into as we got more serious about couponing is the fact that the more coupons you have the harder it is to manage and organize them. If you count clothes, toiletries, pet supplies, and food from restaurants we’ve saved much more than $1,000, and that’s just shopping for two people. In that time we have saved in excess of $1,000 on groceries alone. My wife and I started to coupon a little over a year ago.
0 Comments
Leave a Reply. |