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 Clear Multiple Cells in Excel: 4 Ways

Using Context Menu Select the cells/ranges to clear. Right-click on the selection for the context menu. Select the Clear Contents command. ...

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 Remove Last Modified By in Excel (3 Ways)

Why Should We Remove “Last Modified By”? In a word - confidentiality. Every Excel file contains some information like Author name, Organization ...

How to Get Sensitivity Report from Solver in Excel

Step 1 - Prepare Your Dataset Suppose we want to make of solution of Nitric Acid, Potassium Hydroxide and Water. Our target volume of the solution ...

How to Reverse a Number in Excel – 6 Quick Examples

Only 4-digit numbers were used. Example 1. Combining the SUM and the VALUE Functions Steps: Go to C5 and enter the formula: ...

How to Insert Last Modified Date and Time in Excel Cell

We’ll use a sample dataset, with Input in column B and the Timestamp in column C. We'll input the timestamp in column C whenever we modify the ...

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

How to Solve an Equation for X When Y is Given in Excel (2 Methods)

Method 1 - Use of Solver Feature Enable Solver Feature Go to the File tab. Select Options. Click on Add-ins and select Go. ...

How to Trace Dependents in Excel (2 Easy Methods)

While working in Excel, it is important to know how to Trace Dependents in a set of data. Knowing to Trace Dependency of data helps an Excel user to ...

Returning a Value If Time Is Between a Range in Excel – 8 Examples

This is the sample dataset.   Example 1- Using the IF Function Consider the following criteria: Steps: Select a cell ...

How to Reverse a String in Excel: 3 Suitable Ways

Method 1 - Using MID and CONCATENATE Functions to Reverse a String in Excel Steps: Enter the following formula in cell C4: ...

How to Create Search Box in Excel with Conditional Formatting (5 Ways)

In this article we will demonstrate 5 ways to create a search box in Excel with Conditional Formatting. We'll use the following dataset containing ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo