Advanced Excel

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

Method 1 - Save the Excel File in the Binary Format Steps: Go to the File tab in the ribbon and select the Save As option. Select the ...

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

  An Overview of a Ledger Book An accounting ledger book records all transactions and financial statements of a company. Under the general ...

How to Map Data Using VLOOKUP in Excel: 4 Quick Methods

Method-1 - Using VLOOKUP Function to Map Data in Excel Steps: Navigate to the G5 cell and enter the expression below. ...

How to Create a Subsidiary Ledger in Excel (Easy Steps)

Introduction to Ledgers A ledger serves as a summarized record of financial transactions related to various accounts. It contains information from ...

How to Make Legend Markers Bigger in Excel: 3 Easy Ways

Method 1 - Change Font Size to Make Legend Markers Bigger in Excel STEPS: Right-click on the Legend Box to open the Context Menu. Select ...

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 Add Markers for Each Month in Excel (With Easy Steps)

Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. Using various charts and graphs, you ...

How to Print a Full Page of an Excel Sheet in A4 Size (5 Methods)

Dataset Overview We’ll be working with a dataset containing employee information, including columns for Employee ID, Name, Gender, Department, and ...

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

Dataset Overview To demonstrate these methods, let’s consider a dataset of 10 fruit consumers. The fruit item names are in column B, and the ...

How to Create a Checkbook Ledger in Excel (2 Useful Examples)

Looking for ways to keep track of your transactions in a checkbook ledger? Then you’ve come to the right place. In this article, we’ll show you 2 ...

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

Example 1 - Adding Data Markers in a Line Chart  We have the following dataset shown in the B4:D13 cells below. The dataset shows the Month number, ...

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

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

[Fixed!] Excel Spreadsheet Opening Larger Than Screen

If you are looking for some special tricks to solve the problem of "Excel spreadsheet opening larger than screen”, you've come to the right place. In ...

Mapping Data from Another Sheet in Excel (6 Useful Methods)

Suppose you have the following two datasets. Method 1 - Link Cells for Mapping Data from Another Sheet in Excel Steps: Insert an ...

How Do I Stop Excel from Opening in Full Screen (4 Easy Ways)

By default, Microsoft Excel tends to open the files in full-screen view. By your definition of the full-screen view, it may be necessary in some ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo