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.
Excel
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
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…
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
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…
Read More
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…
Read More
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…
Read More
When it comes to understanding the true cost of borrowing, we can’t afford to rely solely on advertised rates. Terms like APR (Annual Percentage Rate) and APY (Annual Percentage Yield) might seem interchangeable, but they tell very different stories due to compounding. With Excel’s built-in financial functions like NOMINAL, EFFECT, PMT, and RATE, we can…
Read More
Understanding how loan payments are structured can feel overwhelming but Excel gives us powerful tools to make these calculations quick and simple. Whether we’re evaluating monthly payments, interest breakdowns, or savings from early payoff, Excel’s financial functions (PMT, IPMT, PPMT, CUMPRINC, CUMIPMT) help us every step of the way. This post is brought to you…
Read More
Mastering 5 Key Financial Functions: PMT, PV, FV, NPER, RATE Whether we’re planning to buy a car, save for retirement, or pay off a loan, numbers play a central role in our financial journey. Excel gives us powerful tools to analyze and plan financial scenarios. In this post, we’ll walk through five key Excel financial…
Read More