Excel Formulas

How to Insert Carriage Return in Excel Cell (3 Simple Ways)

  Method 1 - Using Keyboard Shortcut Let’s say a cell is describing a student studying a specific subject at a university. The data here is ...

How to Calculate Discount Rate in Excel (3 Quick Methods)

Calculating the time value of money is a very common task in economics and business. One of the most crucial components in determining these is the ...

How to Compare Two Excel Sheets to Find Missing Data (7 Ways)

Sometimes, we need to compare two Excel sheets to find the missing data. We can complete the process in several ways. In this article, we are going ...

How to Make Electronic Raffle Draw in Excel (2 Ways)

To select a winner from a lottery, we need to do a raffle draw. Drawing raffles manually is time-consuming and tedious if there are many ...

How to Calculate GST in Excel (With Easy Steps)

Step 1 - Arranging Proper Dataset We have the Products in Column B and the Price Without GST in Column C. We have to create three ...

How to Summarize Data Without Pivot Table in Excel

Working on loads of data often seems difficult, especially if it has repetitive information. In this situation, most Excel users use a pivot table to ...

How to Get Summary Statistics in Excel – 7 Easy Methods

The following dataset has 3 columns (Name, Math Score, and Science Score). Method 1 -  Using the Status Bar to Get Summary Statistics in ...

How to Cross Reference in Excel to Find Missing Data (6 Ways)

In day-to-day usage, while doing routine work, users need to find missing data using cross-referencing between lists or worksheets in Excel. ...

How to Assign Value to Text and Sum in Excel (2 Easy Methods)

Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Excel is very ...

How to Calculate College GPA in Excel (3 Handy Approaches)

In this tutorial, I am going to show you 3 handy approaches to calculate college GPA in excel. You can use these methods to find out the GPA of any ...

How to Make Automated Attendance Sheet in Excel (Easy Steps)

We often use automated attendance sheets to keep records of the attendance of the employees or students. Using Excel, we can make automated ...

Linking Excel Sheets to a Summary Page (4 Easy Methods)

While working with Microsoft Excel, you may have dealt with several sheets in your workbook. However, if you need to link Excel sheets to a summary ...

How to Calculate Average Score in Excel (7 Suitable Ways)

A common task in sports is to calculate the average score of a player. Microsoft Excel makes calculating the average score easy. Excel has a variety ...

How to Calculate Subject Wise Pass or Fail with Formula in Excel

  Download Practice Workbook Download the practice workbook from here. Calculate Pass Fail with Formula.xlsx Method 1 - Apply ...

How to Make Result Sheet in Excel (with Easy Steps)

If you want to make a result sheet, Excel can be really helpful. The main objective of this article is to explain how to make result sheet in Excel. ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo