Kimberlee MartinJun 9, 20214 minMaking the Most of Excel – Data ValidationLast week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today,...
Kimberlee MartinApr 18, 20173 minOption ExplicitIf you’ve ever written VBA code in Excel, Access, or any of the other products in the Microsoft Office suite, you may already be familiar...
Kimberlee MartinFeb 16, 20176 minCreating a Timer in ExcelThe other day I had a client ask me to create a reminder in an Excel document that would pop up several times a day. It had to run at...
Kimberlee MartinJan 3, 20175 minRecording Flexible MacrosRecording macros in Excel is an easy way to automate repetitive tasks. Maybe you receive a new file every month with your sales figures...
Kimberlee MartinOct 31, 20164 minWhat is Excel VBA?If you've ever thought about creating macros in Excel, you've probably heard the term "VBA". In this post, I'm going to give you a little...