How to Sort Data in Excel Using a Shortcut (7 Methods)

Method 1 - Excel Shortcut for Single Column Sorting In this method, we’ll demonstrate how to sort a single column using Excel shortcuts. Let’s ...

How to Fix If a Pivot Table Field Name Already Exists (2 Methods)

The dataset below contains some salespersons’ sales, units, and corresponding regions. Method 1 - Using Different Custom Names Steps: ...

How to Get a Count in Excel Pivot Table Calculated Field

The Calculated Field is a powerful feature used to analyze the values of some other fields in an Excel Pivot Table using formulas. By default, the ...

How to Sort and Filter Data in Excel – A Complete Guideline

This is the sample dataset: After sorting data based on Profit, in descending order: Filter the dataset based on “South”: ...

[Fix] The Pivot Table Name Is Not Valid (7 Causes with Solutions)

We'll use the following dataset to showcase possible errors with pivot table names and how to solve them. Reason 1 - Missing Data in Any ...

How to Use VBA TimeSerial Function in Excel (3 Examples)

The TIMESERIAL in Excel is a built-in Date/Time function that can be used in VBA. The TIMESERIAL function returns a time or Variant (Date) given an ...

Filter Multiple Criteria in Excel with VBA: 2 Easy Methods 

Method 1 - Filter Multiple Criteria of AND Type in Excel with VBA Develop a Macro to filter multiple criteria of AND type for any data set. ...

How to Sort in Ascending Order in Excel (6 Methods)

Dataset Overview In the following example we have some random numbers in a column. After sorting in ascending order, it will look like the following ...

How to Use VBA MkDir Function in Excel (4 Examples)

We’ll first discuss how to write code in the Visual Basic Editor. Follow the simple steps to create the setup for writing your code. Steps: ...

How to Remove a Header in Excel – 4 Methods

The header in the sample dataset is Product Order Records. Method 1 - Using the Page Setup to Remove a Header in Excel Go to Page ...

How to Lookup a Table and Return Values in Excel (3 Simple Ways)

In Excel, lookup tables are named tables that are utilized to find any data when we have a huge volume of data and don't know where to start finding ...

How to Use VBA WeekdayName Function in Excel (2 Examples)

The WeekdayName function in Microsoft Excel returns a string that represents the day of the week when given a number between 1 and 7. The WeekdayName ...

How to Use Fix Function in Excel VBA (4 Examples)

The Fix function is categorized under the Math function list in Excel VBA. It is an inbuilt VBA Function. This function is used to remove the ...

How to Remove Dotted Lines in Excel (5 Quick Ways)

If you are looking for some of the easiest ways to remove dotted lines in Excel, then you are in the right place. Sometimes you may have some ...

How to Use VBA Replace Function in Excel: 11 Methods

Method 1 - Use VBA Replace to Find a Word and Replace We have the following dataset of six students and their status of present or absent in the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo