Advanced Excel

How to Draw Engineering Drawing in Excel (2 Suitable Examples)

If you want to draw engineering drawing in Excel, you have come to the right place. Here, we will demonstrate to you 2 examples that will help you to ...

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

Using AutoCAD software, we can easily draw a Floor Plan. we can also do that using Microsoft Excel. The Floor Plan drawing depicts the relationships ...

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

When you share a workbook that gets checked by various users at that time you need to check or review the changes. You can check and also review by ...

Create General Ledger in Excel from General Journal Data

For every businessman, it is common to use a journal for their daily transaction. These entities can be entered into Excel or any other preferable ...

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

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo