Search

All articles with 'formulas' Tag

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

Published on Jan 29, 2024 in Excel Howtos, Learn Excel

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 »

Calculating Critical Path using Excel Formulas [Project Management]

Published on Oct 3, 2023 in Learn Excel, 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 »

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

Published on Aug 8, 2023 in Financial Modeling, Learn 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 »

How to write complex Excel formulas (hint: it’s a lot like LEGO)

Published on Dec 9, 2021 in Excel Howtos, Learn Excel

Writing advanced formulas is a lot like LEGO. Use what you already have and combine them in creative ways. Let me demo with 5 examples.

Continue »

Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.

Downloads

© All rights reserved.