How to Keep 0 Before a Phone Number in Excel (6 Methods)

Method 1- Apply Text Format to Retain 0 Before a Phone Number in Excel Highlight all the cells where you want to keep the numbers with a leading ...

How to Get Unique Values from Range in Excel (8 Methods)

Let’s assume a scenario where we have an Excel file that contains information about the products that a country exports to different countries in ...

VBA EXP Function in Excel (5 Examples)

VBA Exp function is a built-in function in Excel, categorized under the Math and Trig function. In this article, we will show you what Exp function ...

VBA Format Function in Excel: 8 Uses with Methods

Method 1 - VBA to Format Numbers with Predefined Formats Below is the VBA code which covers all the predefined formats to Format numbers in Excel. ...

How to Use VBA IsNumeric Function (9 Examples)

If you are looking for some of the easiest ways to use the VBA IsNumeric function, then you are in the right place. We generally use this function in ...

Advanced Excel Lookup Functions (9 Examples)

In this tutorial, I will discuss several methods regarding MS Excel's advanced Lookup functions. I will use the single Lookup Function to return ...

How to Refresh All Pivot Tables in Excel: 3 Ways

Method 1 - Applying the Refresh All Command to Refresh All Pivot Tables in Excel Step 1: Look at the pivot tables; the Grand Total of the ...

How to Use VBA Right Function in Excel (6 Examples)

The VBA Right function in Excel returns a substring from within a string based on a specified location from the right to the left of that string. We ...

How to Group by Week in an Excel Pivot Table? – 3 Methods

The following dataset showcases sales amounts in January. Method 1 - Setting 7 Days As a Week to Group a Pivot Table by Week This is the ...

How to Substitute Multiple Characters in Excel: 7 Methods

  Method 1 – Using the SUBSTITUTE Function to Substitute Multiple Characters Below is a dataset of Microsoft Word version names. We want to ...

How to Link Sheets to a Master Sheet in Excel (5 Ways)

Let’s say we have sales data for three different cities, New York, Boston, and Los Angeles. These three are identical in form, so we'll show only one ...

How to replace the Text of a Cell Based on a Condition in Excel – 5 Methods

Method 1 - Replacing Text using the Find and Replace Tool in Excel This is the sample dataset. Step 1: Go to the Home tab. Click ...

VBA If – Then – Else Statement in Excel (4 Examples)

Conditional statements are used to perform a set of actions depending on the specified condition in programming languages. In this article, we will ...

Hotel Bill Format in Excel (Create with Easy Steps)

Hotel Bill format is an invoice format that you can use to create hotel bills for clients in order to document information about hotel services as ...

Cannot Group Dates in a Pivot Table – 4 Solutions

This is an overview: Solution 1 - Replacing Missing or Distorted Date Values to Group Dates in a Pivot Table Step 1: There are error ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo