Kimberlee MartinMar 123 minSometimes the Easy Way is the Hard WaySumming Excel cells by color: an "easy" way and a "hard" way.
Kimberlee MartinNov 21, 20233 minDealing with the "Invalid Use of Nulls" ErrorThe Invalid Use of Nulls error message is common in VBA code when using Microsoft Access. Find out how to write code to deal with it.
Kimberlee MartinNov 13, 20233 minThe Power of Dynamic Drop Down Lists in Excel: Streamlining Data Entry and AnalysisDiscover three types of dynamic drop-down lists in Excel, and how to create them.
Kimberlee MartinNov 2, 20233 minVB Script vs. VBAVB Script and VBA are two different things - do you know which is which? What will happen now that VB Script is deprecated?
Kimberlee MartinOct 24, 20234 minWhy Choose Microsoft Access?Is Microsoft Access right for you? Here are several reasons why I often recommend Access to my clients.
Kimberlee MartinOct 21, 20233 minYour Best ThreeThree ways to see your Top 3 <<things>> in Excel using conditional formatting, the RANK function, and Pivot Table filters.
Kimberlee MartinOct 17, 20234 minThree Reasons to use Named Ranges in ExcelHere are 3 good reasons to use named ranges in Excel.
Kimberlee MartinSep 28, 20236 minExcel StopwatchCreate a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.
Kimberlee MartinSep 21, 20234 minOne Table or Two? Or Three? Four??Not sure if you need one table or two in Microsoft Access? Here's a guide.