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 … [Read more...] about The Hidden Strengths of Excel Tables
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 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
The Basics of the Excel IF Function
Oh, have times changed. When I was a kid, my parents always told me, “no ifs, "ands", or buts”. Now, Microsoft Excel wasn’t around at that time or I could’ve provided a better argument for using these words. The solution lies with Excel’s IF function, which is a versatile logical function for … [Read more...] about The Basics of the Excel IF Function
How to Limit Mistakes with Excel Dependent Lists
Ever had a situation where you thought a software application should be smart enough to do a certain task? This question came when a reader wondered if the items on one Excel drop-down list could be based on a previous list selection. It turns out the answer, which uses dependent lists and the … [Read more...] about How to Limit Mistakes with Excel Dependent Lists
Simple Methods to Copy Excel Formula Values
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, I'll show you two faster and easier ways to copy the value and not the … [Read more...] about Simple Methods to Copy Excel Formula Values
Excel AutoFilter Makes Spreadsheets Useful
Two of the Excel filters I rely on when working with spreadsheets are AutoFilter and Custom AutoFilters. These are features Microsoft added with Excel 97, but few use it. Using these filters, I can turn an ordinary Excel spreadsheet into something more useful and versatile. … [Read more...] about Excel AutoFilter Makes Spreadsheets Useful