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.

Posts

Excel How To Write VBA with ChatGPT

By Jeff Lenning | 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…

Read More

Excel How To Understand VBA Macros with ChatGPT

By Jeff Lenning | 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,…

Read More

Excel How To Write a Formula with ChatGPT

By Jeff Lenning | 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…

Read More

Excel How To Understand a Formula with ChatGPT

By Jeff Lenning | 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…

Read More

Excel How To Freeze Rows

By Jeff Lenning | June 6, 2023 |

When you scroll down an Excel worksheet, you may lose the ability to see the column labels. Not the Excel column labels like A and B … but the column headers of your data like ID and Amount. This can be annoying because depending on the data, you may lose track of which data is…

Read More

Excel How To Remove Duplicates (3 Easy Ways)

By Jeff Lenning | May 30, 2023 |

This post demonstrates how to remove duplicates from your Microsoft Excel worksheets. As with just about anything in Excel, there are multiple ways. I’ll show you 3 of the easiest and fastest ways to do it, specifically: the Remove Duplicates command, the UNIQUE function, and Power Query. Video Narrative We’ll just walk through each of…

Read More
Man holding dice that represent how to random sort in Excel

Random Sort in Excel

By Excel University | May 23, 2023 |

Despite the many ways you can shuffle rows, columns, and cells, there’s no built-in option to random sort in Excel. That can be useful for randomly assigning tasks or responsibilities, selecting samples, and much more. Instead, you can write a formula that allows you to randomly sort any data you select. Video How to Random…

Read More
Woman holding paperwork and looking at a laptop while learning how to create a simple dot plot in excel

Create a Simple Dot Plot in Excel

By Excel University | May 16, 2023 |

Dot plots contain a series of dots, with each dot representing a single data point. They’re straightforward, easy-to-read charts that help you see trends and find any potential outliers in your samples. Creating a dot plot in Excel can be done in only a few steps which makes them a popular choice for displaying data!…

Read More

How to Write Formulas in Excel

By Jeff Lenning | May 9, 2023 |

Are you looking to learn how to write Excel formulas? Formulas are the backbone of Excel and allow you to perform calculations, manipulate data, and automate repetitive tasks. This post will guide you through the basics of writing Excel formulas and provide examples to help you get started. Video Narrative Welcome to a tutorial on…

Read More

How to Filter in Excel

By Jeff Lenning | May 2, 2023 |

Hello there! Are you looking to learn how to filter in Excel? You’ve come to the right place! Filtering is an incredibly useful feature in Excel that allows you to quickly and easily sort through large amounts of data to find exactly what you’re looking for. In this article, we’ll explore: Let’s get to it!…

Read More