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.
Geography
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…
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…
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…
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…
As a quick follow up to my previous post about the Stocks data type, I wanted to talk about another data type: Geography. With the Geography data type, we can retrieve rich geographical data into Excel. Let’s check it out. Objective Let’s say we are working on a project and we wanted to create a…