Latest Blog Posts

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 ...

VBA Date to String Conversion in Excel (6 Methods)

Method 1 - Excel FORMAT Function to Convert a Date Range to Strings with VBA Case 1.1 - Change the Whole Date Format in Range Suppose we are using ...

How to Fix If Break Links Aren’t Working in Excel (7 Solutions)

  To see if the Break Links aren't working, go to the Data tab. From the Queries & Connections group, click on Edit Links. You will ...

How to Use the Substitute Function in Excel VBA: 3 Methods

Method 1 - Removing the First Character(s) from a String with the Substitute Function in Excel VBA Below is a dataset with the names and IDs of ...

How to Apply the VBA Now and Format Functions in Excel (4 Examples)

VBA Now Function Overview Function Objective The Now function returns the current date and time based on the user’s computer’s default settings. ...

Shortcut for Merge and Center in Excel (3 Examples)

To illustrate, we have a data table with two columns and the title of the table in a single cell. Example 1 - Shortcut for Merge & ...

Create GST Invoice Format in Excel: 4 Methods

Method 01 - Making an Outline of GST Invoice Format 1. We need to have the basic inputs such as the Product Details in the product sheet and the ...

How to Use VBA DATESERIAL Function in Excel (5 Examples)

DATESERIAL function is an Excel time and date function that can be used in VBA to get a date from a specified year, month, and day value. From this ...

How to Use COUNTIF for Unique Text (8 Easiest Ways)

We'll use a sample dataset of sales information. The dataset contains two columns: Sales Person and Sales. Let's extract the unique values. ...

How to Apply Custom Format Cells in Excel (17 Examples)

To apply a custom format in Excel: Select the cell or range you want to format. Press Ctrl + 1 to open the Format Cells dialog box. In the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo