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

Pictures in Excel 5: Pictures in Data Types

By Jeff Lenning | September 19, 2023 |

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 More

Pictures in Excel 4: Pictures in PivotTables

By Jeff Lenning | September 12, 2023 |

How 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 More

2023 Scholarship Winners

By Jeff Lenning | September 5, 2023 |

I 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 More

Pictures in Excel 3: Pictures with URLs

By Jeff Lenning | August 29, 2023 |

Retrieving 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 More

Pictures in Excel 2: Pictures in Formulas

By Jeff Lenning | August 22, 2023 |

Using 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 More

Pictures in Excel 1: Pictures in Cells

By Jeff Lenning | August 15, 2023 |

Inserting 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 More

Get QuickBooks Exports into Excel with Power Query

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

Read More

Convert Dates into Ages

By Jeff Lenning | August 1, 2023 |

If 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 More

Compare Two Columns with Microsoft Excel Power Query

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

Read More

Excel How To Compare Two Columns (3 ways)

By Jeff Lenning | July 18, 2023 |

Using 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