Downloadable 2013-2014 NHL Schedule in Excel

The 2013 NHL season is about to begin and to help get you excited for it I’ve made an NHL schedule spreadsheet available to download for free. The spreadsheet contains the logo of every NHL team and is similar format to my NCAA football helmet spreadsheet and NFL helmet schedule (but I didn’t put logos for every game due to the sheer number of games compared to the football seasons).

2013-2014 NHL Schedule.xls download

How to Combine Excel Files

There have been countless times during my day job when I’ve had to combine multiple Excel files into one. I used to do it the old fashioned way of copy and paste but after doing this tedious and time consuming task I decided to write a VBA macro to help me out. I’ve now made the template available for you to use for free. This version of the combine Excel workbooks macro allows you to choose the directory of the Excel files to copy without having to change the code in the Visual Basic Editor. The steps to use the Combine Workbooks tool are as follows:

 

1. Place the Excel workbooks you want to combine into a single folder that contains no other files
2. Go to View>Macros
3. Select "Combine Workbooks" then click Run
4. Select the File where the spreadsheets you want to combine are located
5. Save the newly created file

Instructions are provided with the spreadsheet

Please note that this code will not work on protected sheets and it will automatically skip any blank worksheets in any of the workbooks saved in the folder. See how it works for yourself by watching my short demo video below:
 

 

Download the Combine Excel Files spreadsheet that contains the VBA code to copy all the worksheets from all the workbooks in a folder into the active workbook using this link:
 

Combine Files.xlsm download

Download a Wordpress Website Creation Checklist Spreadsheet

In the past two years I’ve created eight websites for various hobbies and niches I am interested in and that I felt were underserved in the online world. I use Wordpress as my content management system because it allows you to quickly create a website with no HTML or other coding experience. The steps to setup a new website are pretty much the same so I put together a Wordpress website creation checklist to help me remember to do everything. I’ve made this checklist into an Excel template which you can download for free by clicking the link below.

 

 

Two skills I encourage everyone to learn that I’ve found invaluable in my career is how to program VBA macros and how to build a simple website. In fact, in one of my most recent projects these skills were used hand-in-hand. I built the majority of the Observation Wheel database with an Excel spreadsheet and a few custom macros. Every row in my sheet contained all the information for a single observation wheel. I then had the macro export the data to Microsoft Word in the HTML format I needed for the site. I then simply copied and pasted that text into Wordpress and published it. I created pages for over eighty dfferent observation wheels almost instantly!

 

There are countless positive benefits for learning how to make a website. I’ve included a link to all the resources I use within the template and I've tried to include as many tips as I could think of. I begin with registering a domain name and take you all the way through setting up an email list. Download my Wordpress website creation checklist below and please feel free to ask me any questions you may have!

 

Wordpress Website Creation Checklist.xls download

2013 NCAA College Football Helmet Schedule Spreadsheet

Finally! After hours of work I've finally updated the entire 2013 NCAA College Football Helmet Schedule spreadsheet - just in time too! It was pretty difficult because it has not been updated in quite some time and, as you're probably aware, the landscape of college football has shifted dramatically the past couple of seasons (and will continue to do so for a few years).

The 2013 college football helmet schedule in Excel includes every team from all eleven conferences. Every game is listed as either home, away, or neutral site (denotated at the bottom of each sheet). The only thing I haven't completed is linking all the helmets to their teams, so when you click on a helmet it takes you to that team, but I am still working on it. A college football helmet schedule schedule may be available on other websites but, to my knowlegde, this is the only downloadable Excel version and unlike some of the others is 100% FREE!

Download the 2013 NCAA College Football Helmet Schedule Spreadsheet.xlsx

It's hard to believe that College football begins in just a few days! Will the SEC continue their dominance? Will the MAC surpass the Big Ten? Will Johnny Manziel sign any autographs for free this season?

You can also grab the 2013 NFL Helmet Schedule in Excel too.

Apartment Comparison Spreadsheet Update

