The Power of Dynamic Drop Down Lists in Excel: Streamlining Data Entry and Analysis
Discover three types of dynamic drop-down lists in Excel, and how to create them.
top of page
Search
Kimberlee Martin
Nov 2, 20233 min read
VB Script vs. VBA
VB Script and VBA are two different things - do you know which is which? What will happen now that VB Script is deprecated?
28 views0 comments
Kimberlee Martin
Oct 21, 20233 min read
Your Best Three
Three ways to see your Top 3 <<things>> in Excel using conditional formatting, the RANK function, and Pivot Table filters.
25 views0 comments
Kimberlee Martin
Oct 17, 20234 min read
Three Reasons to use Named Ranges in Excel
Here are 3 good reasons to use named ranges in Excel.
18 views0 comments
Kimberlee Martin
Sep 28, 20236 min read
Excel Stopwatch
Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.
36 views0 comments
Kimberlee Martin
Sep 19, 20233 min read
Detecting #N/A with VBA
Using VBA code to check for #N/A in an Excel cell. The CVErr function allows you to check for several of the "#" errors in Excel.
38 views0 comments
Kimberlee Martin
Sep 14, 20233 min read
BEEP! An Audible Alarm in Excel
Create an audible alarm in Excel that beeps when a timer expires.
13 views0 comments
Kimberlee Martin
Aug 8, 20234 min read
Scheduling Excel Macros with a Timer
A while back, I wrote about creating a timer in Excel. In that post, I went into detail about my failed attempts to create one, and how I...
28 views0 comments
Kimberlee Martin
Mar 29, 20235 min read
Connection Properties
Use properties of Excel connections to gain access to real-time data points in your database.
31 views0 comments
Kimberlee Martin
Mar 8, 20234 min read
Connecting Data Sources in Excel
Using VLOOKUP data from Access and SQL Server databases
19 views0 comments
Kimberlee Martin
Jan 20, 20234 min read
Connections: Bringing SQL Server data into Excel
Add a link to SQL server data to your Excel worksheet.
21 views0 comments
Kimberlee Martin
Jan 11, 20234 min read
VBA Dates
Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.
15 views0 comments
Kimberlee Martin
Jan 9, 20234 min read
Connections: Bringing Access Data into Excel
Creating links to Microsoft Access data in your Excel worksheet.
27 views0 comments
Kimberlee Martin
Jan 5, 20236 min read
Connections: Bringing Excel Data into Access
Create a Microsoft Access table that is linked to an Excel file.
20 views0 comments
Kimberlee Martin
Jan 3, 20235 min read
VBA: Three Ways to Handle Text in Numeric Fields
Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.
10 views0 comments
Kimberlee Martin
Dec 28, 20225 min read
Connections: Importing CSV Data from your Software Package into Excel
Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.
17 views0 comments
Kimberlee Martin
Dec 22, 20223 min read
Using Access to Clean Excel Data, Part 5
I’ve been covering the use of Microsoft Access tools to clean your Excel data for the past few weeks. Today is the final entry in that...
19 views0 comments
Kimberlee Martin
Dec 19, 20224 min read
Doubles, but No Troubles
Use VBA to check for nearly identical data in your Excel worksheet.
20 views0 comments
Kimberlee Martin
Dec 16, 20224 min read
Double Trouble
Today we’ll be looking at preventing duplicate values from being entered into your Excel sheet. This is the final entry in a series that...
15 views0 comments
Kimberlee Martin
Dec 12, 20226 min read
Using Access to Clean Excel Data, Part 4
Use MS Access to find duplicates in your Excel data
14 views0 comments
CATEGORY
ARCHIVE
bottom of page