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.

Tables

How To Group Rows (comma list of values)

| May 7, 2024 |

Hello and welcome to our post on grouping rows in Excel. We will walk through the process of combining the values in multiple rows into a single cell (comma-separated list of values). The example we’ll use to demonstrate the steps is to combine multiple email addresses for each contact into a single cell. But, this…

How to Launder Money with Excel (Benford’s Law)

| April 9, 2024 |

Hello and welcome to another informative blog post from Excel University. Today, we’re diving into a somewhat unusual topic – using Excel to launder money. If you aren’t familiar with that term, it simply means taking cash received from an illegal enterprise and running it through a legitimate business. That way, the money appears as…

Excel How To Freeze Rows

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

How to Filter in Excel

| 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!…

Excel How To Create Banded Rows

| March 7, 2023 |

Creating banded rows in a Microsoft Excel table is a great way to make data easier to read and interpret. Banded rows can also be used to help separate and highlight important information. You don’t need to use VBA, Power Query, or manual formatting – you can do it quickly and easily with just a…

Four Ways to Select Every Other Row in Excel

| January 3, 2023 |

Selecting every other row in Excel can be helpful. Aside from making it easy to get rid of duplicate rows, it can also be a great way to highlight important information, make the data easier to read with formatting, and more. However … if you’ve ever tried to select every other row in Excel, you…

How to Make an Excel Dynamic Chart & Keep Updates Consistent

| September 20, 2022 |

For the purposes of this discussion, an Excel dynamic chart is a chart that automatically updates itself whenever new data rows are added. The opposite is a static chart, which won’t incorporate any new data rows added to the existing range. To be clear, when Excel creates a chart based on a range of cells,…

Top 8 Excel Tips and Tricks to Save You Time

| April 5, 2022 |

These top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.

List of Workbook Tables and References

| December 8, 2020 |

John asked if there was a way to create a list of all table names in the workbook, along with the underlying table reference. In this post, I’ll demonstrate how this can be accomplished with Power Query and an Excel formula. Objective Before we get into the mechanics, let’s confirm our goal here. We have…