Latest Blog Posts

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

How to Sort a Unique List in Excel – 10 Methods

The sample dataset showcases Employee Name, ID No., Salary & Rank.   Method 1 - Getting a Sorted Unique List 1.1. Using the ...

How to Use VBA StrConv Function (5 Examples)

VBA StrConv refers to String Conversion; is a String Function used in Microsoft Visual Basic macros. This function changes a given string into a ...

How to Use VBA Val Function in Excel (7 Examples)

The VBA Val function is an Excel Text function which converts a text string into a numeric value. You can use this function in a VBA code to get the ...

How to Refresh Pivot Table in Excel: 4 Effective Ways

Method 1 - Refresh a Pivot Table via the Context Menu STEPS: Right-click on the table and select Refresh. We can see that the Nissan ...

How to Sum Entire Column in Excel (2 Easy Ways)

Summing up an entire column in Excel means finding the total of all the numbers in that specific column. This simple yet powerful operation allows ...

How to Sort Array with Excel VBA (Both Ascending and Descending Order)

Method 1 - Sort Array A-Z (In Ascending Order) in Excel VBA Convert the selected range from an Excel worksheet into an array. Dim MyArray As ...

How to Edit a Pivot Table in Excel – 5 Methods

This is a Pivot table containing a sample dataset: ordered items, unit pricing, quantities, and expenses. Method 1 - Changing the Data ...

How to Total a Column in Excel (7 Effective Methods)

To illustrate our methods for totaling a column, we'll use the following sample dataset. Method 1 - Using the SUM Function 1.1  - Sum ...

How to Perform Custom Filter in Excel (5 Ways)

We will use the sample dataset provided below to perform our custom filter. Method 1 - Filter Value Based on Number in Excel Steps: ...

How to Use Sort Function in Excel VBA (8 Suitable Examples)

You may be accustomed to using the Sort & Filter option for sorting your data but there is a way to do this by using the Excel VBA SORT function ...

How to Use VBA FileDateTime Function in Excel (3 Uses)

In Microsoft Excel, we use the VBA FileDateTime function to find out the last modification date of any drive, file, or directory. In this article, we ...

Pivot Table Is Not Picking up Data in Excel (5 Reasons and Solutions)

Let's work with a dataset containing date-wise sales of some mobile phones to make a Pivot Table. Reason 1 - Excel Pivot Table Is Not ...

How to Remove Read Only from Excel (7 Easiest Ways)

An Excel file can be in Read Only mode for two reasons one is if any author has purposely done it for security issues otherwise anyone downloaded the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo