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