Latest Blog Posts

How to Solve Algebraic Equations with Multiple Variables (3 Easy Ways)

We have the following three equations. 2x + 5y + 2z = -38 3x - 2y + 4z = 17 -6x + y - 7z = -12 We’ll determine the value of the three variables, ...

How to Reverse Order of Columns Vertically in Excel (3 Ways)

You may sometimes need to flip or reverse the order of columns vertically or horizontally while working with datasets in Excel. This can be necessary ...

How to Use Arrays Instead of Ranges in Excel VBA

An object that is a collection of random elements is called an array. When an item knows how to move from one end to the other without having to list ...

Using Excel VBA to Return the Row Number of Value – 5 Methods

Method 1 - Using the Input Box Enable the Developer tab on the ribbon. Click: How to Show the Developer Tab on the Ribbon. Steps Go to the ...

How to Skip Rows Based on a Value Using an Excel Formula (7 Examples)

Example 1 - Using the FILTER Function In the first example, we are going to use the FILTER function to skip rows based on value using the Excel ...

Using Excel VBA to Save a Workbook as a New File in the Same Folder – 3 Examples

The sample Excel workbook contains 3 worksheets: ‘VBA-1’, ‘VBA-2’ and ‘VBA-3’. Each worksheet contains the same dataset (B4:D8). To save a new ...

How to Clear Contents Without Deleting Formulas Using VBA in Excel: 4 Methods

Method 1 - Clear Contents from Range Without Deleting Formulas Using VBA in Excel STEPS: Go to the Developer tab and select Visual Basic. It ...

How to Remove Grand Total from Pivot Table (4 Quick Ways)

We’ll consider the following dataset in B4:D14 cells which shows the Item names, their Category, and the Sales in USD. Method 1 - Using ...

How to Collapse the Table to Show the Grand Totals Only – 5 Methods

To collapse the table and display the Totals only:   Insert an Excel Pivot Table (Insert > Pivot Tables) to customize data ...

Excel VBA to Add Sheet to Another Workbook (3 Handy Examples)

Do you want to add a sheet to another workbook in Excel? Yes, then you are in the right place! You can add a sheet in Excel in different ways. ...

How to Create Scenarios in Excel (With Easy Steps)

In this tutorial, I am going to show you the step-by-step procedures to create scenarios in Excel. The Scenario Manager can create simple summaries ...

How to Show Grand Total in Pivot Table (3 Easy Methods)

The following dataset has the Product, Sales, and Profit columns. Using this sample dataset, we will insert a Pivot Table. Method 1 - ...

How to Select and Skip Columns in Excel – 4 Methods

The sample dataset showcases Name in column B, ID in column C, EEE, ME, and CE in columns D, E, and F. Method 1 - Selecting a ...

How to Create Hierarchy in Excel (3 Easy Ways)

In Excel, the term “hierarchy” has two distinct meanings. The first definition refers to a chart that aids in visualizing a hierarchical structure, ...

How to Calculate Auto Loan Payment in Excel (with Easy Steps)

If you're looking to calculate your auto loan payment in Excel, there are a few things you'll need to know. First, you'll need to know the loan ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo