Advanced Excel

How to Fit Excel Sheet on One Page PDF (8 Simple Ways)

Whenever working with Excel, making PDFs from the Excel sheet is needed sometimes. The main objective of this article is to explain how to fit Excel ...

How to Color Alternate Row Based on Cell Value in Excel

Need to learn how to color alternate row based on cell value in Excel? When we work on a large datasheet, we need to alternate the row color to ...

How to Reduce Excel File Size with Macro (11 Easy Ways)

While using the VBA code in Excel, we can find out that the Excel file size increases to some extent. For a large Excel file, it is difficult to work ...

How to Maintain Ledger Book in Excel (with Easy Steps)

Ledger is an essential document for any organization. It shows us the details of debit and credit and the current balance of that company after every ...

How to Map Data Using VLOOKUP in Excel (4 Quick Ways)

Mapping Data is an essential part of Excel. Therefore, knowing a couple of handy methods to map data can save a lot of time and improve the workflow. ...

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

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Excel makes ...

How to Make Legend Markers Bigger in Excel (3 Easy Ways)

In this article, we will learn to make legend markers bigger in Excel. Legend markers are used to denote the data with specific colors. Sometimes, ...

How to Make a Trading Journal in Excel (with Easy Steps)

Let’s say we have a dataset that contains information about several Trades. We will make a trading journal in Excel using Mathematical formulas, the ...

How to Print Full Page of Excel Sheet in A4 Size (5 Simple Ways)

Microsoft Excel is an amazing software which importance can’t be explained in words. It is very essential part of almost every institutions. To have ...

How to Alternate Row Color Based on Group in Excel (6 Methods)

When we work on a large datasheet, we need to alternate the row color to visualize our dataset better. We can do the color-altering task as a band or ...

How to Add Data Markers in Excel (2 Easy Examples)

We can add data markers for visualizing and highlighting key information in our dataset. If you are curious to learn how to add data markers in ...

How to Change Marker Shape in Excel Graph (3 Easy Methods)

Excel automatically creates a shape for the marker while creating a Line, (XY) Scatter, and Radar chart. These data markers help the reader to ...

Excel Mapping Data from Another Sheet (6 Useful Methods)

Working in multiple worksheets is very common among regular Excel users. However, mapping data between those worksheets is extremely time-consuming ...

How to Compress Excel File to Smaller Size (7 Easy Methods)

This tutorial will demonstrate the steps to compress an Excel file to a smaller size. When you are dealing with lots of Excel files, then it is very ...

How to Determine What Is Causing Large Excel File Size

Excel is mainly used for creating datasheets and performing calculations without the help of a calculator. Business organizations can't think to pass ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo