excel macros

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

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

Have you ever received an Excel file and wondered how it was filtered without checking each column’s data filter? Or, maybe you needed to send a file and show your filters. That was a problem I faced recently when I started with a list of 3200 non-profits for the county. I needed a way for the … [Read more...] about See Excel Filter Criteria Above Your Column Titles