Advanced Excel

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

How to Create a General Ledger in Excel – 4 Steps

Step 1 - Input Fields and Choose the Range Select data to input into the General Ledger. A typical ledger has 5 fields: Serial no., Date, ...

[Solved]: Word Mail Merge Not Working with Excel

Microsoft Word uses the default OLE DB Database Files conversion when it fetches labels from Excel files. The typical reasons behind Word Mail Merge ...

How to Reduce Excel File Size Without Deleting Data (9 Tricks)

In this article, we present 9 smart tips to reduce Excel file size without deleting data. Why Reducing File Size Is Important in Excel? In the case ...

How to Remove XML Mapping in Excel: 3 Methods

Method 1 - Activate Developer Tab To remove an XML mapping, activate the Developer tab first. You can only open the XML Map dialog box from the ...

How to Open XML File in Excel (2 Easy Ways)

The Extensible Mark-up Language is known as XML. This dialect is comparable to HTML.  A mark-up language really employs tags to define text and is a ...

How to Exit Full Screen in Excel – 3 Methods

Method 1 - Using the Context Menu to Exit Full Screen Steps: Right-click anywhere in the workbook. Select Close Full Screen. ...

How to Convert CSV to XML in Excel: 4 Methods

Method 1 - Opening CSV File in Excel Open the CSV file in Excel. Note down the heading of each column. This will be required to create the ...

How to Add Markers to Sparklines in Excel (with Easy Steps)

The Sparklines feature in Excel is helpful for those who evaluate and analyze data. One can add markers to sparklines in Excel for better ...

How to Make Journal Entries in Excel – 3 Steps

STEP 1 - Creating an Initial Balance Sheet Steps: The sample dataset showcases the starting condition of a production business. It includes: ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo