I like to think of editors as a tool that enhances your work and offers guidance. This holds true whether the editor is a real person or a built-in tool like the Excel macro editor. One benefit of Excel's editor is that it's also a teaching tool. Once you start playing around and creating macros, … [Read more...] about Understanding the Basics of the Excel Macro Editor
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:
Awhile back, I attended a conference where an expert strongly urged participants not to use color in a Microsoft Excel spreadsheet. She claimed you couldn’t sort columns by color. She went on to say one of her clients had done this and she spent hours fixing the sheet. Oh my. Perhaps, at one time … [Read more...] about How to Sort Excel by Color
Somedays, I just want to scream when things that did work, no longer work. This happened this week when I needed to contact a vendor by email. This is usually a simple task where you click an email link and it opens in your default application. Instead of getting Gmail to open up in Chrome, I was … [Read more...] about How To Fix Email Links So They Open In Chrome
Do you find you're seeing more browser push notifications? Some of these are quite useful, but others are a result of me clicking to allow something in my haste. This week, I hit the tipping point. Each time the little box would push out from the right side of Chrome, I'd want to smack it. While … [Read more...] about How to Change Chrome Push Notifications
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