Latest Blog Posts

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

How to Filter Special Characters in Excel – 3 Methods

What Is a Special Character? Non-alphabetic and non-numeric characters are called the special characters. The punctuation marks and other symbols, ...

How to Add Primary Major Horizontal Gridlines in Excel (2 Ways)

When you work with a large and complicated chart, gridlines can help make it better understood. Gridlines help to show the axis division in a chart. ...

How to Remove Vertical Line in Excel: 5 Ideal Examples

Method 1 - Removal of Excel Frozen Pane Vertical Line Steps: Go to the View tab. Select the Freeze Panes option. Click on Unfreeze ...

How to Link 3 Financial Statements in Excel – 4 Steps

What Is a Financial Statement? There are three main types of financial statements; balance sheet, income statement, and cash flow statement. These ...

Create Cash Flow Statement Format with Indirect Method in Excel

What Is a Cash Flow Statement? A cash flow statement is a type of financial statement that shows the inflow and outflow of cash and cash equivalents ...

How to Create Cash Flow Statement Format in Excel

If you searching for a ready-to-make cash flow statement format, then you have definitely landed in the right place. Excel allows you to create cash ...

How to Calculate Payback Period in Excel (With Easy Steps)

  Step 1 - Calculating Net Cash Flow Input data. In this example, we’ll type Cash Inflows and Cash Outflows of 6 years. See the picture ...

How to Make Time Attendance Sheet in Excel: 2 Easy Methods

Method 1 - Make Generic Time Attendance Sheet Step 1: Assign Date & Day Create a sheet table for one of the employees (i.e. Mike Almas) ...

How to Show Negative Numbers in Brackets and in Red in Excel (2 Methods)

Dataset Overview We will use a dataset containing 10 numbers of which 3 are negative. Method 1 - Using Excel's Format Cells Option  The ...

How to Do Ordinary Annuity in Excel (2 Methods)

An annuity that pays out at the end or beginning of each period is referred to as an ordinary annuity. We can easily calculate the Ordinary Annuity ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo