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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo