Replace legacy formulas with MAP, BYROW, BYCOL, SCAN, and REDUCE to build secure, scalable, and automated spreadsheets.

Switch from manual entries to automated generators that keep your spreadsheets clean, consistent, and error-free.

Master calculating the discount rate in Excel, understand the discount factor, and explore how it links with NPV and investment returns.

Dana Miranda is a Certified Educator in Personal Finance, creator of the Healthy Rich newsletter and author of You Don't Need a Budget: Stop Worrying about Debt, Spend without Shame, and Manage Money ...

Averaging isn’t always a simple total divided by the number of items totaled. Fortunately, Microsoft Excel offers several averaging functions, and one of them will probably get the job done. In this ...

Doug Wintemute is a staff writer for Forbes Advisor. After completing his master’s in English at York University, he began his writing career in the higher education space. Over the past decade, Doug ...

How to average with and without the highest and lowest values in Excel Your email has been sent The article How to do more advanced averaging in Excel reviews Microsoft Excel’s many averaging ...

Excel macros let you automate repetitive tasks for substantial time savings. Here’s how to put them to work for you. If you regularly work with Excel spreadsheets, you probably find yourself repeating ...

Alan is a technology author based in Nova Scotia, Canada. A computer enthusiast since his youth, Alan stays current on what is new and what is next. With over 30 years of experience in computer, video ...

Microsoft Excel is quite powerful in what it can be used for. If you’re one of the many folks who use Excel for financial data where exchange rates are concerned, you need to learn how to get currency ...