How to Open a Workbook and Run a Macro Using VBA (4 Methods)

Method 1 - Using Workbooks.Open Method Open the Visual Basic Editor by going to the Developer tab and clicking on Visual Basic or by pressing ...

How to Create Calculated Field in Pivot Table Data Model: 4 Methods

Method 1 - Creating Implicit Calculated Field in Pivot Table Data Model Step-01: Creating Pivot Table Go to the Insert tab >> PivotTable ...

How to Calculate College GPA in Excel (3 Handy Approaches)

In this tutorial, we will demonstrate 3 approaches to calculate college GPA in Excel. What Is GPA? GPA stands for Grade Point Average. It is ...

[Fixed!] Carriage Return Not Working in Excel (2 Solutions)

In this article, we will learn to fix when the carriage return is not working in Excel. Carriage return means introducing a line break in an excel ...

Excel VBA to Add Sheet with Variable Name (5 Ideal Examples) 

While working with Microsoft Excel, we may have to work with lots of data. We may build many spreadsheets when dealing with a lot of information in ...

How to Get Current Stock Price of India in Excel: 3 Ways

  Download Practice Workbook Download this practice workbook to exercise while you are reading this article. Current Stock Price ...

How to Create an XML Mapping in Excel – 3 Easy Steps

Step 1 - Choosing an XML File The XML file code attached in the below image will be used. The structure is needed to create an XML ...

[Fixed] Repeat Last Action Not Working in Excel (6 Solutions)

The repeat last action feature in Excel allows users to quickly repeat the last action that they performed. This can be extremely useful when ...

4 Easy Ways to Change Indent in Excel

Excel has three default horizontal alignments for a cell: left, right, and center. But you can change the position of a value horizontally based on ...

How to Undo and Redo in Excel (2 Suitable Ways)

Sometimes we mistakenly perform an action in Excel and we need to undo it. Again we need to redo an action sometimes. These can be easily done in ...

How to Create an Array in Excel VBA (4 Ideal Methods)

The array is a very effective command in Excel VBA while working with multiple values. It helps to lessen time consumption and clarify information ...

How to Create an Automated Attendance Sheet in Excel – 8 Easy Steps

This is the sample dataset.   Step 1 - Creating a Support Sheet for an Automated Attendance Sheet in Excel In the Month Name ...

How to Open Another Workbook and Copy Data with Excel VBA – 4 Examples

You have two Excel files, Copying Data with VBA.xlsm is the Source File containing the data you want to copy, and Sales Report.xlsx is the ...

How to Create a Scenario with Changing Cells in Excel

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default ...

How to Make Sankey Diagram in Excel (With Detailed Steps)

What Is Sankey Diagram? Sankey diagram is a flow diagram which is handy and effective when working with flow analysis. The width of the arrows is ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo