Latest Blog Posts

How to Calculate Rank Percentile in Excel: 7 Suitable Methods

Method 1 - Using a Formula to Calculate Percentile Rank in Excel Step-01: Before adding the serial numbers of these marks we have to sort the marks ...

How to Sort Drop Down Lists in Excel – 5 Easy Methods

  Method 1 - Applying the SORT Function to Arrange and Create a Drop-Down List The sample dataset (B4:C13) contains fruit names in random ...

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)

Method 1 - Activate Automatic Hyperlinks Option to Convert Text to Hyperlink in Excel In the following dataset, we can see the URLs of 5 companies. ...

How to Multiply Rows in Excel (4 Easy Ways)

Method 1 - Basic Ways to Multiply Rows in Excel Multiply a Row by a Cell Select the appropriate cell (C6 in this example) and type the ...

How to Auto Sort Table in Excel (5 Methods)

Excel features a variety of useful tools for automatically sorting tables. In this article, we'll discuss how to use the SORT, SORTBY, VLOOKUP and ...

How to Merge Cells Using Excel Formula (8 Formulas)

Formula 1 - Merging Multiple Cells Using the Merge & Center Feature in Excel The dataset has a text “Merge and Center in Excel” in cell B2. We ...

Rank IF Formula in Excel (5 Examples)

Excel Rank Function To rank multiple items there is a built-in Excel RANK Function, which ranks multiple values based on a column that you specify, ...

Random Number Generator in Excel with No Repeats (9 Methods)

Method 1 - Using the RANDARRAY Function The RANDARRAY function, introduced in Excel 365, generates arrays of random numbers. For example, if you ...

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 have created a pie chart using this data and added ...

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

We'll use the following dataset to try to insert a new column to add some additional data. We will show you why you can't insert a column in this ...

How to Print Data with Excel VBA (A Detailed Guideline)

Download Practice Workbook VBA Print.xlsm Step 1 - Opening the VBA Editor to Print in Excel Press ALT+F11 to open the Visual Basic ...

How to Remove Both Duplicates in Excel – 5 Methods

After merging data from two worksheets, the dataset contains identical entries or both duplicates: Method 1- Using a Helper Column to ...

How to Remove Conditional Formatting in Excel (3 Examples)

In Excel, Conditional Formatting is a handy feature that allows you to effortlessly format and shade cells based on certain conditional criteria. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo