Excel Basics

How to Merge Duplicates in Excel (6 Ways)

We'll use the following table to demonstrate how to merge duplicates in Excel. Method 1 - Using the IF Function to Merge Duplicates with ...

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

We have a dataset where some Project Names and their Starting Date and Total Days to complete these Projects are given in Column B, Column C, and ...

How to Use VBA AutoFill in Excel (11 Examples)

Example 1 - Copy Information Down the Cells Using xlFillCopy Dataset: In Column B, cells B4 and B5 contain numbers 1 and 2. The cells are also ...

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

Excel IF Function Overview Description The IF function tests a condition, then returns one of the two values depending on whether the test is ...

How to Insert the Current Date in Excel – 4 Examples

This is an overview. The date format- MM/DD/YYYY was used. Example 1 - Insert the Current Static Date Using a Keyboard Shortcut in ...

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

Why Formatting Is Important For Measuring Time in Excel? Excel stores Date and Time as numbers. An integer represents a complete day with a starting ...

How to Use COUNTIF Between Two Numbers (4 Methods)

The COUNTIF Function in Excel: Syntax ➤ Description Count cells within specific criteria. ➤ Generic Syntax COUNTIF(range,criteria) ➤ ...

How to Change Time Format in Excel (4 Ways)

Method 1 - Alter the Cell Format to Change Time Format in Excel Step 1: Select the cells in an Excel sheet where you wish to apply or alter the ...

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

Let’s say there's a dataset where different types of Fruits and their prices in January are given in Column B and Column C, respectively. You need to ...

How to Add Minutes to Time Quickly In Excel: 5 Easy Ways

Method 1 - Use Formula to Add Minutes to Time in Excel In the following dataset, column B contains the time, and column C contains the decimal value ...

How to Sum Time in Excel (9 Suitable Methods)

  Method 1 - Using Excel Formula to Sum Time in Excel We will use the following dataset which contains the working hours of staff for Thursday ...

How to Calculate Hours Between Two Times in Excel (6 Methods)

  Method 1 - Calculating Hours Between Two Times by Subtracting Them in Excel We’ve created the following data table to calculate the hours ...

How to Calculate Percentage of Total in Excel? (2 Methods)

Suppose you have a list of your daily or monthly transactions. You want to know in which transaction category you are spending the most. You can get ...

How to Switch Rows and Columns in Excel (5 Methods)

The dataset below shows the market share of smartphone companies. Method 1 – Using the Paste Special (Transpose) Steps: Select the ...

How to Perform If Zero Leave Blank Formula in Excel (3 Methods)

There are several ways to make zero values into blank cells. Here's a GIF overview of how you can do that. 3 Easy Ways to Perform If Zero ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo