Excel Basics

How to Multiply a Column in Excel by a Constant (4 Easy Ways)

We often have to multiply a column in Excel by a constant while working. We have to perform various types of multiplication like multiplying cells ...

How to Sum Random Cells in Excel

In this free Excel tutorial, you will learn how to sum random cells in Excel. Summing random cells is a frequent need when working with Excel. It is ...

How to Find the Percentage of Two Numbers in Excel

While working in Microsoft Excel sometimes you might need to find the percentage of two numbers in Excel. This is often determined to calculate the ...

How to Multiply Two Columns and Then Sum in Excel (3 Examples)

Most of us may experience the need to multiply two columns and then sum in Excel, but it will be difficult to compute hundreds or thousands of rows. ...

How Do You Calculate Percentage Increase or Decrease in Excel

Microsoft Excel is a great tool for basic and complicated calculations. In today’s article, how do you calculate the percentage increase or decrease ...

How to Calculate Cumulative Percentage in Excel (6 Methods)

Microsoft Excel provides numerous methods & functions to calculate the cumulative percentage. Instead of determining these cumulative percentages ...

How to Copy Only Visible Cells in Excel (Some Quick Methods)

To copy only visible cells in Excel, do the following: Select your data. Press the ALT and ; (semicolon) keys together. Press Ctrl+C to ...

How to Link Data in Excel from One Sheet to Another

In this tutorial, I am going to show you 5 easy methods on how to link data in Excel from one sheet to another. You can quickly use these methods ...

Excel Merge Cells (All You Need to Know)

Merging cells means merging two or more cells into one bigger cell in Excel. Merge Cells act like one single cell. In this tutorial, you will ...

Selecting Non-Adjacent or Non-Contiguous Cells in Excel (5 Easy Ways)

In Excel, you can select adjacent cells very easily. It is a straightforward one. But selecting non-adjacent cells (you may also refer to them as ...

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

In the sample dataset, we have three columns: ID, First Name, and Last Name for some people. Method 1 – Using the CONCATENATE Function to ...

How to Move Rows in Excel Without Replacing (5 Easy Methods)

This tutorial will demonstrate how to move rows in Excel without replacing them. While dealing with lots of data, we have to move rows without ...

How to Make All Cells the Same Size in Excel (7 Easy Ways)

Are you looking for methods to resize the multiple cells in an Excel spreadsheet? In Microsoft Excel, most of the time we need to resize the shapes ...

How to Shift Cells in Excel (5 Easy Ways)

Sometimes, when working on Microsoft Excel, there may be a need to shift cells in different places according to our needs. The process of moving ...

How to Print Selected Cells in Excel (6 Effective Ways)

As the use of Excel increases on a daily basis, we may need to have a printed hardcopy of our Excel spreadsheet. Varying on your work, you may want ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo