ExcelDemy | Page 2 of 31 | Free Excel Tutorial & Online Courses

Excel Conditional Formatting Based on Date in Another Cell

Jun 21, 2021 Excel Basics

Conditional formatting is a useful Excel feature that allows you to show data in a more organized fashion. It is extremely helpful for displaying ...

How to Subtract/Minus Days from Today’s Date in Excel

Jun 21, 2021 Excel Basics

We need to do project scheduling and time management for various purposes. For that, we can use MS Excel for calculating dates. This article will ...

Convert Percentage to Basis Points in Excel(Basis Point Calculation)

Jun 21, 2021 Excel Basics

In the financial world, you may encounter the term Basis Points. It's the usual hearing percentage and basis point simultaneously. Today I will show ...

How to Calculate Average Percentage Calculation in Excel [Free Template + Calculator]

Jun 23, 2021 Excel Basics

Calculating the average percentage may appear to be an uncomplicated task. But it is not like the average where the total value is divided by the ...

Excel Formula to Count Days from Date

Jun 22, 2021 Excel Basics

When working with dates, we often need to calculate the number of days between two dates. In the past, people used to calculate it manually. But at ...

Add Days to Date Using Excel Formula

Jun 20, 2021 Excel Basics

For project planning or time management, we need to make a routine or schedule. Making time schedules, MS Excel provides different ways to add days ...

How to Calculate Overdue Days in Excel(using Functions)

Jun 22, 2021 Excel Basics

Today I’m going to show you how to calculate overdue days in Excel. Calculating overdue is a staple for any form of resource management. For this ...

How to Add/Subtract Years to a Date in Excel

Jun 20, 2021 Excel Basics

In MS Excel, working with date-type values is a necessary requirement. It involves tasks like adding/subtracting days, months, or years to existing ...

How to Find Number of Months between Two Dates

Jun 20, 2021 Excel Basics

Microsoft Excel is one of the greatest tools which allows you to determine the number of months between any two dates by providing a number of unique ...

Percentage Difference between Two Percentages Excel

Jun 20, 2021 Excel Basics

When working with percentages, sometimes we may need to calculate the differences between two percentages. For this purpose, we can get help from MS ...

Percentage Difference between Two Percentages Excel

How to Multiply by Percentage in Excel

Jun 17, 2021 Excel Basics

In MS Excel, calculating changes in percentages or increasing/decreasing percentages are everyday activities. These activities can be completed using ...

How to Calculate Sales Growth Percentage in Excel

Jun 21, 2021 Excel Basics

Calculating Sales Growth after some definite intervals of time is a very important aspect of any business. In the past, people used to do this ...

Subtract a Percentage in Excel

Jun 17, 2021 Excel Basics

In today’s tutorial I’m going to show you how to subtract percentage in Excel. For conducting the session I’m using Microsoft Excel 2019, you can use ...

How to Calculate Grade Percentage in Excel

Jun 18, 2021 Excel Basics

Microsoft Excel provides a number of fruitful & easy methods to calculate grade percentage. Here I’m going to show you the techniques with proper ...

How to Calculate Grade Percentage in Excel

How to Calculate Year over Year Percentage Change in Excel (with Advanced Technique)

Jun 17, 2021 Excel Basics

Need to calculate year over year percentage change for your company? You can do that easily with Microsoft Excel. In today’s session, I will show you ...

Latest Posts