Latest Blog Posts

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

Excel Chart: Ignore Blank Axis Labels (with Easy Steps)

There are a few reasons for which you might want to ignore blank axis labels in an Excel Chart. Such as, it can make the chart look cleaner and less ...

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

A Bank Ledger is the bank account balance computed by a bank for each account every business day. It includes all kinds of deposits and withdrawals. ...

Create Cash Flow Statement Format in Excel for Construction Company: 5 Methods

Method 1 - Create a Template Layout Create a layout to allocate the cash flow items into 3 different categories of operations, investment activity, ...

How to Remove Automatic Page Break in Excel: 3 Easy Ways

Method 1 - Using Excel Built-in Option to Remove the Automatic Page Break Steps: Open the worksheet and then go to Files in the top ...

What Is Normal View in Excel? (Detailed Explanation)

While working on Excel, we encounter different views like Normal View, Print Preview, Page Break Preview, Custom View, etc. In this article, we will ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo