ExcelDemy | Free Excel Tutorial & Online Courses

How to Update One Excel Worksheet from Another Sheet Automatically

Jun 23, 2021 Excel Basics

Provided that you have prepared a worksheet on your workbook and you want to utilize it in another sheet. In this situation, you can unconsciously ...

Excel Formula to Count Cells with Text

Jun 23, 2021 Excel Formulas

Microsoft Excel provides a wide range of useful functions & methods to count cells with text or any other characters & strings. In this ...

How to Sum Cells with Text and Numbers in Excel

Jun 23, 2021 Excel Formulas

Adding cells in Excel is a simple yet powerful task. There are several ways to sum cells with numeric data in Excel. I have already covered some of ...

Excel Auto Generate Number Sequence (5 Simple Ways)

Jun 23, 2021 Excel Formulas

Serializing a lot of elements manually in Excel is boring. To get rid of this monotonous issue, I’m going to show you how to generate a number ...

How to Count Cells with Specific Text in Excel (Both Case Sensitive and Insensitive)

Jun 23, 2021 Excel Formulas

While working in Excel, we often have to count cells with some specific text. Today I will show some easy ways to achieve that. Download File How ...

Excel Formula to Calculate Number of Days Between Today and Another Date (6 Quick Ways)

Jun 23, 2021 Excel Basics

Do you want to calculate the number of days between today and the other date? You can easily compute the number of days using Excel. In this ...

How to Use Conditional Formatting in Excel Based on Dates

Jun 22, 2021 Excel Basics

Conditional formatting has been used in Excel for quite some time now. But what is conditional formatting, and how can it benefit you? The process of ...

Excel Automatically Enter Date When Data Entered

Jun 22, 2021 Excel Basics

Microsoft Excel provides a wide range of fruitful ways to show dates along with the timestamps automatically when you enter data. Here I’ll try to ...

How to Insert Dates in Excel Automatically

Jun 22, 2021 Excel Basics

While working with dates in Excel, we often have to take a large number of dates as input. It is quite troublesome to sit down and insert so many ...

How to Calculate Average Tenure of Employees in Excel

Jun 22, 2021 Excel Basics

When you are going to calculate tenure or average tenure, Excel can be a handy tool for you. Today I am going to show you how to calculate average ...

Excel Conditional Formatting Dates Older than Today

Jun 22, 2021 Excel Basics

Sometimes we need to highlight or count dates under different conditions in MS Excel. For this purpose, Excel provides us with great approaches to ...

How to Add Weeks to A Date in Excel [4 Fast and Simple Methods with Template]

Jun 23, 2021 Excel Basics

In certain circumstances, we have to add weeks to a date. Like when you confirm an order for buying something online at a specific date, the company ...

Excel formula to Calculate Age on a Specific Date

Jun 21, 2021 Excel Basics

Excel can be handy while calculating age, you may wonder how easily you can do that. In this article, I’m going to show you how to calculate age on a ...

Excel Formula to Change Cell Color Based on Date

Jun 21, 2021 Excel Basics

While working with Dates in Excel, sometimes we have to differentiate some data based on their dates. It is a good practice to change the cell color ...

Number of Days Between Two Dates Calculator

Jun 22, 2021 Excel Basics

Microsoft Excel provides tons of simple methods to calculate number of days between two dates. A wide range of functions is available to determine ...

Latest Posts