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.

Jeff Lenning

Intro to AI Automation with Zapier

By Jeff Lenning | May 13, 2025 |

When it comes to automation, Excel users can certainly streamline tasks within the grid. But sometimes, we need to automate tasks outside of Excel—especially when it comes to integrating external tools and triggering actions automatically. That’s where Zapier comes in. In this post, we’ll take a beginner-friendly dive into Zapier’s AI automation capabilities by creating…

Read More

PV: Value Your Money Now

By Jeff Lenning | May 6, 2025 |

Understanding the concept of present value can be one element in our financial decision making process. From evaluating loans and subscriptions to complex financial instruments like reverse mortgages, Excel’s PV function provides an accessible, effective tool for comparing future payments in today’s dollars. In this post, we’ll explore how to use the Excel PV function…

Read More

RATE: Find Your Interest Rate

By Jeff Lenning | April 29, 2025 |

Understanding how to calculate interest rates is crucial for financial planning. Whether you’re determining the interest rate for a loan or projecting your investment growth, Excel’s RATE function is a powerful tool. In this post, we’ll explore how to use the RATE function to unlock hidden financial insights, covering loans, balloon payments, and investment goals.…

Read More

NPER: Time Your Payoff

By Jeff Lenning | April 22, 2025 |

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

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