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 …

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

Excel Dashboard Course

Do you want to really impress your manager? Or your manager’s manager? Then you should learn how to create Excel dashboards. Seriously, this is like catnip for managers. If you want to know how to create beautiful graphs that really convey the message of where the company is and where they need to go (which is extremely important to managers), then …

Alternative to Multiple IF Statements

Have you ever had to create a multiple IF statement? Ever notice how crazy it looks with all those parentheses and it's difficult to follow? Well, I was wondering if there was another way I could create a multiple IF statements that would be cleaner and easier to edit if need be. And I have. What I have discovered isn't ...

Arrange Windows for the Obsessive Compulsive

I’m sure you can find how to Arrange Windows in Excel all over the web; it’s been covered many times. However, if you’re anything like me, you would like to know how to control the actual arrangement is done by Excel. Maybe you’d like the window on the left to be the “before” worksheet and the worksheet on the right …

Hyperlinks are lost after sorting – VBA fix

After I wrote my post about creating hyperlinks with external data, a subscriber told me about a problem they were having and was wondering if I could help.  The issue was that when they sorted hyperlinks after they were recently copied from one range to another, some hyperlinks would be removed from the range while others remained intact.  I hadn’t …

Excel – Create a Pivot Table Using SQL

I use pivot tables extensively.  And there aren't many days that I don't create/use/manipulate pivot tables in some way.  However, I don't typically use worksheet data like in most examples you'll find online.  Instead, I usually create a custom SQL query to one of our SQL Server databases using SQL Server Management Studio (SSMS), test out the query, and then ...