Please turn JavaScript on
header-image

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.97 / week

Message History

Ever wish Excel could tell you a fun cat or dog fact every time you click refresh? Good news — it can! In this post, we’ll walk through a short, practical project that uses Power Query to pull random facts about cats and dogs from public APIs directly into your worksheet. Whether you’re a pet…

The post


Read full story

How to Get Live Weather Data in Excel Using Power Query and Geography Data Types (Includes a Summary of Posts 1-3) Have you ever wanted to turn Excel into your very own weather dashboard? With a few powerful Excel features, like the Geography Data Type, the WEBSERVICE() and FILTERXML() functions, and Power Query, we can…

The post


Read full story
Weather 3

Using Power Query to Get AM/PM Temperatures by Day in Excel Let’s be honest—weather data inside a spreadsheet might seem like magic. With Excel’s built-in tools like Power Query and the Geography Data Type, we can pull live weather forecasts, break them down by day, and split them into AM and PM temperatures. In this…

The post


Read full story
Weather 2

Create a Dynamic Weather Forecast in Excel This is the second post in the Weather series. In this post, we’ll walk through how to build a dynamic weather forecast tool using Excel and Power Query. By the end, we’ll be able to simply click Refresh, and Excel will pull in the latest weather forecast based…

The post


Read full story
Weather 1

How to Retrieve Latitude and Longitude in Excel from City and State This is the first post in a larger 3-part weather forecasting series we’ll build together. Along the way, we’ll sharpen our skills with the WEBSERVICE and FILTERXML functions, as well as utilize Power Query in upcoming tutorials. In this initial post, we’ll take…

The post


Read full story