To activate Solver, go to File and then down to Options.
Click on Add ins
Go to the bottom where it says Manage and the drop down says "Excel Add ins" then click Go.
That will give you the … [Read More...]
You can look at a players previous game logs to determine how risky a player is. You can do this with a simple formula in Excel. Then when you know if a player is risky or not, you can … [Read More...]
You see the Vegas odds and Over Under all the time, however they never show the score of both teams. You will just see something like New England is favored by 10 with an over under of 50. But what … [Read More...]
Last month I wrote an article for surepayroll.com titled "8 Great Tools to make you an Excel Expert"
Below is an infographic describing the article in visual terms. Have a look at it and check out … [Read More...]
Solver is a very powerful tool in Excel to come up with optimal results when you have many variables to take into account. One such issue I ran across recently was in trying to create a perfect … [Read More...]
Sometimes VLookup functions don't act how you want. It's not the function that is wrong though, it's usually the data. One common error with Vlookups are trying to pull data that doesn't match … [Read More...]
In this post I will show you how to convert numbers to text in Excel. I will outline 2 steps needed to do this.
convert numbers to text
The first step is through a function called text(). Let's … [Read More...]
Dashboards are a great feature in Excel to make your spreadsheets come to life. Recently I have teamed up with a fellow Excel Enthusiast, Mynda Treacy on Excel Dashboards. While I specialize in … [Read More...]
This is a video post where I show how to eliminate error messages in Excel using the IFERROR functions.
It's a great tool to use and can make your spreadsheets look a lot nicer and is great when … [Read More...]