Excel Tutorials

Below is a list of various Microsoft Excel tutorials that we've done. These include step by step instructions. in some cases, there may be sample spreadsheets or screencasts. This section is several pages long so be sure to use the Next page button at the bottom or search box to the right.

Simple Methods to Copy Excel Formula Values

paste-values1

Recently I was watching an Excel product review and noticed the author copy Excel values from a formula into another column. This was fine, but then he deleted the column with the formula. Sound familiar? In this tutorial, Ill show you two faster and easier ways to overwrite formulas with their values. (Includes video demo and sample spreadsheet.)

Make An Excel Decision Matrix

Enter in decision matrix numbers

Life is full of decisions. Some are easy and require little thought while others require more analysis. In many scenarios, Excel can help by creating a weighted decision matrix. You define the ranking criteria, importance and Excel will do the math and pick a winner from your options. Think of it as your own Excel ranking formula. (Includes Excel decision matrix macro.

Select Random Names with Excel

excel-randbetween-1

Earlier this month, I got a request from a manager in town asking if I could randomly select 150 people from a membership list. No darts allowed. I think the purpose was to do a survey, but maybe it was to select contest winners. It turns out that Microsoft Excel has a random number generator which was the key to my solution.

Find Word Count in Excel

Excel character and word count

I attended an industry summit where experts provided some useful tips. One Excel tip involved filtering cells with a certain number of words. A nice tip, but it left some attendees wondering where Excel’s word count function was. The program doesn’t have this feature, but you can get the answer by creating an Excel formula to count words and characters. (Includes sample Excel worksheet and formula)

Excel Basics and the IF Function

excel-if-2r

One way to make your Excel spreadsheets smarter is to use the IF function. The program will evaluate one field to see if it’s true and enter a new value based on whether the condition was met. This article and sample worksheet shows a simple example of calculating an allowance.

Use Excel Pivot Tables to Organize Data

pivot table example

Excel pivot tables are a feature that you should learn how to use. Instead of analyzing countless spreadsheet records, a pivot table can aggregate your information and show a new perspective in a few clicks. You can also move columns to rows or vice versa. The problem is people believe creating a pivot table is difficult to learn. Grab a seat and we’ll guide you through a short tutorial so you can start data crunching. (Includes example worksheet.)

Preventing Excel Divide by 0 Error

Excel divide by zero error

Ever received an Excel spreadsheet with those crazy divide by zero errors – #DIV/0!? It’s an annoyance as it just draws the eye to the wrong cell. Instead, take 5 minutes to apply this fix so you can concentrate on the important parts.