Advanced Excel Archives - Page 38 of 64

How to Draw a Floor Plan in Excel (2 Easy Methods)

Jun 8, 2024

In this article, we'll demonstrate two quick ways to draw a floor plan in Excel. Here’s an overview of the dataset we'll be using. Floor Plan - ...

How to Draw a Floor Plan in Excel (2 Easy Methods)

[Solved]: Track Changes Greyed Out in Excel (3 Quick Fixes)

Jul 6, 2024

Method 1 - Unprotect Workbook in Excel The track changes option becomes greyed due to various reasons. One of the reasons is that your workbook is ...

[Solved]: Track Changes Greyed Out in Excel (3 Quick Fixes)

How to Create a General Ledger from a General Data Journal in Excel

Aug 4, 2024

What Is a General Journal? The general journal is an accounting record of a company’s financial transactions. It is the master of all company ...

How to Create a General Ledger from a General Data Journal in Excel

How to Convert XML to XLSX Without Opening File

Nov 11, 2025

This tutorial will demonstrate how to convert XML to XLSX without opening the file. XML is a markup language. It is mainly used for giving ...

How to Convert XML to XLSX Without Opening File

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

Jul 6, 2024

In this article, we discuss how to display a Userform in full screen in Excel using VBA in four different ways. We'll use the dataset below to ...

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

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

Nov 11, 2025

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 Open XML File in Excel for Income Tax (2 Easy Ways)

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

Jun 25, 2024

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 Add Paper Size in Excel (4 Easy Ways)

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

May 27, 2024

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 Reduce Excel File Size with Pictures (2 Easy Ways)

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

Nov 11, 2025

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 Show Full Screen with No Title Bar in Excel (3 Easy Ways)

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

Apr 20, 2024

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 Do Data Mapping in Excel (5 Handy Ways)

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

Nov 11, 2025

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 Reduce Excel File Size Without Opening (with Easy Steps)

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

Jul 6, 2024

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

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

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

Jun 24, 2024

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 Make a Ledger in Excel (with Easy Steps)

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

Aug 6, 2024

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

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

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

May 18, 2024

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