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
How to Insert Images into Excel Cells with Data Types and Use Them in PivotTables Welcome to the final post in the Pictures in Excel series! In this tutorial, we will insert images into Excel cells using data types and then incorporate these images into PivotTables. By the end of this post, you’ll learn how…
Read MoreHow to Use Pictures and PivotTables in Excel Introduction Welcome to the next post in our Pictures in Excel series. In this tutorial, we’ll explore how to use pictures as cell values and incorporate them into PivotTables. So, let’s jump right in! Note: the capabilities presented in this post are not available in all Excel…
Read MoreI am excited to announce this year’s Excel University scholarship winners! This scholarship is supported by the Excel University Alumni Association, so thanks to all of you who have helped make these awards possible over the past 8 years. This was the most competitive scholarship year with more applicants than ever! Thanks to all of…
Read MoreRetrieving and Displaying Online Pictures in Microsoft Excel Introduction Hello and welcome to the next post in our Pictures in Excel series, where we are exploring applications of inserting images into cells. In the previous videos, we focused on inserting pictures from our local devices into cells on the worksheet. Today, we will learn how…
Read MoreUsing Pictures as Cell Values in Excel Formulas Overview Welcome to the second post in the Pictures in Excel series! In this tutorial, we will learn how to insert pictures as cell values in Microsoft Excel and utilize these pictures in formulas. By the end of this tutorial, you will be able to store images…
Read MoreInserting Pictures into Cells in Microsoft Excel: A Step-by-Step Guide Overview Hello and welcome to the first post in the Pictures in Excel series! In this first post, we will explore a new feature in Microsoft Excel that allows you to insert pictures directly into cells. This feature provides a range of benefits, and we…
Read MoreWelcome 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…
Read MoreIf you need to calculate the age in years based on a list of birth dates in Excel, fear not! In this short tutorial, we’ll cover a few functions that will help, as well as a method to count the number of rows in each age group. Specifically, we’ll explore the YEARFRAC, TRUNC, DATEDIF, and…
Read MoreIf 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…
Read MoreUsing Microsoft Excel to compare two columns is a great way to look for discrepancies or similarities between two different sets of data. This post provides 3 different ways to accomplish this so that you can use the one that is most appropriate for your data and workbook. Video Step-by-step guide Let’s work through each…
Read More