Excel Basics

How to Compare Two Excel Sheets for Duplicates (5 Quick Ways)

  Method 1 - Viewing Two Excel Sheets Side by Side to Find Duplicates Let’s consider we have an Excel workbook with two sheets. Here, we will ...

How to Sum a Column in Excel (10 Easy Methods)

Download Practice Workbook Calculating the Sum of a Column.xlsx Method 1 - Use Arithmetic Formula Steps: Go to cell C12 and insert ...

How to Add Rows with Formula in Excel: 5 Easy Methods

Method 1 - Apply Simple Mathematical Expressions Steps: We have the rows with values in them. Need to calculate the content of the rows in ...

How to Insert a Column in Excel (6 Easy Ways)

Method 1 - Using the Column Heading Context Menu Right-click on the column heading to open the context menu. Select the Insert option. A ...

How to Sum the values in a Column in Excel – 7 Methods

Download Practice Workbook Download the workbook. Add the Sum of a Column.xlsx This is the sample dataset. Method 1 - ...

How to Change the Row Height in Excel – 6 Methods

This is the sample dataset. Method 1 - Using Row Height Command Steps: Select B14:D14. Go to: Home >> Cells >> Format ...

How to Use Multiple IF Statements with Text in Excel (6 Methods)

Below is a dataset with the examination records of some school students. Our objective is to find the overall result of each student based on their ...

Formula to Find Duplicates in Excel (6 Suitable Examples)

  Method 1 - Using Logical Formula with COUNTIF to Find Duplicates in One Column in Excel Consider a column of item names like fruits in ...

How to Remove Duplicates but Keep the First Value in Excel

Here we’ve got a data set with the Names, IDs, Marks, and Grades of students in an examination of Sunflower Kindergarten. Our objective is to delete ...

How to Remove Duplicates Based on Criteria in Excel – 7 Methods

The following dataset contains “Customer Name” and “Item Sold” columns. There are duplicate values. Method 1 - Using an Advanced Filter to ...

How to Filter Duplicates in Excel (7 Suitable Ways)

Let’s get introduced to the data table first. We have a table that has 3 columns and 14 rows. The columns are named Ship Mode, Province, and Customer ...

Excel Formula to Find Duplicates in One Column (8 Easy Ways)

Method 1 - Using the COUNTIF Function to Find Duplicates in One Column Along with the First Occurrence We have a list of names in column B. The ...

Highlight Duplicates Across Multiple Worksheets in Excel (3 Formulas)

Method 1 - Use COUNTIF Function to Highlight Matches Across Excel Worksheets The following picture represents a worksheet named Sheet1. It contains ...

How to Fill Down to Last Row with Data in Excel (4 Easy Ways)

Here we’ve got a data set with the Names and Joining Dates of some employees. We'll fill the Employee IDs up to the last row automatically. ...

The Excel Autofill is Not Working – 7 Issues and Solutions

Solution 1 -  Getting Repetitions of a Number Instead of a Series While Using Autofill In Column B, the Fill Handle was used to make a series of ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo