How to Use LOG Function in Excel VBA (5 Suitable Examples)

The VBA LOG function is a built-in Math or Trig function in Excel. The LOG function is available in both Excel Worksheet and VBA however they differ ...

Shortcuts for Filtering Data in Excel (3 Methods with Examples)

Method 1 - Use the Filter Shortcut Option Under the Data Tab to Filter Data Suppose you have the following dataset. Steps: Select any ...

How to Remove Dashes from SSN in Excel?

We’ll use the following dataset, which contains some random SSNs. Method 1 - Apply the Find and Replace Tool to Erase Dashes from SSNs in ...

How to Use VBA Abs Function in Excel (9 Examples)

The Abs function is a math function in VBA (Visual Basic for Applications) that returns an absolute value for a number. If you insert a negative ...

How to Use Concatenate in Excel VBA (4 Methods)

  Download the Practice Workbook Download this practice workbook to exercise while you are reading this article. VBA Concatenate ...

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

VBA Randomize function is an inbuilt Math or Trigonometry function of Excel which allows you to change the seed value used by the random number ...

How to Group Columns in an Excel Pivot Table – 2 Methods

The dataset contains date-wise sales data from different stores. Create a Pivot Table and group columns into Column Labels. Method 1 - ...

[Fix] Excel Fill Series Not Working (8 Causes with Solutions)

To demonstrate the solutions to the Excel Fill Series problem, we are using the following data table. Fix 1 - Check the Fill Handle Option ...

Types of Excel Tables: 3 Different Types

Method 1 - General Excel Table: Creation, Features, and Benefits A. How to Create and Turn Off an Excel Table Step 1: Click on any cell in the ...

How to Use Text Filter in Excel (5 Methods)

Dataset Overview Let’s consider a scenario where we have an Excel worksheet containing information about products sold by a company to customers. ...

How to Sort Numbers in Excel (8 Quick Ways)

We'll use a sample dataset that contains the salary information of a particular employee with the Employee Name, Region, and Salary columns. ...

How to Remove Prefix in Excel (6 Methods)

The following sample dataset shows some student IDs that start with ID and the Name of the corresponding IDs in Column C and Column B respectively. ...

How to Create a Hyperlink in Excel (5 Easy Ways)

Method 1 - Hyperlink Using an URL Microsoft Excel automatically creates a hyperlink when you insert a URL in a cell. If your given URL is valid, it ...

Add Text and Formula in the Same Cell in Excel (4 Examples)

Example 1 - Add Text and Formula in the Same Cell in Excel with the Ampersand Operator We have an Income-Expense List has four columns. We have ...

How to Remove Negative Sign in Excel (7 Methods)

Method 1 - Remove the Negative Sign in Excel Using the ABS Function We have a list of numbers in cells B4:B10 with both positive and negative. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo