Spreadsheets are known for having a number of formulas and functions. One that continually intrigues users is VLOOKUP. Excel does include additional information. But sometimes it's best to learn how to use VLOOKUP by following along with example spreadsheets. — If you're using Google Sheets, … [Read more...] about How to Use VLOOKUP in Excel
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 of the search box to the right.
I've also been updating these articles to reflect the latest Excel version. Presently, I'm using Microsoft Office 365. 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.
It should also be noted that Office 365 releases new features on a monthly basis and even sooner if you're in the Insiders program. In some cases, these new features may not make it to older standalone versions. An example of this is the new XLOOKUP function.
Our most popular Excel Tutorials
If you walk into any office, you’ll likely find a Microsoft Excel user. It’s a common and useful business analysis tool if used properly. The problem with many spreadsheets is all the cells look the same. You have to hunt for key information by scanning through a range of cells. Fortunately, … [Read more...] about Highlight Important Data with Excel Conditional Formatting
The days after an election people often ask “what-if” type questions. Some races are close and the vote count can go on for days. In other cases, people want to know how many votes would've been needed to win. Excel Goal Seek is a simple tool for answering these and other forecasting questions. … [Read more...] about Find Quick Answers With Excel Goal Seek
We all look at information differently. Some people create Excel spreadsheets where the main fields go across in a row whereas others put the data vertically. This can lead to a scenario where you want to swap or switch Excel columns to rows without retyping the information. Microsoft must have … [Read more...] about How to Transpose Excel Columns to Rows
Recently, I volunteered to help a friend on an Excel project. When I asked my friend how the spreadsheet looked, he hesitated. Never a good sign. He looked me in the eyes and said, "It's too complicated". I was disappointed and didn't know what "too complicated" meant. It turns out the data was … [Read more...] about How to Freeze Cells in Excel – 4 Easy Examples