Excel Formulas

How to Create a Formula in Excel for Multiple Cells (9 Easy Ways)

Applying a formula for multiple cells is a too common task in Excel. That’s why we should have proper knowledge of this operation. So here I’ll show ...

How to Lock a Cell in Excel Formula (2 Easy Ways)

In this tutorial, I am going to show you 2 easy methods of how to lock a cell in an Excel formula. You can quickly use these methods to add absolute ...

How to Calculate Difference Between Two Dates and Times in Excel

If you want to find out the difference between two dates or times in Excel, you will find this article useful. Here you can find how to calculate the ...

How to Auto Update Current Time in Excel (3 Easy Ways)

Today I’ll show you how you can auto-update the current time in a cell in Excel. While working in Excel, we often have to enter the current date and ...

How to Create a Custom Formula in Excel (2 Practical Examples)

While working in Excel or making custom worksheets for business analysis, we may need to create a custom formula of our own. Despite all the ...

How to Use Sheet Name in Dynamic Formula in Excel

Sometimes depending on the scenario, you may need to use worksheet names in the formula, providing the sheet name manually is a tedious task. To ...

Transpose Data in Excel (Applying Functions, Commands, and VBA)

In this Excel tutorial, you will learn to transpose in Excel by applying 10 useful approaches addressing numerous tools such as Paste Special, Find ...

How to Transpose Rows to Columns in Excel (7 Quick Methods)

Below is a dataset that shows the year and Results of Students. Method 1 – Using Paste Special Command a) Pasting a Special Command from ...

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

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

In Microsoft Excel, the Sum is one of the most common operations we use. There are different techniques to sum up values in multiple rows in excel. ...

How to Convert Multiple Rows to a Single Column in Excel

We know what rows and columns are in Excel. Basically, data is spread into multiple rows or columns. Now, in this tutorial, we are going to show how ...

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

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

If you are looking for ways to compare two Excel sheets for duplicates, you have come to the right place. Here, we will walk you through 5 easy and ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo