Latest Blog Posts

How to Apply the Discounted Cash Flow Formula in Excel

What Is Discounted Cash Flow (DCF) Formula? The Discounted Cash Flow (DCF) formula is a valuation method that helps to determine the fair value by ...

How to Use Page Break in Excel (7 Suitable Examples)

Page Break in Excel is used to separate a worksheet into different pages for printing. Excel automatically insert page break while printing. But it ...

How to Create a Cash Flow Statement Using Direct Method in Excel (Step-by-Step)

What Is a Cash Flow Statement? A cash flow statement contains information about the cash generated and spent during a certain period. It lets you ...

How to Add Double Quotes in Excel (5 Smart Ways)

We'll explain the procedures with a dataset containing the Quotes and Authors columns. In most methods, we'll concatenate the quotes and authors in a ...

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

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

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

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 Excel Formulas Convert Text to Number (3 Easy Ways)

If you are looking for simple ways to know how Excel formulas convert Text to Number, this article will serve the purpose. While working with data ...

How to Reconcile Two Sets of Data in Excel (9 Ways)

The dataset shows two lists containing Company names and their Stock Prices in USD. We want to check if the two lists are an exact match or if there ...

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

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

How to Remove Gridlines in Excel When Printing – 6 Methods

The sample dataset showcases Student ID, Test Score, and Status. Method 1 - Using the Page Layout Tab to Remove Gridlines in Excel When ...

How to Calculate Before Tax Cost of Debt in Excel (3 Easy Ways)

There are two significant sources of financing: debt financing and equity financing. Any company needs to borrow from various sources to finance its ...

How to Hide Columns in Excel with Password (2 Easy Ways)

The Excel functions to hide and reveal columns are often used, making it simple to conceal and reveal them. However, there are occasions when you ...

How to Add Cell Borders Inside and Outside in Excel (5 Methods)

Suppose we have a dataset of some Student’s Name, ID, and specific Departments. Let's add borders inside and outside the cells using Excel’s built-in ...

How to Unhide All Columns with Excel VBA (8 Examples)

For various reasons, we hide columns and rows in Excel. At the same time, we may need to unhide them for our needs. Unhiding them may involve various ...

How to Insert Page Number Using VBA in Excel: 3 Macros

Method 1 - Insert a Page Number in a Footer Using Excel VBA Steps: Go to Insert, choose Text, and select Header & Footer. Scroll ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo