Chandoo.org - Learn Excel, Power BI, Charting, Dashboards and VBA online

Latest Tips & Tutorials

Weighted Average in Excel with Percentage Weights

Learn Excel

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

Read This »

March 14, 2024

Excel Howtos

How to get non-adjacent columns with FILTER function in Excel

Excel 365’s FILTER() function is great for getting a cut of data that meets your criteria. But what if you need to filter and then show non-adjacent columns? Something like below. In this article, let me show you a few options to get discrete columns after filtering with the FILTER function.

Read This »

March 12, 2024

xlookup function in Excel - how to use it?

Excel Howtos

What is XLOOKUP and how to use it in Excel?

Think of XLOOKUP as an improved version of VLOOKUP. In this article, learn all about the XLOOKUP function, it’s syntax, parameters with real-world xlookup examples.

Read This »

March 12, 2024

Get bolded portions of a column using getBoldText function

Excel Howtos

Get all BOLD text out Excel Cells Automatically

Use the getBoldText() function in Excel to extract bolded portion of a cell automatically. Saves you time and helps with data cleaning.

Read This »

February 26, 2024

no-spill-error-after-converting-to-range

Excel Howtos

How to fix SPILL Error in Excel Tables (3 easy solutions)

So you have a SPILL error in your Excel tables? In this quick article, let me show you 3 easy fixes to the problem. Fix

Read This »

February 21, 2024

Financial Modeling

Loan Amortization Schedule in Excel – FREE Template

Do you want to calculate loan amortization schedule in Excel? We can use PMT & SEQUENCE functions to quickly and efficiently generate the full loan amortization table for any number of years.

Read This »

February 20, 2024

Excel Howtos

How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]

Do you want to create a dynamic dependent drop down list in Excel like below? You can use XLOOKUP and data validation to set this up quickly. It is fully dynamic and works across a full column too.

Read This »

February 14, 2024