Advanced Excel

How to Make Trial Balance in Excel (with Easy Steps)

In this article, we discuss how to make a Trial Balance in Excel using a dataset as a Ledger, and provide a free downloadable Trial Balance template. ...

[Solved!] Print Scale to Fit Not Working in Excel

When printing a large sheet, an all too common problem is being unable to fit the dataset on one page. In this article, we will discuss the reasons ...

Isometric Drawing in Excel – 3 Steps

STEP 1 - Drawing Different Shapes Steps: Go to the Insert tab. Click Shapes. Select a shape. Here, Rectangular: top corner rounded. ...

How to Make Hierarchy Chart in Excel (3 Easy Ways)

We'll use the following dataset to show how to make a hierarchy chart. This dataset contains employee information. Method 1 - Using the ...

How to Remove a Table from a Data Model in Excel (2 Methods)

What Is a Data Model? In Excel, a data model is a collection of data tables. These tables are interconnected through one or more data series, ...

How to Convert Large XML to Excel – 2 Methods

Method 1 - Using a File Stored in the System Memory Steps: Go to Data > Get Data > From File. Select From XML. In the ...

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

How to Create Hierarchy in Excel Pivot Table: 5 Methods

Method 1 - Select Dataset Select the whole dataset or the part of the dataset you want to convert into a pivot table. This stage's selection will go ...

How to Create a Date Hierarchy in an Excel Pivot Table – 7 Steps

This is the sample dataset. Step 1 - Add the Dataset to the Data Model Select the entire dataset B4:E12. Go to Power Pivot ...

How to Use SmartArt Hierarchy in Excel (With Easy Steps)

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 Compress Excel File More than 100MB (7 Useful Ways)

Method 1 - Compress an Excel File Larger than 100 MB to ZIP/RAR Right-click on the Excel file. Choose Add to archive. An Archive ...

How to Create a Library Database in Excel (with Easy Steps)

  Watch Video – Create a Library Database in Excel   Step 1 - Enable Form in Quick Access Toolbar Go to the quick ...

Remove Data Model from Pivot Table in Excel (with Easy Steps)

Power Pivot is primarily used for managing data tables and the relationships between them, which makes it easier to analyze data from several tables. ...

How to Show a Relationship Between Two Variables in an Excel Graph

Understanding Correlation Correlation measures how strongly two variables are connected. It’s represented by a coefficient called ...

How to Add Row Hierarchy in Excel (2 Easy Methods)

Row Hierarchies are helpful to read data easily when we have rows of data that are connected to each other. If you want to add row hierarchy in ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo