Excel Basics Archives - Page 146 of 176

How to Hide Duplicates in Excel (4 Methods)

Jul 28, 2024

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 Hide Duplicates in Excel (4 Methods)

How to Delete Hidden Rows in Excel: 3 Methods

Jul 6, 2024

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

How to Delete Hidden Rows in Excel: 3 Methods

Example with Absolute Cell Reference in Excel (4 Apllications)

Nov 11, 2025

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

Example with Absolute Cell Reference in Excel (4 Apllications)

How to Calculate Time in Excel (17 Possible Ways)

Jul 3, 2024

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

How to Calculate Time in Excel (17 Possible Ways)

How to Timesheet Formula in Excel: 5 Methods

May 28, 2024

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

How to Timesheet Formula in Excel: 5 Methods

How to Find Duplicates in Excel Workbook (5 Methods)

Jun 16, 2024

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

How to Find Duplicates in Excel Workbook (5 Methods)

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

Jul 28, 2024

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

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

How to Merge Duplicates in Excel (6 Ways)

Jul 6, 2024

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 Merge Duplicates in Excel (6 Ways)

How to Delete Filtered Rows in Excel?

Nov 11, 2025

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)

Jul 6, 2024

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 Calculate Due Date with Formula in Excel (7 Ways)

How to Use VBA AutoFill in Excel (11 Examples)

May 21, 2024

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 VBA AutoFill in Excel (11 Examples)

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

Jul 6, 2024

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 Use IF Formula with Dates (6 Easy Examples)

How to Insert the Current Date in Excel – 4 Examples

Aug 2, 2024

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 Insert the Current Date in Excel – 4 Examples

How to Use Excel Date Shortcut

Nov 11, 2025

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)

Jul 6, 2024

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