Auto-replace Text in Excel Cell with VBA
In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...
top of page
Search
Kimberlee Martin
Dec 2, 20224 min read
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
22 views0 comments
Kimberlee Martin
Dec 1, 20225 min read
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
13 views0 comments
Kimberlee Martin
Nov 28, 20226 min read
Parse Phone and Extension with VBA
Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...
19 views0 comments
Kimberlee Martin
Nov 21, 20226 min read
Using Access to Clean Excel Data, Part 2
Use MS Access to clean phone numbers in your Excel data.
21 views0 comments
Kimberlee Martin
Nov 18, 20229 min read
Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.
26 views0 comments
Kimberlee Martin
Nov 16, 20226 min read
Validating a State in Excel
Use Excel tools to validate a U.S. state.
25 views0 comments
Kimberlee Martin
Nov 14, 20225 min read
Using Access to Clean Excel Data, Part 1
Excel data can be messy. Use MS Access features to clean it up.
30 views0 comments
Kimberlee Martin
Jun 3, 20214 min read
Making the Most of Excel
Ideas for maximizing your use of Microsoft Excel
21 views0 comments
Kimberlee Martin
May 26, 20213 min read
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...
47 views0 comments
Kimberlee Martin
Apr 19, 20213 min read
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...
32 views0 comments
Kimberlee Martin
Jan 18, 20215 min read
Temporary Watermark in Excel
Adding a Watermark to an Excel document only when printing
44 views0 comments
Kimberlee Martin
Aug 17, 20204 min read
What are Pivot Tables?
A brief introduction to Pivot Tables, explaining what they are and why you might want to use them.
14 views0 comments
Kimberlee Martin
Aug 10, 20205 min read
Scaffolding in Excel
Using a scaffolding technique to build complex formulas in Excel
1,135 views0 comments
Kimberlee Martin
Aug 3, 20203 min read
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...
9 views0 comments
Kimberlee Martin
Jul 17, 20203 min read
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...
18 views0 comments
Kimberlee Martin
Feb 27, 20174 min read
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...
28 views0 comments
Kimberlee Martin
Nov 30, 20164 min read
Access 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...
25 views0 comments
Kimberlee Martin
Oct 31, 20164 min read
What 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...
35 views0 comments
CATEGORY
ARCHIVE
bottom of page