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.
Power Query
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…
Read More
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…
Read More
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…
Read More
Working with ZIP code data in Excel just got easier. With Power Query and a free web service, we can automatically retrieve city, state, and country details associated with any U.S. ZIP code. This approach is extremely helpful for users managing form inputs, mailing lists, or regional datasets who want to automate the lookup process…
Read More
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…
Read More
Did you know Excel can fetch a brand-new Sudoku puzzle with a click of the refresh button? In this tutorial, we’re diving into how to tap into an online Sudoku API and use Power Query to turn that data into a styled and playable puzzle and solution right inside Excel. Even if you’re not much…
Read More
Are you ready to save hours of manual work each week? In this guide, we’ll explore how to automate your workflow in Excel using tools like Power Query, Pivot Tables, and Pivot Charts. Best of all, you don’t need to be a coding wizard to get started. By the end, you’ll know how to effortlessly…
Read More
Hello and welcome to our guide on how to split amounts into annual columns! We will tackle this using a built-in tool called Power Query. If you’ve never used Power Query in Excel before, no worries, I’ll guide you through the process one step at a time! Video Objective We are trying to split a…
Read More
Today we will tackle a common question: “How can we combine numerous tables that are in the same workbook?” Let’s dive right in and learn how to easily combine tables, even if they have different column orders! Video Step-by-step Process In this guide, we’ll explore how to use Power Query to combine several tables from…
Read More
I was recently asked the following question: I download an excel file every week and make changes like deleting columns, counting and adding rows and so on. Can I automate this repetitive task ? In this post, I’ll attempt to answer this question. The built-in Excel feature we’ll use to accomplish this is Power Query.…
Read More