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

# PivotTable

## PIVOTBY A Dynamic PivotTable Alternative

| January 16, 2024 |

Excel’s PIVOTBY function allows you to create dynamic summary reports that look very much like PivotTables. However, they are totally dynamic … no need to click Refresh. They are created with a single formula, but do not have the rich features and capabilities of PivotTables. Depending on your workbook, the PIVOTBY function may be a…

## Dynamic Pivot-style Report with GROUPBY

| January 9, 2024 |

In this tutorial, we will learn how to use the GROUPBY function to create dynamic pivot-style reports with a single formula. Let’s back up a sec. For years, we’ve turned to PivotTables to build summary reports. Now we have another option: the GROUPBY function. While it doesn’t create a true PivotTable, it does create a…

## Pictures in Excel 5: Pictures in Data Types

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

## Pictures in Excel 4: Pictures in PivotTables

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

## Excel Tips from 20 Experts

| February 21, 2023 |

My friend John Michaloudis does an annual survey of Excel MVPs and experts and asks for their best Excel tip. He compiles the tips into an audio podcast along with show notes and related links. This is a great resource and I love sharing it every year. This year, he rounded up tips from: You’ll…

## Top 5 Excel Calendar Tutorials & Free Templates

| June 28, 2022 |

Do you use Excel to keep track of your to-do lists, upcoming events, deadlines, etc.? Since spreadsheets are so customizable, many Excel users rely on the software to create unique calendars tailored to their needs. It’s one of the most popular uses for Excel and great practice for users of all skill levels. If you’re…

## Even Pros Could Learn a Thing or Two From These 8 Advanced Excel Tips

| June 21, 2022 |

## How to Become Proficient in Excel in 6 Easy Steps

| June 15, 2022 |

Do you know the Excel basics, but want to become a pro? We’re outlining the six steps you can take to learn how to become proficient in Excel.

## Excel University’s Top 5 Power Query Tutorials

| May 31, 2022 |

Power Query is one of the most useful Excel tools, and it’s surprisingly easy to learn! See our top 5 Power Query tutorials to get hands-on practice.