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

How to Become a Millionaire with this Simple Formula (PMT)

By Jeff Lenning | April 15, 2025 |

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

Getting Started with Excel Copilot

By Jeff Lenning | April 8, 2025 |

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

Wedding Invitation Tracker

By Jeff Lenning | April 1, 2025 |

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

Use Google AI Studio for Real-time Excel Assistance

By Jeff Lenning | March 25, 2025 |

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

Free Birthday Calendar for Gifts

By Jeff Lenning | March 18, 2025 |

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

Dynamic Scroll Range

By Jeff Lenning | March 11, 2025 |

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

Free Project Tracker Template

By Jeff Lenning | March 4, 2025 |

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

Excel vs ChatGPT

By Jeff Lenning | February 25, 2025 |

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

Free Personal Budget Template

By Jeff Lenning | February 18, 2025 |

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

Unbelievable Dashboards (in 3 easy steps)

By Jeff Lenning | February 11, 2025 |

Creating an interactive Excel dashboard doesn’t have to be complicated. With just a few steps, we can transform raw data into a dynamic, easy-to-read report that updates automatically as new data comes in. In this guide, we’ll walk through the process of building an Excel dashboard using pivot tables, pivot charts, and a timeline filter.…

Read More