Some time back, I wrote an article about a useful function in Microsoft Excel called Goal Seek. It quickly allows you to solve easy “what-if” scenarios. Although helpful, it comes with limitations. However, Microsoft has a more powerful add-in analysis tool called Excel Solver that overcomes these … [Read more...] about Quick Guide to Excel Solver
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
One of the more exciting software features to be released in Excel is the XLOOKUP function. Just looking at the name, you might think I did a typo and meant vlookup. No, this is an entirely new spreadsheet function that makes looking up data easier with fewer limitations on your lookup column. In … [Read more...] about Beginners Guide to XLOOKUP in Excel
Excel pivot tables are a feature that you should learn how to use. Instead of analyzing countless spreadsheet records, these tables 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 … [Read more...] about How to Use Excel Pivot Tables to Organize Data
Of all the work-related items I need to do, the one I hate is inputting data. It’s mind numbing and given the chance, I’ll make mistakes. One way I found to make the process easier is to use Excel forms. These data entry forms are especially beneficial when your records span across many columns. … [Read more...] about These Excel Forms Make Data Entry Easy
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 … [Read more...] about Customizing the Excel Ribbon for Your Needs