One issue I run into with this site is software updates. I’ll be updating an article and low and behold, something is missing or changed. Usually, this is a result of software changes. The area that is impacted the most is the Excel Ribbon. In two articles, I noticed I was missing the Forms button and in the other case, the Excel Developer tab. Both issues are easily fixed when you know how to customize the ribbon.
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 video 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.
Our most popular Excel Tutorials
Understanding the Basics of the Excel Macro Editor
This Excel tutorial is the follow up to the previous article we did on using Excel’s built-in macro recorder. It will introduce you to the macro editor and layout so you can create or edit your own macros. It’s also a great way to learn how the macros work.
An Easy Way to Learn Excel Macros with the Recorder
If you’ve ever wanted to dabble with Excel macros, this tutorial and video on the macro recorder will get you started. Includes a sample workbook link so you can follow along.
Quick Solution: PivotTable Field Name is not Valid
Like many people, I have a love-hate relationship with software. It’s great when it works, but it’s so frustrating when you get a cryptic error message. And these messages seem to appear when you’re short on time and patience
How to Limit Mistakes with Excel Dependent Lists
This Excel tutorial shows you how to build a worksheet using dependent lists. In other words, the selection you make from one list defines the options on the next list. For example, if you select California from one list, the next list filters your selection to just California agents. Includes sample Excel worksheet.
When You Need to Separate First and Last Names in Excel
Recently, a friend asked about fixing an Excel spreadsheet where the subscriber name was in 1 column. He wanted the name separated so he could send a personalized mailing. This is not the first time this question has arisen. The key to solving this problem is to parse or split the data using the Text to Columns feature.
The Hidden Strengths of Excel Tables
One of my favorite quotes comes from Yogi Berra who said “You can observe a lot by just watching”. In this case, I was watching someone work with Excel and doing various tips to make the spreadsheet more usable. In fact, I’ve written about many of those tips. I suggested to my co-worker that he could reduce steps by using Excel Tables. And no, I’m not talking about pivot tables but something simpler and equally powerful. (Includes sample Excel file.)
How to Sort Your Excel Columns by Color
Excel allows you to sort you sheet by lots of ways. One less obvious way is to sort items by color. This is handy if you apply a background color to a cell or different font color. This tutorial explains how to do the sort.