Excel Basics

How to Merge Rows with Same Value in Excel (5 Quick Ways)

We often face some datasets, that have some repetitive values. In that case, it is very convenient to merge those rows and show them in a single ...

How to Merge Rows Based on Criteria in Excel (4 Easy Ways)

To demonstrate our Methods, we'll use the following dataset consisting of 3 columns named Author, Books, Price, and 9 rows contained in the Cell ...

How to Add Specific Cells in Excel (5 Quick Ways)

Microsoft Excel is an amazing tool to organize data, but sometimes it is difficult to calculate the summation of specific cells to it. Fortunately, ...

Excel Combine Rows with Same ID (3 Quick Methods)

We can easily find the required values to combine rows with the same ID in Excel. Today we are going to learn about doing the process step by step in ...

How to Insert Multiple Rows After Every Other Row in Excel

One of the frequently used tasks that we perform in Excel is to insert multiple rows after every other row. Today I will show in this article how you ...

How to Transpose Columns to Rows in Excel (8 Easy Methods)

Everyone has their own point of view when visualizing and representing data. Some may feel comfortable working with data when they are in the ...

How to Perform Conditional Transpose in Excel (2 Easy Examples)

This tutorial shows how we can add conditional transpose in excel. In some situations, you might need to rearrange your rows and columns. If you do ...

How to Add Multiple Cells in Excel (7 Easy Ways)

If you want to add multiple cells together in Excel, then you can go through this article. There are a few quick ways to add multiple cells in Excel. ...

How to Convert Multiple Rows to Single Row in Excel (5 Methods)

A dataset composed of 2 columns named  Employee ID and Employee Name and 5 rows will be used to show how to convert multiple rows into a single row. ...

How to Combine Multiple Rows into One Cell in Excel (6 Ways)

Excel is a popular and useful tool for analyzing large sets of data. Sometimes we need to show the multiple rows of data in one cell to mean ...

How to Sum Rows in Excel (9 Easy Methods)

  Download the Practice Workbook You can download the practice workbook from here. Sum Rows.xlsx 9 Quick Methods to Sum Rows in ...

How to Convert Multiple Rows to a Single Column in Excel

In the sample dataset, there are three rows: Team Red, Team Blue, and Team Green, with multiple columns. The goal is to convert it into a single ...

How to Insert Row in Excel (7 Quick Ways)

The corporate world is dynamic and changing fast along with the expanding technology. Keeping track is important to analyze the changes and plan ...

How to Insert Blank Row After Every Nth Row in Excel (2 Ways)

Sometimes, you may deal with a dynamic dataset, where you want to put rows or columns after some data. There are no direct built-in features in Excel ...

How to Merge Rows Without Losing Data in Excel (5 Easy Ways)

In Excel, merging multiple rows, columns or cells is a common task. However, the fundamental problem in this task is that it only keeps data from the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo