Advanced Excel

How to Compress Excel File More than 100MB (7 Useful Ways)

If you are looking for how to compress an Excel file of more than 100 MB, then you are in the right place. In our practical life, we often need to ...

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

Most people use Microsoft Excel for accounting, tracking, or forecasting purposes. However, Excel can also be used as an excellent database software ...

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 Relationship Between Two Variables in Excel Graph

In this article, we will learn to show the relationship between two variables in an Excel graph. In our life, especially in the field of business and ...

How to Make General Ledger in Excel (With Easy Steps)

In this article, we will learn how to make General Ledger in Excel very easily and analyze it. A ledger is used to keep track of things like ...

[Solved]: Word Mail Merge Not Working with Excel

By importing credentials from Excel files, Word Mail Merge is an effective way to mass produce custom letters, mailing labels, and emails in Word. ...

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

While working with Excel, we often encounter slow and sluggish Excel experiences. In most cases, the main culprit behind this issue is the large ...

How to Remove XML Mapping in Excel (with Easy Steps)

If you have decided that you no longer want to use XML Mapping in Excel, there are a few ways that you can remove it. You can either remove the XML ...

How to Exit Full Screen in Excel (3 Easy Methods)

For better readability of data and visibility in Excel, we often enter full-screen mode. But after the job is done, we need to exit the full-screen ...

How to Convert CSV to XML in Excel (With Easy Steps)

In this tutorial, I am going to show you step-by-step procedures to convert CSV to XML in Excel. CSV files store data in a comma-separated values ...

How to Make Journal Entries in Excel (with Easy Steps)

Every business industry is built on some investments and planning. In order to observe its growth of it, we like to record every investment in the ...

How to Zip an Excel File (3 Easy Ways)

Excel files can often be very large. In that case, storing and sharing them becomes a problem for Excel users. They can quickly and easily share them ...

How to Draw to Scale in Excel (2 Easy Ways)

Looking for ways to know how to draw to scale in Excel? We can draw in any scale we want in Excel, adjusting the row and column size. Here, you will ...

How to Convert Excel to XML File (With Easy Steps)

Similar to HTML, XML is also a markup language. But unlike HTML, it is designed to store and transport data. Excel users often need to store their ...

How to Create a Schema in Excel (with Detailed Steps)

The Schema-based XML files can help us map the entire worksheet and create a new XML file in a short period of time. If you are curious to know how ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo