Excel Formulas

How to Do Reconciliation in Excel (12 Effective Techniques)

Consider the following dataset example for demonstration. Here the two datasets represent sales information for June and July of 8 products. We will ...

How to Repeat Rows at the Top of Printed Pages in Excel

Suppose you have the following dataset and want rows 2 through 6 to always show at the top of the page when printed. If you press Ctrl + P to ...

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 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 Repeat the Formula in Each Row in Excel -7 Easy Methods

This is the sample dataset.   Method 1 - Dragging the Fill Handle Icon Steps: Select E5. Enter the following formula. ...

How to Calculate Annual Debt Service in Excel (3 Ideal Examples)

In Microsoft Excel, users can perform various operations and find the value of different quantities. Today, we will learn to calculate annual debt ...

How to Add a Comma Between City and State in Excel (6 Ways)

We like decorating our things, even in case of a dataset. Adding comma between city and state will help us to differentiate those two quite easily. ...

How to Repeat Cell Values in Excel (6 Quick Methods)

Method 1 - Copy Cell Values and Paste Directly Steps: Right-click on the cell to open the context menu and select Copy. Select the ...

How to Repeat Rows While Printing in Excel- 3 Methods

Consider a dataset of 100 students’ marks in 3 subjects. To print it and display the header row on each page:   Method 1 - Using ...

How to Repeat Formula in Excel for Whole Column (5 Easy Ways)

Sometimes, we apply a formula in a cell and then repeat the same formula to the entire column in Microsoft Excel. However repeating the same formula ...

How to Reconcile Vendor Statements in Excel (2 Easy Methods)

The following Vendor’s Details table has Invoice No., Date, and Amount columns. The Amount column shows the vendor’s demand for a particular invoice. ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo