Excel Formulas

How to Convert Minutes to Days in Excel: 3 Easy Methods

Method 1 - Convert Minutes to Days Manually in Excel Steps: Go to C5 and write down the formula =B5/1440 Ppress ENTER to get ...

How to Convert Hours to a Percentage in Excel – 3 Methods

The dataset showcases Entry and Exit time of different employees. To convert the working hours to a percentage: Method 1 - Use a ...

How to Convert GMT to EST in Excel (4 Quick Ways)

If you work for a foreign international organization, then you might need to know the time of different regions of the world. Because of the rotation ...

How to Do Integration in Excel (2 Handy Approaches)

Integration is One of the most crucial mathematical tools. We can use it to compute area, volume, and many other beneficial metrics. We can also use ...

How to Calculate Remaining Shelf Life Percentage in Excel (With Easy Steps)

  Step 1 - Prepare the Dataset Insert the product names in the Product column. Insert the manufacturing date in the MFG Date column. ...

How to Compare Dates in Two Columns in Excel (8 Methods)

Method 1 - Compare Dates in Two Columns Whether They Are Equal or Not Steps: Select an appropriate cell (D5 in this example) and use the ...

How to Create a Filtering Search Box for Your Excel Data (5 Methods)

In the below dataset, we have 3 columns: Customer Name, Region and Product. Method 1 – Using Data Validation  Steps: Select a cell ...

Add 15 Minutes to Time in Excel: 4 Easy Methods

Method 1 - Use SUM Function to Add 15 Minutes to Time in Excel Steps: Add a new column on the right side and remove all the minute values. ...

How to Create a Scoring Matrix in Excel (Easy Steps)

What is a Scoring Matrix and Where Do We Use It? A scoring matrix is a valuable tool for assessing the relative worth of various items, such as ...

How to Add Minutes and Seconds in Excel (3 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. Sometimes, ...

How to Subtract 30 Minutes from a Time in Excel (8 Easy Ways)

This article provides the answers to your questions on how to subtract 30 minutes from a time in Excel. There are many ways to take 30 minutes out of ...

How to Create a Weekly Timesheet in Excel (with Easy Steps)

Are you an HR professional, looking to make a weekly timesheet in Excel? Then, I have some good news for you! The following article demonstrates a ...

How to make a List of Countries by Time Zone in Excel (with Easy Steps)

In the dataset below, we have two columns: Time Zone and Country. Click the Number Format icon (Home > Number section) or CTRL+1 to ...

How to Check If Month Is Between Two Dates in Excel (2 Ways)

Excel users can solve many problems by using some formulas or proper commands or by combining both in Excel. One such problem is checking if a ...

How to Count Filtered Rows with Criteria in Excel (5 Easy Ways)

For illustration, here is a dataset with the July Sales Report of fruit sales in the USA and Australia. Filter this dataset. Select cell ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo