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
These pages include all the site tutorials regardless of category. These mainly cover Microsoft and Google products. In addition, there are some posts that provide information about key terms. Presently, the categories include:
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.
Some reader favorites include:
Ever had the situation where you need to go back to a web page you visited but can’t recall the URL or site? This happened to me this week. I knew the site name, but not the specific page. My attempts to find it using the site’s search didn’t work well. I couldn’t recall the right words and got too … [Read more...] about Using Browser History to Find Elusive Pages
There are certain words that seem to scare folks when it comes to Excel. One of those words is "macro". I think this is a classic case of assuming the worst. We think we have to learn how to use code, logic and a bunch of other stuff like Visual Basic for Applications (VBA). The truth is Excel has a … [Read more...] about An Easy Way to Learn Excel Macros with the Recorder
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
Many people have asked for more tutorials using Google’s suite of products. One prominent question is "how does VLOOKUP work in Google Sheets?". This function is hugely popular among Google and Microsoft spreadsheet enthusiasts. In this example, I’ll show how to get started. (Includes resource … [Read more...] about How to Leverage Google Sheets and VLOOKUP