Latest Blog Posts

How to Calculate Incremental Cash Flow in Excel (2 Examples)

For any business undertaking any kind of decision, especially whether to make an investment in a new venture or reinvest in an old project, ...

How to Repeat Rows in Excel Based on Cell Value (4 Easy Ways)

In this article, we will use four effective methods to repeat rows based on cell values in Excel: using VBA code, the VLOOKUP function, the IF ...

How to Add a Number to an Existing Cell Value in Excel

Method 1 – Using the Simple Formula Steps: Select the cell where we will keep the updated value. In our case, cell E5. The entire column called ...

How to Repeat Formula in Every nth Row in Excel (2 Easy Ways)

Sometimes, we apply a formula in a cell and then repeat the same formula in every nth row in Microsoft Excel. Here n can be any integer like ...

How to Create Table of Contents Without VBA in Excel

While working with Microsoft Excel, you may have dealt with several sheets in your workbook. However, if you need to create a table of contents with ...

How to Create a General Ledger from a General Data Journal in Excel

What Is a General Journal? The general journal is an accounting record of a company’s financial transactions. It is the master of all company ...

How to Calculate Annuity Payments in Excel (4 Methods)

Method 1 - Using the PMT Function to Calculate Annuity Payments  Steps: Select cell C9 where you want to calculate the Annual Investment. ...

How to Repeat Cell Value X Times in Excel (7 Easy Methods)

The dataset contains 3 Products. We’ll repeat the products according to the Repeat Time. Method 1 - Repeat a Cell Value X Times with a ...

How to Insert Logo in Excel Header (4 Easy Ways)

Looking for ways to know how to insert logo in Excel header? We want to insert a logo of a company or institute in Excel header. Here, you will find ...

How to Remove the Page Number from the Page Break Preview in Excel – 2 Methods

When you view a worksheet in Page Break Preview, Excel displays page breaks as dashed lines. By default, the page number appears at the center of ...

[Fixed!] Print Preview Not Available in Excel

Solution 1 - Editing Page Layout Tab Options Steps: Go to the Page Layout tab from the Ribbon. Select Margins from the Page Setup group. ...

How to Generate XML File from Excel Using Macro (3 Methods)

The first dataset lists the names that will be applied to the new XML files. This sample dataset will be converted to an XML file. ...

How to Print Borders at Page Break in Excel (2 Quick Methods)

If your dataset has only outside borders and doesn't contain borders in every row then you won't get borders at the page breaks after printing. So it ...

How to Clear Print Area in Excel (2 Easy Ways)

A print area is a set of cells that will be printed out in full. Set a print area to only contain your selection if you don't want to print the ...

How to Make a Title in Excel (3 Suitable Methods)

Suppose we have a dataset containing some months and the temperature in degrees in two locations. The dataset has no titles. Let's add some. ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo