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

# Power Query

## Combine Lots of Tables in the Same Workbook

| July 9, 2024 |

Today we will tackle a common question: “How can we combine numerous tables that are in the same workbook?” Let’s dive right in and learn how to easily combine tables, even if they have different column orders! Video Step-by-step Process In this guide, we’ll explore how to use Power Query to combine several tables from…

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

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

## Create Hyperlinks to Files in a Folder

| March 26, 2024 |

Today, we’re diving into an exciting way to enhance your data organization skills using Excel. I was recently asked the following question: Is there a way to create a list of files so that the files in the list could be hyperlinked back to the source in the folder? I’m going to answer that question…

## Merge Excel Files with Multiple Sheets

| February 20, 2024 |

Today, we’re answering a question we received about how to combine multiple Excel workbooks into a single workbook, even when there are a variable number of worksheets within each workbook. This post shows how to use Power Query to accomplish it. Let’s jump right in! Video Classic Problem, User-friendly Solution In handling large datasets or…

## UPPER lower Proper Case (3 ways)

| December 5, 2023 |

The objective of this tutorial is to demonstrate three different methods to change the case of text in Microsoft Excel: Flash Fill, formulas, and Power Query. By the end of this tutorial, you will be confident in using these techniques to convert text to upper case, lower case, and proper case. Video Walkthrough Let’s walk…

## Get QuickBooks Exports into Excel with Power Query

| August 8, 2023 |

Welcome to this tutorial on how to pull QuickBooks exports into Excel with Power Query. In this tutorial, we will run a QuickBooks report, download it to an Excel format, and then use Power Query to clean it up and get the data into an Excel table. We will use Power Query to import this…

## Compare Two Columns with Microsoft Excel Power Query

| July 25, 2023 |

If you’re looking to compare two columns in Excel with Power Query, you’ve come to the right place. In this tutorial, you’ll learn how to use Power Query to compare two lists to find which items appear on both and which items appear on only one list. Plus, you’ll learn how to match on multiple…

## Excel How To Remove Duplicates (3 Easy Ways)

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