Kimberlee MartinApr 206 minOne Click to Run Your MacroI’ve written a couple of blogs lately about creating Excel macros. In a related topic, today I’m going to talk about one of the easiest...
Kimberlee MartinMar 213 minIt's All RelativeRelative references vs absolute references in Microsoft Excel macros
Kimberlee MartinMar 142 minWhere to Start with the Excel Macro RecorderWhen getting started with the Excel macro recorder, start small, and build on your successes.
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 MartinJun 3, 20214 minMaking the Most of ExcelIdeas for maximizing your use of Microsoft Excel
Kimberlee MartinMay 26, 20213 minCheck Marks in ExcelExcel is a great tool for helping you stay organized, and many people create checklists in Excel for just that purpose. I’ve got a...
Kimberlee MartinApr 19, 20213 minAdding an "Always On Top" panel in ExcelThere’s a cool feature in PowerPoint that allows you to see all of your slides in sequence, move them around, and double-click to edit...
Kimberlee MartinJan 18, 20215 minTemporary Watermark in ExcelAdding a Watermark to an Excel document only when printing
Kimberlee MartinAug 17, 20204 minWhat are Pivot Tables?A brief introduction to Pivot Tables, explaining what they are and why you might want to use them.
Kimberlee MartinAug 10, 20205 minScaffolding in ExcelUsing a scaffolding technique to build complex formulas in Excel
Kimberlee MartinAug 3, 20203 minI Don't Know It AllI am the first to admit that when it comes to Excel, I don’t know it all. Hard to believe, I know (LOL!!) I’ve had students who don’t...
Kimberlee MartinJul 27, 20204 minThe Arguments of VLOOKUPIn previous blogs, I’ve talked about Excel’s VLOOKUP function. In one, I covered the purpose of VLOOKUP, and in the other, I explained...
Kimberlee MartinJul 17, 20203 minThree Excel Functions You Should Be UsingExcel is a great tool for data analysis, with a powerful suite of built-in functions to help. You’re probably already familiar with some...
Kimberlee MartinJul 9, 20202 minVLOOKUP vs. HLOOKUPIn my last post, I talked about why you might use the VLOOKUP feature. If you missed it, you can find it here. Today, I’m going to...
Kimberlee MartinApr 30, 20202 minWhat is VLOOKUP, and Why Do I Need It?VLOOKUP is one of the coolest features of Microsoft Excel, and also one of the least understood. Lots of people are interested in it and...
Kimberlee MartinAug 28, 20173 minData AccessibilityJust about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a...
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...