Advanced Excel

Excel VBA: Show Userform in Full Screen (4 Easy Ways)

Often the Userform we generate is quite big and contains a lot of information in a small place. Having all of them in a crammed place can hamper the ...

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

XML or "Extensible Markup Language" is a file format, which is mainly used for storing and transferring data. Microsoft Excel supports this file ...

How to Add Paper Size in Excel (4 Easy Ways)

Adding paper size in Excel is needed when you want to print your Excel sheet. In this article, I will explain how to add paper size in Excel. I will ...

How to Reduce Excel File Size with Pictures (2 Easy Ways)

You must compress the photos if you work with photographs in Excel. Otherwise, the Excel file size will rise. Here, you need to pay attention to the ...

How to Show Full Screen with No Title Bar in Excel (3 Easy Ways)

While working with a large dataset, you need to show the Excel in full screen with no title bar. In Microsoft Excel, you can do this quite easily and ...

How to Do Data Mapping in Excel (5 Handy Ways)

Data Mapping is one of the first and essential steps for data management. In Microsoft Excel, you can easily do data mapping which reduces a lot of ...

How to Reduce Excel File Size Without Opening (with Easy Steps)

Sometimes, the size of an Excel file can be significant if it contains a large amount of data. If your Excel file contains a large amount of data, it ...

How to Alternate Row Colors in Excel Without Table (5 Methods)

For the purpose of attracting your data, you can alternate Row colors in Excel without even making a Table. In this article, I will explain how to ...

How to Make a Ledger in Excel (with Easy Steps)

Need to learn how to make a ledger in Excel? If you are looking for such unique tricks, you’ve come to the right place. Here, we will take you ...

How to Edit XML File in Excel (With Easy Steps)

This tutorial will demonstrate how to edit an XML file in excel. XML is a markup language. It is mainly used for giving definitions of markup ...

How to Make a Bank Ledger in Excel (with Easy Steps)

A Bank Ledger is a very essential and important document to keep track of your financial situation. In Microsoft Excel, you can easily create a Bank ...

How to Create a Bullet Journal in Excel (with Detailed Steps)

This article illustrates how to create a bullet journal in excel. A bullet journal is a system of organizing to-do lists, daily tasks, monthly goals, ...

How to Compress Excel File for Email (13 Quick Methods)

Excel worksheet files can get quite large at times. When dealing with such files, you must be patient because they take a long time to update when ...

How to Enable Track Changes in Excel ( with Customizations)

In Excel, users often use large data sets for analysis. In those data sets, they have to make changes from time to time. If they can keep any track ...

How to Create a Forex Trading Journal in Excel (2 Free Templates)

The article will show you how to create a Forex Trading Journal in Excel. Forex Trading (Also known as Foreign Exchange Trading) is the marketplace ...

ExcelDemy
Logo