How to Create Excel Formulas

How to Create a Conditional Formula in Excel (5 Easy Ways)

Let's use a Score List of Math scores of some students. This dataset contains the ID, Student Name, and their corresponding Marks in columns B, C, ...

How to Create a Formula Using Defined Names in Excel -7 Examples

  The sample dataset (B4:D13) showcases Item, Quantity, and Unit Price of Fruit Sales.   Example 1: Multiplying Named ...

How to Apply a Formula to Multiple Sheets in Excel (3 Methods)

  Here we use three worksheets on the Salary of Employees for January, February, and March. We used the short form of the month names as the ...

How to Use Multiple Excel Formulas in One Cell (with Easy Steps)

For providing interactive spreadsheets that produce outcomes based on input data. All of this is made possible by Microsoft Excel's formulae and ...

How to Apply Formula in Excel for Alternate Rows (5 Easy Ways)

While working in Excel, sometimes we need to apply formula for alternate rows. For a small dataset, this task can be done quite easily. But, when we ...

How to Apply Formula to Entire Column Using Excel VBA

In this tutorial, I am going to show you 3 simple methods on how to apply a formula to an entire column using Excel VBA. These methods will save a ...

How to Exclude Zero Values with Formula in Excel (3 Easy Ways)

Method 1 - Use Formula with IF Function to Exclude Zero Values in Excel Let’s say, we have a dataset displayed in the (B4:D8) cells. Here, the ...

How to Create a Formula in Excel for Multiple Cells (9 Easy Ways)

Applying a formula for multiple cells is a too common task in Excel. That’s why we should have proper knowledge of this operation. So here I’ll show ...

How to Create a Custom Formula in Excel (2 Practical Examples)

While working in Excel or making custom worksheets for business analysis, we may need to create a custom formula of our own. Despite all the ...

How to Apply the Same Formula to Multiple Cells in Excel

Scenario: Let’s consider a sales data set where sellers receive a 10% commission on each product sold. To calculate the commission, we’ve placed a ...

How to Insert Formula for Entire Column in Excel (6 Quick Ways)

The heart and soul of an Excel spreadsheet are its formulas and typically you apply these formulas in a range of cells located in columns or rows. ...

How to Make FOR Loop in Excel Using Formula (3 Examples)

Don’t you want to use Excel VBA and want to make a FOR Loop in Excel using Formula? In this article, I’ve shown how you can make FOR Loop using ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo