Watch each week as I post a customized spreadsheet with all the sales and deals for Tremonton's two local grocery stores; Kent's and Ridley's.

Need to learn more about couponing and how to use coupons, click on the Couponing 101 tab below!

Pay It Forward: Want to host a couponing class? Contact me via my Facebook page and set one up!

Thursday, July 10, 2014

Tips and Tricks for Using My Weekly Deals Spreadsheets!!!!

Because I go to so much effort to create a spreadsheet each week with all the Kent's and Ridley's deals, I want to make sure that everyone who cares can use that spreadsheet in the most user-friendly way. To help with that cause, I have created a quick tutorial video to show you what I would do to manipulate my spreadsheet into something that is easy to take with me to the grocery store. You can certainly just look at the spreadsheet and possibly write down everything you need to know to take to the store with you. But if you want to print your list instead, watch this video to find out how:


Here are a couple more tidbits not listed in the video:
  • One thing I didn't mention is that I like to print my spreadsheets in Landscape rather than Portrait. You may also find that you need to adjust the margins, size, or page breaks to get your grocery list to print appropriately. If you don't know how to do that, please leave me a comment and I might make another video just for you! That being said, many of the settings you are going to be looking for will be under the "View" tab (switch the view to "page break preview" and you can adjust your page breaks) or the "Page Layout" tab (to switch from landscape to portrait). The "print" dialog box that comes up when you are ready to print will have several helpful options in it if you explore there. Just make sure to do a "print preview" before you actually print if you aren't sure that things are going to look just right (ie. the last column gets pushed to it's own page, so when you print you get just one column and lots of blank space on a page... what a waste!).
  • I mention in the video that Kent's and Ridley's are not accurately represented on the GrocerySmarts website. That is to say that Ridley's isn't listed AT ALL, and Kent's is listed but the ad is based off the Lee's ad and not everything matches up the way it should once you go into the store.
  • So, how do you know that my list is accurate? What I do each week is take the Kent's and Ridley's printed ad and I search the GrocerySmart's website to find matching deals. If I can't find a particular item listed, I simply leave it off my spreadsheet. So you might notice that my spreadsheets only contain about 95% of the printed ads, but that is still WAY better than using GrocerySmarts for these two stores. So, typically, I only get it wrong if GrocerySmarts gets it wrong.
  • If you are a keyboard person, like I am, and you don't want to "right-click" to copy and paste, you can also use the keyboard shortcuts of Ctrl C for copy and Ctrl V for paste (and Ctrl X for cut). Meaning, you hold down the Ctrl button, then press C to copy what is currently highlighted/selected on the screen.
Happy Shopping!

No comments:

Post a Comment