I’ve revamped my Apartment Comparison Spreadsheet website and the big news is you can now download the Apartment Search Spreadsheet for free! Signup for the Apartment Search Tips newsletter and you’ll immediately receive the link to download my apartment hunting tool. You can unsubscribe from the email list at anytime but if you’re looking for an apartment I recommend you don’t unsubscribe so you can get my valuable tips, like how to potentially earn $100 for signing a new lease!

The Apartment Search Spreadsheet can  also be used as an apartment search checklist as I listed almost every criteria you could think of for what you would like in a new apartment. Enter the data for every apartment you are looking at. Next, you’ll set an importance factor for several categories. What’s more important to you - size of the rooms or distance to work? The spreadsheet uses your inputs to give each apartment a score and you can easily see which apartment has the highest score and is thus the best choice for you.

Please note, the free preview version of the spresdsheet for apartment comparison only allows you to compare two apartments. You'll have to purchase the PRO version to compare more than two apartments, but it also comes with a lot of extra resources you might enjoy. Check it out here. And please do let me know if you find this tool at all useful or if you think it would be great if there were something like this for another item, like to compare houses or cars.

2013 NFL Helmet Schedule Spreadsheet

It’s time to get your NFL 2013 schedule. The new football season is nearly upon us after a murderous off-season. It’s finally time to get back to playing ball! This NFL 2013 schedule in Excel includes indicators for all special Monday, Wednesday, Thursday, and Saturday games. If you’re looking for a picture for every football helmet in the NFL you can find them all in this spreadsheet. Each helmet is in fact a hyperlink, not to an outside website but to a “Place in This Document.” It uses Cell References so if you click a team’s helmet it will take you to that team’s schedule in the spreadsheet.

 

The 2013 NFL helmet schedule spreadsheet can be incorporated into fantasy football leagues. And if you love fantasy football, you should check out the Fantasy Football Commissioner from CBS Sports.  Feel free to modify the spreadsheet as you see fit but please share the result with us so everyone can see what cool things you come up with! Download for free here:

2013 NFL Helmet Schedule Spreadsheet.xls download

I can't wait to see how all the storylines play out this year. Will Peyton Manning finally get a second Super Bowl ring? How will the New England Patriots fare after this crazy offseason? Will this be the year for my Cleveland Browns? I doubt it but you never know what will happen.

Update: Now you can get the 2013 NCAA helmet schedule spreadsheet here.

How to Filter Data in Excel

Learning how to filter data in Excel will help you analyse data faster and become better at your job. Filtering in Excel enables you to display only the data that you want to see on your spreadsheet without deleting anything. It’s a really great way to search through large amounts of information and you know I’m all about Excel tips that help improve your speed and efficiency!

There are three types of filters in Excel: list of values, by format, or criteria and you can sort your spreadsheet by order, color or text. What’s the difference between sorting and filtering? Sorting will rearrange the order of your list while filtering keeps the order but actually hides data based on your filter criteria.

To add a Filter in Excel, you can first select a single cell within your range of data but I recommend you highlight all your data (please note you cannot add filters to empty cells). Next, go to the Home tab then the Editing section. Under Sort & Filter click Filter (or use the filter shortcut Crtl+Shift+L). Once filtering is turned on you will see little arrows along your top row of data. Select one of the arrows to set your filter options. If you hover your mouse over the drop down arrow you will see a pop-up message displaying what the value the filter is currently set to (example: equals “Test”).

 

To remove the filtering from your spreadsheet, simply click the Filter button again. If you want to reset the filter to the original values click on the Sort & Filter button and then click “Clear."

You can also turn auto-Filter on and off with a VBA macro:

Sub TurnAutoFilterOn()

'check for filter, turn on if none exists

If Not ActiveSheet.AutoFilterMode Then

ActiveSheet.Range("A1").AutoFilter

End If

End Sub

Turn off AutoFilter with VBA:

Sub TurnFilterOff()

Worksheets("Sheet1").AutoFilterMode = False

End Sub

Here’s a great video showing you exactly how to filter data in Excel:

Follow us on Google Plus for the latest updates when I will talk about dynamic filters and Kalman filters in Excel.