Advanced Excel

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

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo