# Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

# Techniques

## Turn a Table of Events into a Graphical Calendar

| July 16, 2024 |

Today, we’re tackling the following question: How do you create a calendar that can show multiple events per day in Excel? We’re going to transform a simple table of events into a dynamic, graphical calendar. Let’s dive right in! Objective In summary, we have a list of events stored in a Table named Table1, like…

## Automate File Cleanup

| June 18, 2024 |

I was recently asked the following question: I download an excel file every week and make changes like deleting columns, counting and adding rows and so on. Can I automate this repetitive task ? In this post, I’ll attempt to answer this question. The built-in Excel feature we’ll use to accomplish this is Power Query.…

## Highlight Correct Answer with Conditional Formatting

| February 6, 2024 |

Time to walk through another exciting Excel adventure 🙂 Today, we’re zooming in on an interesting question I recently received: “How can I highlight correct answers on an Excel worksheet for my granddaughter’s multiplication tables?” Sounds like a marvelously practical application of Excel, doesn’t it? Well, let’s dive in and find out how we can…

## Excel How To Compare Two Columns (3 ways)

| July 18, 2023 |

Using Microsoft Excel to compare two columns is a great way to look for discrepancies or similarities between two different sets of data. This post provides 3 different ways to accomplish this so that you can use the one that is most appropriate for your data and workbook. Video Step-by-step guide Let’s work through each…

## Excel How To Get Help with ChatGPT

| July 11, 2023 |

Microsoft Excel can feel overwhelming with its vast array of features, commands, and tools. When you are trying to do something in Excel, and aren’t sure how … what do you do? Traditionally, this is where a Google search happens. And, we can certainly continue using online search. However, we now have another option available…

## Excel How To Write VBA with ChatGPT

| July 4, 2023 |

There are many built-in Excel features and functions. Which is awesome because they enable us to do so many different things. But … what happens when we want to do something for which there is no built-in feature? Are we stuck? No … we can typically get help from a macro. Macros are written in…

## Excel How To Understand VBA Macros with ChatGPT

| June 27, 2023 |

Whether you’re trying to decipher a macro created by someone else in your organization, or you’re trying to make sure a code sample you found online is safe to run, ChatGPT can help you understand the VBA code. If you’re not a programmer, understanding macro VBA code can be a daunting task. In this post,…

## Excel How To Write a Formula with ChatGPT

| June 20, 2023 |

Microsoft Excel is one of the most powerful and versatile software programs available. It allows users to quickly and accurately organize, analyze, and present data. With the help of ChatGPT, learning how to write Excel formulas just got easier. While ChatGPT may not be able to write formulas that are always 100% accurate, it can…

## Excel How To Understand a Formula with ChatGPT

| June 13, 2023 |

Have you ever tried to reverse engineer or understand a complex Excel formula? Perhaps you inherited a workbook, and you encounter functions that you haven’t used before. Or, there are multiple functions in a single formula. It would really be nice if the person who created the formula could walk you through it. When this…