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.
ChatGPT
I recently discovered that you can upload an Excel file to ChatGPT, ask it to perform tasks on the file, and then download the updated file. In this post, I wanted to share what I discovered and demonstrate it with a few examples including unprotecting a worksheet, writing formulas, and creating a chart. Microsoft’s Copilot…
Read More
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…
Read More
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…
Read More
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,…
Read More
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…
Read More
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…
Read More
Today we’re going to be discussing how to use AI to write formulas in excel. This new capability is available now in Excel online, and may be available in other versions of Excel in the future. Video Note At the time of this post, this feature is available in some version of Excel Online, and…
Read More
My friend John Michaloudis does an annual survey of Excel MVPs and experts and asks for their best Excel tip. He compiles the tips into an audio podcast along with show notes and related links. This is a great resource and I love sharing it every year. This year, he rounded up tips from: You’ll…
Read More