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

Relative references vs absolute references in Microsoft Excel macros

When getting started with the Excel macro recorder, start small, and build on your successes.

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

Ideas for maximizing your use of Microsoft 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...

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

Adding a Watermark to an Excel document only when printing

A brief introduction to Pivot Tables, explaining what they are and why you might want to use them.

Using a scaffolding technique to build complex formulas in Excel

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

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

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

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

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

Just about all companies rely on electronic data these days, but not all companies can quickly and easily access their data. Here are a...

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

How to add line numbers to VBA

Excel has some amazing report tools including charts and pivot tables. These tools are quick and easy to use, and produce some...

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