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.
Functions
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…
Wouldn’t it be great if Excel could automatically generate a list of public holidays based on a single year input? And even better, have that holiday table update all related formulas and schedules across your workbook? Well, that’s exactly what we’re going to build in this post—an automatic calendar in Excel with public holidays, dynamically…
Manually searching for currency exchange rates is a thing of the past. With Excel’s smart integrations, we can now pull real-time foreign exchange data into our workbooks using built-in features and free web APIs. Whether we are looking up current rates or building a currency converter, Excel has all the tools we need to get…
Have you ever wanted Excel to automatically return the City and State when simply entering a ZIP code? In this guide, we’ll explore three reliable methods to make that magic happen. Using Excel Copilot, Power Query, and traditional Excel functions, we’ll show how to pull accurate location data from a ZIP code using a live…
By the end of this post, you’ll be able to enter a zip code into a cell and Excel will automatically populate the city and state cells! Specifically, we’ll use Excel’s WEBSERVICE and COPILOT functions. Think of this as combining the power of AI with Excel’s brilliant data connectivity. Video Overview of the Solution This…
Imagine being able to type a zip code into a cell in Excel and have the corresponding city and state automatically fill in. No manual entry, no lookup tables … just a smart, seamless automation. In this walkthrough, we’ll explore how to tap into a free zip code API using Excel’s WEBSERVICE function, and then…
Did you know Excel can be your new favorite Sudoku playground? That’s right! Using a clever combination of formulas, Power Query, or the COPILOT function, we can dynamically generate Sudoku puzzles and solutions directly within our workbooks. In this article, we’ll explore three powerful methods that bring Sudoku to life right inside Excel. Plus, we’ll…
We’re always on the lookout for ways to automate repetitive tasks in Excel. And today, we’re diving into something a bit more fun: building Sudoku puzzles in Excel with the COPILOT and WEBSERVICE functions. Whether you’re a puzzle enthusiast or just looking to expand your Excel skills using its latest AI tools, this practical walkthrough…
Microsoft Excel’s new COPILOT function brings the power of large language models (LLMs) directly into the worksheet. Unlike the Copilot chat pane, the COPILOT function allows us to perform natural language tasks right in the grid, just like any native Excel function. In this post, we’ll walk through how to use the COPILOT function to…
Did you know we can auto-generate Sudoku puzzles right inside Excel, without manually entering grid layouts? With the WEBSERVICE function and a little help from a Sudoku API, we can create both a playable Sudoku puzzle and its corresponding solution dynamically. In this step-by-step guide, we’ll show how to make a Sudoku board using Excel’s…