Discover three types of dynamic drop-down lists in Excel, and how to create them.

VB Script and VBA are two different things - do you know which is which? What will happen now that VB Script is deprecated?

Three ways to see your Top 3 <<things>> in Excel using conditional formatting, the RANK function, and Pivot Table filters.

Here are 3 good reasons to use named ranges in Excel.

Create a stopwatch on your Excel worksheet to track hours, minutes or seconds for your task.

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.

Create an audible alarm in Excel that beeps when a timer expires.

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...

Use properties of Excel connections to gain access to real-time data points in your database.

Using VLOOKUP data from Access and SQL Server databases

Add a link to SQL server data to your Excel worksheet.

Excel and MS Access store dates as numeric fields, allowing for each calculations in VBA.

Creating links to Microsoft Access data in your Excel worksheet.

Create a Microsoft Access table that is linked to an Excel file.

Users will make mistakes, and some of those will impact your VBA code. Here are three ways you can handle that.

Use Excel tools to report and analyze data in your software package. This post examines the process of importing a CSV or TXT file.

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...

Use VBA to check for nearly identical data in your Excel worksheet.

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...

Use MS Access to find duplicates in your Excel data