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.
Posts
Managing finances effectively often requires understanding how long it will take to pay off a loan or reach a savings goal. Excel’s NPER function helps us determine the number of periods needed based on interest rate, payments, and loan amounts. Whether we’re looking at loans, mortgages, or investments, this function is crucial for financial planning.…
Read More
Ever wondered how much you need to save each month to reach a financial goal, like becoming a millionaire? The PMT function in Excel can help you calculate that with just a few simple inputs. While the PMT function is traditionally used to calculate loan payments, we can also use it to determine how much…
Read More
If you’ve ever wished Excel could just “do the work for you,” then Microsoft Copilot might be exactly what you need. This AI-powered assistant can generate formulas, analyze data, apply formatting, and even explain complex calculations—all with simple, natural-language commands. Want to access Copilot? Check out this Microsoft Office 365 Bundle which includes Copilot, Excel,…
Read More
Planning an event can be a challenge, especially when tracking invitations and RSVPs. Fortunately, Microsoft offers a free Invitation Tracker template that can help streamline the process. Whether you’re organizing a wedding, birthday party, or corporate event, this template provides an easy way to manage guest lists, invitation statuses, and responses. In this guide, we’ll…
Read More
Imagine having an on-demand tutor watching over your shoulder, ready to help with Excel formulas, formatting, and reports. Thanks to Google AI Studio, this is now possible! In this post, we’ll explore how Google AI Studio can assist with real-time Excel problem-solving. Video Getting Started with Google AI Studio We’ll use Google AI Studio to…
Read More
If you’ve ever wanted to create a reusable calendar that automatically updates each year with birthdays, holidays, and special events, then this tutorial is for you! In this guide, we’ll walk through how to use an Excel template to set up a dynamic events calendar—perfect for printing and gifting to family members each year. By…
Read More
A spin button in Excel is a great way to create an interactive and dynamic scrolling range for reports, dashboards, or data analysis. In this tutorial, we’ll walk through how to insert a spin button, link it to a cell, and use it to scroll through data by days, weeks, months, quarters, and years. Let’s…
Read More
If you’re managing projects and need a simple way to track progress, Excel’s Agile Gantt Chart template can be a great starting point. This built-in template provides a visual representation of tasks, milestones, and progress, making it easier to stay organized. Video Step-by-step Guide In this guide, we’ll walk through how to: Let’s dive in!…
Read More
When working with messy data, we often turn to Excel, but with the rise of AI tools like ChatGPT, we now have new ways to tackle these challenges. In this post, we’ll compare Excel and ChatGPT side by side, using three common data tasks: We’ll see how each tool handles the job, the pros and…
Read More
Managing your personal finances is easier when you have a structured budget in place. Fortunately, Excel provides built-in budget templates that can help you track your income, expenses, and savings without starting from scratch. In this guide, we’ll walk through how to find, use, and customize a simple annual budget template in Excel to fit…
Read More