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...]
Text to Column is a great tool to break apart the contents of cells. However there are easier ways to do it without performing tasks like that. You can use Excel Functions to do the trick. To do this, … [Read More...]
Excel can be a great tool to calculate invoice payment information for Accounts Payable registers. If you are a business that pays a lot of vendors, you can keep track of all your payments and … [Read More...]
Excel has many great functions to allow you to round numbers but FLOOR and CEILING are two pretty cool ones.
While most functions allow you to round to a certain decimal place, these functions … [Read More...]
There are many different skill levels of people who use Excel. If you are a casual user of Excel you probably don’t know many of the advanced features of it. You probably also don’t know some of the … [Read More...]