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

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
Piggy bank with a clock on top to represent time saved by learning Excel tips and tricks

Top 8 Excel Tips and Tricks to Save You Time

By Excel University | April 5, 2022 |

These top 8 Excel tips and tricks will free up tons of time and allow you to get more work done even faster.

Read More

Create a Dynamic PivotTable Style Report with One Formula

By Jeff Lenning | March 29, 2022 |

Historically, we’ve had two basic ways to create reports in Excel. We could enter the report labels and use formulas to compute the report values or we could use a PivotTable. Both options had pros and cons. We’d have to pick the report type based on the context of our workbook. In this post, I’ll…

Read More

What Excel Skills are Employers Looking For in 2022?

By Excel University | March 1, 2022 |

Need Excel skills for work? Save time job searching by finding out exactly what Excel skills employers are looking for.

Read More

PivotTable with Multiple Text Values Alternative

By Jeff Lenning | October 5, 2021 |

If you have tried to insert a text field into the values layout area of a PivotTable, you may have noticed that the text string itself is not displayed. Instead, the count is displayed by default. In this series, we are talking about how to display the desired text values by using Power Query instead…

Read More

PivotTable Text Values Alternative

By Jeff Lenning | September 28, 2021 |

This post show how to use Power Query instead of a PivotTable to display text values in a report.

Read More

Stop Wasting Time 4

By Jeff Lenning | May 6, 2019 |

In this post, we are going to use the data model to improve our reporting process. This is the fourth post in the Stop Wasting Time series, and this is where everything we’ve learned comes together. By the time we have finished this post, updating our report will be extremely easy. In fact, it will…

Read More