Please turn JavaScript on
Excel University icon

Excel University

Click on the "Follow" button below and you'll get the latest news from Excel University via email, mobile or you can read them on your personal news page on this site.

You can unsubscribe anytime you want easily.

You can also choose the topics or keywords that you're interested in, so you receive only what you want.

Excel University title: Home - Excel University

Is this your feed? Claim it!

Publisher:  Unclaimed!
Message frequency:  0.15 / day

Message History

If you export data to a CSV file every month and then copy-paste it into Excel, this tutorial is for you. That manual import and cleanup routine can be fully automated with Power Query. We load the CSV once, apply any transformations we need, and from that point forward it is a single-click refresh. No…

The post


Read full story

Excel Canvas is a powerful new feature that lets us create stunning, interactive dashboards straight inside our workbook. Using Copilot, we simply describe what we want, and Excel generates a polished HTML-based canvas sheet that is dynamically linked to our source data. No manual chart building, no layout wrestling. In this tutorial, we walk through…

The post


Read full story

A brand new capability has dropped in Excel, and it changes something we thought was a hard rule: every cell holds one value. Not anymore. Excel now lets us store multiple values, entire lists, and even full 2D tables, inside a single cell. This feature has a few names: Lists, Arrays in Cells, or Nested…

The post


Read full story

Have you ever typed a SUM formula, hit Enter, and stared in disbelief at a big fat zero? The culprit is almost always the same: numbers that are stored as text. Excel sees those values as words, not quantities, so it simply adds up nothing. In this tutorial, we walk through three practical ways to…

The post


Read full story