Girl Scout Cookie Tracking Spreadsheet Template
Excel Spreadsheets Help
by Nick
2M ago
My daughter is in Girl Scouts and her troop wanted to sell Girl Scout cookies for the first time this year. In order to sell Girl Scout cookies you need an adult to be the TCPC: Troop Cookie Program Coordinate. Or as my daughter said, "We need you to be the Cookie Daddy!" I figured all this meant was they needed someone to manage an Excel spreadsheet for all the cookie sales so I agreed. Little did I know what was in store as there is much more to it. First is all the training and webinars, background check, volunteer forms, etc. Then when it comes to finally sell cookies, there are no spreads ..read more
Visit website
2023 College Football Bowl Prediction Pool
Excel Spreadsheets Help
by Nick
4M ago
The college football conference championships were played this past weekend which means the 2023 NCAA college football bowl season is here again! Therefore, it’s time to make your picks and predictions about who you think will win each bowl game. One of the best times of the holiday season (other than giving and receiving gifts) is being able to talk trash to your relatives about their terrible bowl picks. This year has the added bonus of not just single bowl games but the tenth and final year of a four team playoff to determine the national champion. Starting in 2024 the college football play ..read more
Visit website
2023 NFL Helmet Schedule Spreadsheet
Excel Spreadsheets Help
by Nick
11M ago
The 2023 NFL schedule was released yesterday and since I used my Excel skills to automate the creation of this spreadsheet I was able to create the NFL Helmet Schedule in less than a minute! All 32 teams, all 18 weeks of the season (now 17 games plus one bye week), all in one spreadsheet: A job that used to take hour by moving helmets manually is now so easy to do. Yes, that's why I love the power of macros and automation. I wrote the macro myself but nowadays you could probably just ask ChatGPT to write the macro for you. On previous versions of the sheet I divided out the two conferences ..read more
Visit website
Super Bowl Squares 2023 - Unlimited Ways to Play
Excel Spreadsheets Help
by Nick
1y ago
Since 54 ways to play still wasn't enough, I've created a new version of my Super Bowl Squares template that should allow nearly limitless ways to play. I'm going to show you how to use it and what make it awesome. But first, let's take a quick look back at the evolution of my football grid game template. I’ve been making Super Bowl Squares templates available for you to download for over 10 years now. The first version in 2012 was very plain and simple and was basically just meant to be printed. I started adding more features and automation in 2014, beginning with a button you would click ..read more
Visit website
Elevate Your Sports Betting Game with Our Free Excel Tracking Tool
Excel Spreadsheets Help
by Nick
1y ago
Sports gambling just became legal here in Ohio and we've been flooded with sign-up offers. Since just about every sportsbook will give you free bonus bets (around $200) for a small ($5 or $10) deposit, I decided to dabble a little bit into sports betting to see what all the fuss is about. I signed up for three different sportsbook sites and quickly realized I needed a way to organize and track all my bets. Naturally, I decided to make an Excel template to track which bets I'd made, track my earnings, and make sure I was still making a profit. First, I created a Lists sheet for all my drop do ..read more
Visit website
Using OpenAI's ChatGPT to Update My Year in Pixels Excel Template
Excel Spreadsheets Help
by Nick
1y ago
I've been seeing more and more videos on TikTok about this mysterious new artificial intelligence program called ChatGPT. People are saying it will eventually replace Google search. But what really got my attention was a demonstration of ChatGPT writing VBA macros for Microsoft Excel. Now I knew I had to try it for myself.  I made a Year in Pixels Excel template to track my daily mood back in 2018 but haven't updated it lately. Since it's the start of a new year, I recently received some new comments and questions about how to use and modify the spreadsheet so I figured now would be a gre ..read more
Visit website
2022 College Football Bowl Prediction Pool
Excel Spreadsheets Help
by Nick
1y ago
The college football conference championships were played this past weekend which means the 2022 NCAA college football bowl season is here again! Therefore, it’s time to make your picks and predictions about who you think will win each bowl game. One of the best times of the holiday season (other than giving and receiving gifts) is being able to talk trash to your relatives about their terrible bowl picks. This year has the added bonus of not just single bowl games but the ninth year of a four team playoff to determine the national champion. And it was recently announced this will be the secon ..read more
Visit website
How to change relative hyperlink to exact link in Excel
Excel Spreadsheets Help
by Nick
1y ago
You may have used the HYPERLINK function in Excel before but what you may not have released is your links can be either relative or absolute (or sometimes called exact or specific). What does this even mean? And how do you change from relative to exact? What Are Absolute and Relative Hyperlinks? An absolute hyperlink reference, or what I call an exact link to the specific file location, shows the entire path to the referenced file. For example: C:\Documents\User\MyExcelFile.xlsm A relative hyperlink is a link to another file relative to where the current workbook is saved at. So the ..read more
Visit website
2022 NFL Helmet Schedule Spreadsheet
Excel Spreadsheets Help
by Nick
1y ago
 As I explained last year, I finally automated this spreadsheet so I was able to create the 2022 NFL Helmet Schedule in less than a minute! All 32 teams, all 18 weeks of the season (now 17 games plus one bye week), all in one spreadsheet: A job that used to take hour by moving helmets manually is now so easy to do. Yes, that's why I love the power of macros and automation. See how fast the sheet can be created by watching this clip: <insert video> On previous versions of the sheet I divided out the two conferences on separate sheets: NFC and AFC. This year, I’ve put all the teams ..read more
Visit website
The Best FREE Template to Automatically Create Folders From Excel
Excel Spreadsheets Help
by Nick
2y ago
One topic I've been discussing for more than ten years, and keep coming back to with improvements, is how to automatically create folders from Excel. I originally shared a simple macro to make folders back in 2011. More recently, I showed how to add hyperlinks back to the newly created folders. But I was never quite happy with these programs. So now I'm back with a better, more powerful, and easy to use template that will instantly create folders for you. This Excel template to create folders will teach you: How to use a macro to automatically create folders from Excel (duh) How to chang ..read more
Visit website

Follow Excel Spreadsheets Help on FeedSpot

Continue with Google
Continue with Apple
OR