Get the Monday of the Week

Get the Monday of the Current Week

The other day I needed to get the Monday of the current week so I can display “Week of the X” where X would be the date of that week’s Monday’s date. I figured this would be useful for you as well and I wanted to share this with you. Building up the Formula I knew that I could get …

The IF Function Feature Image

Excel IF Function

The IF function is one of the staples of Excel formulas. It’s one of the first formulas people learn when learning how to use Excel. It’s also used EVERYWHERE, and I really mean everywhere. I even wonder if it was one of the first formulas to ever be introduced to Excel so many years ago. At its core, the IF …

Get Hyperlink Address in UDF

Get Hyperlink Address with a Custom Function (UDF) in Excel

The other day I copied a table on a website and pasted it into Excel. The table included hyperlinks, but I didn’t want to show the text it had. I wanted the hyperlink address instead. Here’s a picture of what I’m talking about: Notice that the links have “…” at the end of the URLs, and cell in B2 says …

Create a Unique List in Excel - Feature Image

Create a Unique List in Excel based on Criteria

Nathan is working on a spreadsheet that contains a list of car models and owners. He needs to create a unique list of owners per car. “Maybe I can use an IF() formula,” he thinks to himself and decides to give it a go. However, after several failed attempts he decides to search the web to see how people create a …

Excel Tables - Feature Image

Excel Tables

Excel tables are great. They take your plain old data and turn it into a dynamic, well formatted table with a whole host of features. In fact, whenever I have any data that I need to do some simple processing on, the first thing I do is turn it into an Excel Table. With this post, I intend to get you …

Anatomy of Structured references

Structured References [Infographic]

Are your formulas driving you crazy? Do they have a multitude of $ signs, colons, and letters referring to various columns? How many times have you looked at your complicated formulas and asked yourself “What data is this referring to?” I know I have. I mean, it’s not always easy remembering what $B2:$D10 is referring to. Luckily, we can leverage Structured …

Pixelator Example

Pixelate Images in Excel Cells

Can you pixelate images in Excel? Or can you create an image in Excel by painting pixel-by-pixel? Well, a couple of years ago, I read an article about a Japanese man who was creating art using Excel. When I first heard about this, I immediately thought that he was painstakingly changing each cell's background color to create his art (i.e. creating the ...
How to create a drop-down list in Excel

How to Create a Drop-down List in Excel

You finally did it. You've just created an awesome Excel form that will let your team log data about how much time they are spending on their projects. With this new form, you can easily make reports that will show how much effort is given to all projects, identify bottlenecks, and determine which projects are taking more time to complete than originally estimated. ...
join cells in excel

How to Join Cells In Excel with a Comma (or other delimiter)

There are times where I need to join cells in Excel and separate them with a comma or some other text. I usually need this to make a SQL query or something like this. Whatever the case may be, Excel doesn't seem to have an easy way to join multiple cells with a delimiter like a comma. So I've created a ...