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

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

Excel Tips from 20 Experts

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

Read More
Man making notes on a large calendar underneath an open laptop

Top 5 Excel Calendar Tutorials & Free Templates

By Excel University | 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…

Read More
Woman pointing to the left while thinking about advanced Excel tips

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

By Excel University | June 21, 2022 |

Looking for some advanced Excel tips to help you become a spreadsheet pro? We’re sharing 8 tips that will take your skills to the next level!

Read More
Businesswoman walking up steps that represent how to become proficient in Excel in 6 easy steps

How to Become Proficient in Excel in 6 Easy Steps

By Excel University | 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.

Read More
Woman looking at a desktop computer screen comparing two lists.

Excel University’s Top 5 Power Query Tutorials

By Excel University | 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.

Read More
Woman sitting in front of laptop with a cup of coffee while learning the top Excel skills

These Top Excel Skills are Surprisingly Easy to Learn

By Excel University | May 24, 2022 |

You don’t need to be a spreadsheet pro to master these top Excel skills! See our list of easy-to-learn Excel skills with hands-on tutorials.

Read More
Man sitting at a computer with an hourglass trying to learn how to get better at Excel

How to Get Better at Excel (Without Wasting Time)

By Excel University | April 25, 2022 |

Wondering how to get better at Excel? Whether you’re a new user or a pro, these are some easy steps to help you quickly master new skills.

Read More
Text over a man standing underneath lightbulbs that reads "How to Use Pivot Tables in Excel - Our Top 5 Posts"

Learn How to Use Pivot Tables in Excel – Our Top 5 Posts

By Excel University | April 12, 2022 |

Excel’s PivotTables are one of its most useful features. Learn how to use pivot tables in Excel with our Top 5 PivotTable posts!

Read More