Dynamic Highlighting in Excel
Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge,...
Search
Kimberlee Martin
- Apr 20
- 6 min
One Click to Run Your Macro
I’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...
3 views0 comments
Kimberlee Martin
- Mar 21
- 3 min
It's All Relative
Relative references vs absolute references in Microsoft Excel macros
5 views0 comments
Kimberlee Martin
- Mar 14
- 2 min
Where to Start with the Excel Macro Recorder
When getting started with the Excel macro recorder, start small, and build on your successes.
7 views0 comments
Kimberlee Martin
- Jun 9, 2021
- 4 min
Making the Most of Excel – Data Validation
Last week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today,...
12 views0 comments
Kimberlee Martin
- Jun 3, 2021
- 4 min
Making the Most of Excel
Ideas for maximizing your use of Microsoft Excel
11 views0 comments
Kimberlee Martin
- May 26, 2021
- 3 min
Check Marks in Excel
Excel is a great tool for helping you stay organized, and many people create checklists in Excel for just that purpose. I’ve got a...
19 views0 comments
Kimberlee Martin
- Apr 19, 2021
- 3 min
Adding an "Always On Top" panel in Excel
There’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...
11 views0 comments
Kimberlee Martin
- Jan 18, 2021
- 5 min
Temporary Watermark in Excel
Adding a Watermark to an Excel document only when printing
14 views0 comments
Kimberlee Martin
- Aug 17, 2020
- 4 min
What are Pivot Tables?
A brief introduction to Pivot Tables, explaining what they are and why you might want to use them.
9 views0 comments
Kimberlee Martin
- Aug 10, 2020
- 5 min
Scaffolding in Excel
Using a scaffolding technique to build complex formulas in Excel
229 views0 comments
Kimberlee Martin
- Aug 3, 2020
- 3 min
I Don't Know It All
I 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...
6 views0 comments
Kimberlee Martin
- Jul 27, 2020
- 4 min
The Arguments of VLOOKUP
In previous blogs, I’ve talked about Excel’s VLOOKUP function. In one, I covered the purpose of VLOOKUP, and in the other, I explained...
4 views0 comments
Kimberlee Martin
- Jul 17, 2020
- 3 min
Three Excel Functions You Should Be Using
Excel is a great tool for data analysis, with a powerful suite of built-in functions to help. You’re probably already familiar with some...
14 views0 comments
Kimberlee Martin
- Jul 9, 2020
- 2 min
VLOOKUP vs. HLOOKUP
In 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...
8 views0 comments
Kimberlee Martin
- Apr 30, 2020
- 2 min
What 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...
29 views0 comments
Kimberlee Martin
- Aug 28, 2017
- 3 min
Data Accessibility
Just about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a...
19 views0 comments
Kimberlee Martin
- Apr 18, 2017
- 3 min
Option Explicit
If 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...
16 views0 comments
Kimberlee Martin
- Feb 27, 2017
- 4 min
Tips for Structuring your Excel Data
Excel has some amazing report tools including charts and pivot tables. These tools are quick and easy to use, and produce some...
14 views0 comments