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 27, 20174 minTips for Structuring your Excel DataExcel has some amazing report tools including charts and pivot tables. These tools are quick and easy to use, and produce some...
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 MartinFeb 1, 20171 minWorking ON our businesses, not just IN themI recently read a great post from Made to Thrive Consulting about working on our businesses, not just in them. Check it out here:...
Kimberlee MartinJan 20, 20174 minProtecting Data on an Access FormMicrosoft Access allows you to quickly create forms for viewing and editing your data. One issue you may have run into with forms is that...
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 MartinNov 30, 20164 minAccess or Excel?Excel or Access? Microsoft has lots of great tools, and in most cases, it’s pretty clear which you need to use. If you need to write a...
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...