Advanced Excel

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)

We'll use the following dataset which contains a Sales Overview. Method 1 - Using the Page Layout Tab to Add a Paper Size in Excel Steps: ...

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

To reduce file size and improve performance, it's always recommended to compress images in Excel files. Here are 2 methods to do so. Method 1 ...

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)

  Method 1 - Inserting VLOOKUP Function to Do Data Mapping in Excel Let’s assume a dataset with the Sales Quantity for three different models ...

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 a Table (5 Methods)

The sample dataset below has 4 columns: Product, Sales, Profit, and Status. Method 1 - Using the Fill Color Option to Alternate Row ...

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

Step 1 - Create a Layout of a Ledger in Excel In the range of cells B4:B5, B7:B8, and E7:E8, write down the following entities and format the ...

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

XML is a markup language mainly used for transferring data or records, or encoding particular documentation. This tutorial will demonstrate how to ...

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

A Bank Ledger is the bank account balance computed by a bank for each account every business day. It includes all kinds of deposits and withdrawals. ...

How to Create a Bullet Journal in Excel – Detailed Steps

What Is a Bullet Journal? The idea of the bullet journal, abbreviated as BuJo, was invented by Ryder Carrol in 2013. It was described as ...

How to Compress Excel File for Email: 13 Quick Methods

Method 1 - Compress Excel File by Removing Unnecessary Worksheets Steps: Right-click on the Excel sheet that we want to remove. Click on ...

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

Here's a typical Forex Trading Journal. You can see several parameters regarding Foreign Exchange data. We need the values of Size-Volume of the lot, ...

How to Fit an Excel Sheet in One PDF Page – 8 Simple Methods

The dataset is a Marksheet of 20 students. Method 1 - Using the Page Setup Feature to Fit an Excel Sheet on One PDF Page Step 1: Checking ...

How to Alternate Row Color Based on Cell Value in Excel – 10 Methods

The dataset contains Products, Customers and Quantity sold. Cell values in Column B are the base values. Method 1 - Alternate Row Color ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo