Excel Basics

How to Autofill Numbers in Excel Without Dragging (5 Methods)

Method 1 - Using the Fill Series Option to Autofill Numbers We're going to create a series of numbers in multiples of 15, up to 200. Steps:  ...

How to Convert Columns to Rows in Excel (3 Easy Ways)

We'll use a sample dataset with five columns: Serial No., Products, Volume, Unit Cost, and Revenue to illustrate how to take data arranged in columns ...

How to Sort by Last Name in Excel – 5 Methods

The sample dataset contains 10 Full Names. Method 1 - Using the Find & Replace Feature in Excel to Extract and Sort by Last Name ...

How to Auto Sort in Excel When Data Is Entered (4 Easy Ways)

Consider the following dataset with 6 rows and 3 columns. Initially, we are keeping all the cells in General format. For all the datasets, we have 3 ...

How to Find Duplicates in Excel (All Criteria Included)

⏷1. Using Conditional Formatting to Find & Highlight Duplicates in Excel    ⏵1.1. Highlighting Duplicates in Excel with Duplicate Values Command ...

How To Search Multiple Items in Excel Filter (2 Ways)

  We have a simple table having a few random Persons from different Countries and their respective Favorite Sports and Favorite Player. We ...

How to Do Advanced Sorting in Excel (9 Suitable Examples)

In this article, we will demonstrate several effective techniques for Advanced Sorting in Excel: Sorting from top to bottom. Sorting from ...

How to Sort Two Columns to Match in Excel (2 Simple Methods)

We will use a dataset that includes Items Produced in 2021 and Items Produced in 2022 of a company. Method 1 - Sort Two Columns to Match ...

How to Sort Alphabetically and Keep Rows Together in Excel: 4 Smart Ways

Method 1 - Employ Sort Feature 1.1 Sort Alphabetically Without Empty Column Steps: Select any of the column cells that you want to sort. Sort ...

How to Swap Rows in Excel (4 Easy Ways)

For this tutorial, we'll use the following table as our dataset. Our goal is to swap the rows of the table using 4 different methods. ...

How to Auto Sort Multiple Columns in Excel (2 Useful Methods)

We have made a dataset named Dataset of Sales. It has column headers Sales Rep. and Sales. Method 1 - the Using SORT Function We need to ...

How to Sort Multiple Columns in Excel Independently of Each Other (2 Easy Ways)

We have a dataset of fruits with their delivery information and quantities. We are going to sort those columns independently. Method 1 - ...

How to Filter Multiple Columns Independently in Excel (5 Methods)

The dataset shows 10 delivery products of a company. It mentions the product ID, product name, quantity, delivery location, order date, and shipping ...

How to Filter Multiple Columns Simultaneously in Excel: 4 Methods

In the following dataset, you can see the ID Number, Sales Rep., Location, Product, and Sales columns. We'll filter the results by multiple columns. ...

How to Copy and Paste Without Changing the Format in Excel: 4 Methods

Method 1 - Quickest Method: Use the ‘Keep Source Column Widths (W)’ Command Step 1: Select source cells B6:C16 and press Ctrl+C to copy them. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo