Latest Blog Posts

How to Lookup Text in Excel (7 Methods)

Below is a dataset where employee names are provided with their Employee ID No and Email ID. Method 1 – Applying the LOOKUP Function to ...

How to Use Named Range in Excel VBA (2 Ways)

Many a time while working with VBA in Excel, we have to use a Named Range. In this article, I’ll show you how you can create and refer to a Named ...

How to Keep a Cell Fixed in Excel Formula (4 Easy Ways)

Method 1 - Use the F4 Key in Excel Formula to Keep a Cell Fixed We have a dataset of fruits with their weight, unit price, and total price. Sellers ...

Excel Timesheet Formula with Lunch Break (3 Examples)

In this article, we will apply timesheet formulas in different time formats that take different kinds of lunch breaks into account. Example 1 ...

How to Delete Unused Rows in Excel (8 Methods)

Dataset Overview We have a dataset where users input Product Sale data. Somehow users leave unused or blank rows while entering data in the dataset ...

How to Create Excel Drop Down List with Color (2 Ways)

We'll use a sample dataset of dress stores that represents the order, size, and color information of a particular dress. The dataset contains 4 ...

How to Find from Right in Excel (6 Methods)

Let’s discuss how to use the Excel RIGHT function to find characters from the right in Excel.  Below is a summary of the formulae used in this ...

How to Format a Cell in Excel with VBA (12 Ways)

Method 1 - Format Cell Horizontally or Vertically with VBA Excel’s CellFormat. The AddIndent property sets a Variable type value that indicates ...

Dealing with Time Format in Excel (5 Suitable Ways)

In Excel time and date is stored as a regular number which is known as date serial number. But we can use the formatting features of Excel to display ...

How to Adjust Column Width in Excel (7 Ways)

The column width in Excel does not automatically change if the data you enter in the cell is too large to fit in the column. Either it will overlap ...

How to Use Phone Number Format in Excel (8 Examples)

If you are looking for some of the easiest ways for Excel phone number format, then you are in the right place. By following this article, you will ...

Excel Drop Down List Not Working (8 Issues and Solutions)

We'll provide you with 8 solutions in case your drop down list function is not working. Let’s consider the following dataset where some items are ...

How to Use COUNTIF with SUBTOTAL in Excel (2 Methods)

In this article, we’ll demonstrate how to count filtered data using the COUNTIF function together with the SUBTOTAL function. Download the ...

Applications of Excel Fill Series: 12 Easy Methods

Method 1 - Fill a Linear Series in Excel in a Column Select cell D5. Drag the Fill Handle tool to cell D10. From the dropdown of the ...

VBA COUNTIF Function in Excel: 6 Examples

Method 1 - WorksheetFunction with COUNTIF in Excel VBA Steps: Press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo