Excel pivot tables are a feature that you should learn. 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.)
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 blue Next Page >> button at the bottom or the search box to the right.
I've also been updating these articles to reflect the latest Excel version. Presently, I'm using Excel 2016. However, you may see some tutorials that reflect older versions. All the screen snaps have been done on a Windows computer and reflect those commands.
If you don't have Microsoft Excel, there are three options:
- Get an Office 365 (Subscription service)
- Buy Microsoft Office 2019 (One time purchase)
- Use the free version in your browser
The free version does require you to have a Microsoft account. As you might expect of a free product, there are some limitations. For example, you can open a workbook that has macros, but you won't be able to edit them.
You can read more about the different options on the Microsoft site.
Our most popular Excel Tutorials
Of all the work related items I need to do, the one I hate is data entry. It’s mind numbing and given the chance, I’ll make mistakes. One way I found to make the process easier is to use the Excel data form. It’s great when the records span across many cells.
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.
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.)
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.
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.
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.)
Learn how to use Excel autofilters to make large spreadsheets more manageable. This feature lets you filter columns by specific entry values. Includes sample spreadsheet.
One of the popular Excel tutorial requests is how do you look up a value on one Excel worksheet and use it on another Excel worksheet. For example, you need to translate a product number into a product name. One of my favorite Excel functions is the VLOOKUP function and it can help with this task. (Includes example spreadsheet and video.)
The problem with many Excel spreadsheets is they make the reader find the key information rather than using Excel to highlight these cells. Fortunately, Excel’s conditional formatting can make your data automatically stand out.