Excel Basics

How to Find Duplicates in Excel Workbook (5 Methods)

Finding duplicates in an Excel workbook is essential for maintaining data accuracy. Identifying duplicate values ensures that the information within ...

Concatenate Not Working in Excel (3 Reasons with Solutions)

Often there are situations in Excel when concatenate is not working. Usually, MS Excel has three ways to join cell values. For example, we can use ...

How to Merge Duplicates in Excel (6 Ways)

If you are looking for some of the easiest ways to merge duplicates in Excel, then you are in the right place. It can be helpful for a dataset ...

How to Delete Filtered Rows in Excel?

Excel provides the user with a great functionality named Filter which helps us to only view the data we need while hiding all the non-relevant data. ...

How to Calculate Due Date with Formula in Excel (7 Ways)

In Excel, we can easily calculate the due date of a project by using the DATE formula, EDATE Function, YEARFRAC Function, and WORKDAY Function. ...

How to Use VBA AutoFill in Excel (11 Examples)

Using autofill in Excel with VBA is a great tool to use while working with data that is repetitive or in a sequential pattern. Excel gives us several ...

How to Use IF Formula with Dates (6 Easy Examples)

While working in Microsoft Excel, there are various formulas to make our work easier. IF formula is one of them. It has a wide range of applications ...

How to Insert Current Date in Excel (4 Suitable Examples)

When making an assignment, report, or any other business-related document, it’s pretty common to add the current date. Sometimes we need to insert it ...

How to Use Excel Date Shortcut

This article illustrates how using Excel date shortcut makes dealing with dates in Excel easier. While making reports, budgets, calendars, and ...

How to Calculate Hours and Minutes for Payroll Excel (7 Easy Ways)

Often, we need to calculate time differences in Excel. In this article, we demonstrate ways to calculate hours and minutes for payroll in Excel. ...

How to Use COUNTIF Between Two Numbers (4 Methods)

Sometimes while working in Microsoft Excel we need to count cells between two numbers. We can do this with the COUNTIF function. The COUNTIF function ...

How to Change Time Format in Excel (4 Ways)

Microsoft Excel offers a variety of time-saving tools, and understanding them can save you a lot of time. In order to specify precise information, ...

How to Copy Formula to Entire Column in Excel (7 Ways)

To copy formulas in Excel is one of the easiest works. Microsoft Excel offers many ways to do the same work and in this article, we’ll get to learn ...

How to Add Minutes to Time in Excel (5 Easy Ways)

We can put time values together to generate a cumulative time value. Since time values are only a decimal extension of the date serial numbering ...

How to Sum Time in Excel (9 Suitable Methods)

In this article, we will demonstrate to you how to sum time in Excel. While working in Excel, we may need to add time. To clarify the process of ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo