Excel Formulas

How to Make a List of Special Characters in Excel (3 Easy Ways)

Whenever you are working with Excel, at some point you will need to use some special characters in your Excel sheet. The main objective of this ...

How to Create a Scoring System in Excel (With Easy Steps)

Microsoft Excel is a powerful software. We can perform numerous operations on our datasets using Excel tools and features. There are many default ...

How to Calculate Percentage of Marks in Excel (5 Simple Ways)

While constructing a mark sheet in Excel, you may need to calculate the percentage of the marks. In this article, you'll learn how to calculate the ...

How to Make a Pattern Repeat in Excel (8 Easy Ways)

Excel is used vastly for calculating a large number of data without using a calculator. Performing the same calculation for each and every input ...

How to Make Cricket Scorecard in Excel (with Easy Steps)

Step 1 - Creating Batting Scorecard Create a dataset like the below image. In this case, we have the Names in Column B, Runs in Column C, Balls ...

How to Make Daily Attendance Sheet in Excel (2 Effective Ways)

Attendance sheets are needed in schools, universities, and businesses to keep records of students' and employees' attendance. Physical handbooks are ...

How to Create Scorecard in Excel (with Detailed Steps)

A scorecard is a powerful tool by which you can determine and visualize your company’s financial, customer, internal business, learning, and growth. ...

How to Convert Bank Statement Text to Excel (3 Easy Methods)

Need to learn how to convert bank statement text to Excel? We are all aware of the significance of bank statements from both a private and ...

How to Calculate T Score in Excel (4 Easy Ways)

If you are searching for the solution or some special tricks to calculate the T score in Excel then you have landed in the right place. There are 4 ...

How to Repeat Multiple Rows in Excel (4 Effective Ways)

This article illustrates how to repeat multiple rows in Excel. If you are working with datasets, then typing the same data, again and again, is both ...

How to Do Bank Reconciliation in Excel (with Easy Steps)

Sometimes, you might need to do Bank Reconciliation to manage your financial condition. In Microsoft Excel, you can perform Bank Reconciliation in ...

How to Do Reconciliation in Excel (12 Effective Techniques)

Reconciliation is a very common term in accounting, especially in the banking sector. There are many ways in Excel to do reconciliation. In this ...

How to Repeat Rows at Top of Specific Pages in Excel

In this article, we will learn to repeat rows at top of Specific Pages in Excel. Microsoft Excel provides users with the opportunity to enlist large ...

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

It is possible to repeat rows in Excel based on cell value through the use of many features. If you are looking for some special tricks to repeat ...

How to Add Number to Existing Cell Value in Excel

In this article, we will learn how to add number to existing cell value in Excel. Often we see that we need to add a particular number to all the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo