Excel Basics

How to Auto Fit Row Height in Excel (5 Useful Ways)

Consider a dataset where some rows have excessively large row heights, while others have very small ones, such as the image below. It looks ...

How to Remove Last Digit in Excel (6 Quick Methods)

Let's use the following dataset of some random data to explain how to remove last digits. How to Remove Last Digit in Excel: 6 Quick ...

How to Convert Text to Hyperlink in Excel (5 Methods)

In this tutorial, we will demonstrate to you how to convert text to hyperlink in Excel. Hyperlinks in excel are used to link between websites. Also ...

How to Multiply Rows in Excel (4 Easiest Ways)

Multiplying is certainly a frequent and easy task in Excel. We often need to multiply rows in Excel to get a job done.  In this article, I am going ...

How to Auto Sort Table in Excel (5 Methods)

While working with a large data table in Microsoft Excel, sometimes we need to sort tables and Excel can easily do it. Excel is very useful for ...

How to Merge Cells Using Excel Formula (8 Formulas)

Merge is an excellent and powerful tool in Excel that lets you merge or combine multiple across different columns or cells under the same column. The ...

How to Show Percentage in Excel Pie Chart (3 Ways)

How to Show Percentages in an Excel Pie Chart: 3 Methods Below, we have the population percentages by major ethnic groups in Southern California. We ...

Cannot Insert Column in Excel (All Possible Causes with Solutions)

In Excel, you may need to insert a column for adding new data. But sometimes you cannot insert a column in Excel in spite of your needs. In this ...

How to Remove Both Duplicates in Excel (5 Easy Ways)

Removing both duplicates in Excel is a common thing when we merge or combine multiple worksheet data. As a result, identical entries exist throughout ...

How to Multiply Two Columns in Excel (5 Easiest Methods)

Microsoft Excel has several functions that may be used to do simple Arithmetic Operations as well as more complex calculations. Multiplication is one ...

How to Use Multiply Sign in Excel (Including 3 Alternatives)

There is no direct multiply formula in Excel but no worries, there are other multiple ways to multiply in Excel. We can use Asterisk (*) which is ...

How to Undo Sort in Excel (3 Easy Methods)

Sorting data in Excel is quite a common task to do. There are multiple ways available both to sort and undo sort data in Excel. After applying the ...

How to Remove Table Functionality in Excel (3 Methods)

We often insert Tables for data in Excel because the Table command has some advantages that help to understand and analyze data in a better way. Then ...

How to Print and Fit to One Page in Excel (10 Easy Methods)

Printing data from Excel spreadsheets is a common requirement in various professional and personal scenarios. We have to ensure that the printed ...

How to Calculate Total Row and Column in Excel (4 Methods)

While working with a large worksheet in Microsoft Excel, we need to sum up cells in Excel. To sum up, cell values mean total columns and rows values, ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo