Macros & Excel VBA

How to Apply Multiple Filters in Excel: 6 Methods

Before going to the steps, consider the following dataset. Here, the Names of 15 Sites are given along with their Category. Furthermore, the Visits ...

How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

Download the Practice Workbook Finding Sum of Last 5 Values.xlsm 5 Simple Methods to Sum Last 5 Values in a Row in Excel We have a ...

How to Compare Two Strings for Similarity in Excel: 6 Methods

Method 1 - Using Highlight Cells Rules Feature Steps: Select all the cells from B5 to C10. Go to the Home tab and click on Conditional ...

How to Sum Every Nth Column in Excel (3 Methods)

We have a sample table of Products and revenue of the items for each month from January to June. The revenues for each month are stored in separate ...

How to Count Visible Rows in Excel (3 Suitable Methods)

Here's the dataset we'll use to count rows. We have a table with three columns; Books, Genre, and Author. There are 10 books listed. To show ...

How to Find Unique Values from Multiple Columns in Excel (5 Easy Ways)

We have a record of student IDs and names. We want to extract the unique values. Method 1 - Extract Unique Values from Multiple Columns ...

How to Separate Text and Numbers in Excel (6 Suitable Ways)

  Let us have a look at this data set. We have the Combined Data of some students. We have two separate columns, C and D, where we want to ...

Excel Formula to Copy Cell Value to Another Cell

In this dataset, there are five people’s First Names, Last Names and Ages. Using Excel formulas, we will copy cell value from this dataset to another ...

How to Copy Formula Down Without Incrementing in Excel

We have the price record of various items of a company. The dataset contains Item Names, their prices, tax, and prices with tax in columns B, C, D, ...

How to Convert Number to Words in Excel (4 Suitable Ways)

Method 1 - Using the LEFT, MID, TEXT, and CHOOSE Functions in Excel to Convert Numbers to Words We will convert the numbers into the Numbers in ...

How to Insert Square Root Symbol in Excel (8 Easy Ways)

Here's an overview of inserting the square root symbol via various methods. Method 1 - Using the Insert Tab to Insert the Square Root Symbol ...

How to Copy a Worksheet in Excel (4 Smart Ways)

The process of copying worksheets is a very common phenomenon among excel users. Especially, when the dataset gets quite large, we tend to copy the ...

How to Auto Populate Date in Excel When Cell Is Updated (2 Methods)

We will put a value in a cell in column B, and the adjacent column C cell will show the date and time of changing the cell. Method 1 - ...

How to Highlight Every Other Row in Excel (3 Easy Methods)

In this article, we will see how to highlight every other row in Excel. Some available techniques are applying conditional formatting, using ...

How to Delete Blank Rows in Excel (6 Ways)

While working with a big spreadsheet you often insert blank rows intentionally to read and understand it properly. Although inserting blank rows are ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo