Excel Basics

SUM Not Working with Time Values in Excel: 5 Methods

Method 1 - Get the SUM of Time Value Inserting Individual Cells Step 1: Go to Cell E5. Find the sum of the Cells C5 and D5 using the ...

How to Delete Rows Using Excel Shortcuts

While working with Microsoft Excel, you will face a lot of situations where you need to delete rows. Some people love to work with the mouse and the ...

How to Use the Format Painter Shortcut in Excel

What is Format Painter? In Microsoft Excel, the Format Painter is a powerful tool that allows you to copy the formatting from one cell or range of ...

How to Hide Duplicates in Excel (4 Methods)

Dataset Overview To explain this process clearly, let’s use a sample dataset from an online fruit store. The dataset contains 5 columns representing ...

How to Delete Hidden Rows in Excel: 3 Methods

Method 1 - Utilizing the ‘Inspect Document’ Option to Delete Hidden Rows in Excel Hide the highlighted rows, select the rows. Right-click on ...

Example with Absolute Cell Reference in Excel (4 Apllications)

In this article, we will let you know what absolute cell reference in Excel is and describe it with 4 useful examples. What is Absolute Cell ...

How to Calculate Time in Excel (17 Possible Ways)

For illustration, we will use the sample dataset below. Method 1 - Calculate Time Difference in Excel Using Operator ⏩ In cell E4, type ...

How to Timesheet Formula in Excel: 5 Methods

Method 1 - Excel Timesheet Formula: Using Simple Subtraction Apply the simple arithmetic subtraction formula within this Excel timesheet. To do ...

How to Find Duplicates in Excel Workbook (5 Methods)

Suppose there are two sheets in the workbook named Sheet1 and Sheet2. Sheet1 represents the employee name with their states while Sheet2 displays the ...

Why Concatenate Isn’t Working in Excel (3 Common Reasons and Solutions)

Dataset Overview We'll use the below dataset containing the lists of first names and last names to investigate why Concatenation is not working: ...

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 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)

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 ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo