fbpx
Search
Close this search box.

All articles with 'downloads' Tag

Weighted Average in Excel [Formulas]

Published on Mar 14, 2024 in 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.

Continue »

What is XLOOKUP and how to use it in Excel?

Published on Mar 12, 2024 in 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.

Continue »

Loan Amortization Schedule in Excel – FREE Template

Published on Feb 20, 2024 in Financial Modeling, Learn Excel
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.

Continue »

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

Published on Feb 14, 2024 in Excel Howtos, Learn Excel
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.

Continue »

Beautiful Staff Roster Excel Template [FREE Download]

Published on Feb 6, 2024 in Learn Excel, Templates
Beautiful Staff Roster Excel Template [FREE Download]

Do you want to manage your staff’s allocations, shift schedules and view the results in a 4 week grid fashion (like below)? Then you are going to love my FREE Staff Roster Excel Template. What can you do with this template? Template Compatibility This template is designed to work with modern Excel only. You need […]

Continue »

How to calculate time between two dates in Years, Months & Days [Excel Formula]

Published on Jan 29, 2024 in Excel Howtos, Learn Excel
How to calculate time between two dates in Years, Months & Days [Excel Formula]

Let’s say you have two dates in the cells D4 & D5 as above. You want to find out the duration in years, months & days between both. We can use the good-old DATEDIF formula for this.

Continue »

FREE Calendar & Planner Excel Template for 2024

Published on Jan 7, 2024 in Learn Excel, Templates
FREE Calendar & Planner Excel Template for 2024

Here is a fabulous New Year gift to you. A free Calendar & Activity planner made entirely in Excel. A fully customizable and flexible calendar for all your planning needs.

Continue »

Calculating Critical Path using Excel Formulas [Project Management]

Published on Oct 3, 2023 in Learn Excel, Project Management
Calculating Critical Path using Excel Formulas [Project Management]

Do you know that we can easily calculate the critical path for a project using Excel formulas?

For a long time, it has been tricky to calculate the Critical Path using Excel formulas. But thanks to the arrival of new Dynamic Array functionality in Excel, we can now calculate critical path. In this article let me describe the approach with an example.

Put on your hardhats, this one is going to blow your minds.

Continue »

How to make a pivot table when you have data in multiple sheets [Tutorial]

Published on Sep 26, 2023 in Learn Excel, Pivot Tables & Charts, Power Query
How to make a pivot table when you have data in multiple sheets [Tutorial]

Recently I had to create a Pivot report from monthly data. But there is a twist. The data is spread across multiple sheets, one for each month. Let me explain how I built the pivot for that scenario.

Continue »

Python is in Excel! – Here is a complete getting started guide for you

Published on Sep 5, 2023 in Learn Excel, Python
Python is in Excel! – Here is a complete getting started guide for you

Python ? is in Excel now! Learn how to use Python in Excel with Sample data, 10 Code Examples and tips with this complete guide.

Continue »

Top 10 Accounting KPIs and How to Calculate them in Excel?

Published on Aug 8, 2023 in Financial Modeling, Learn Excel
Top 10 Accounting KPIs and How to Calculate them in Excel?

We can calculate any Finance & Accounting KPI values using Excel easily. In this article, I  am sharing the top 10 accounting KPI calculations. These are… Topics ? Net Profit Margin Net Profit Margin = Net Profit / Sales Positive profit margin indicates business is profitable while negative indicates the business is in loss. ? […]

Continue »

Make an Impressive Interactive Map Chart in Excel

Published on May 23, 2023 in Charts and Graphs
Make an Impressive Interactive Map Chart in Excel

Today, let’s learn how to make an impressive map chart with Excel. Something like this.

Continue »

A clever technique to simplify your long, nested IF formulas

Published on Apr 11, 2023 in Formula Forensics, Learn Excel
A clever technique to simplify your long, nested IF formulas

Recently I used an elegant and smart technique to simplify lengthy nested IF formulas and made them 80% shorter. In this article, let me explain the process and share the results.

Continue »

Create a beautiful, elegant & interactive to-do list with Excel (FREE Template + Tutorial)

Published on Mar 28, 2023 in Learn Excel, Templates
Create a beautiful, elegant & interactive to-do list with Excel (FREE Template + Tutorial)

Create a beautiful & fully interactive todo list with Excel using this tutorial (or download the free todo list template). Impress everyone.

Continue »

Learn Advanced Excel – 3 Month Roadmap with Resources

Published on Jan 30, 2023 in Learn Excel
Learn Advanced Excel – 3 Month Roadmap with Resources

Advanced Excel Skills are highly sought after. Use this FREE Excel roadmap to learn and grow you Excel skills in 3 months.

Continue »