Excel Formulas

How to Convert GMT to IST in Excel (2 Suitable Ways)

Every country has a different time zone in this world. Greenwich Meridian Time is the standard time for all of these time zones. In this article, I ...

Return Expected Value If Time Is Greater Than 1 Hour in Excel

In this article, we discuss several ways to determine if a difference between two times is greater than 1 hour in Excel. We'll use a simple dataset ...

How to Calculate Confidence Interval for Population Mean in Excel

Confidence interval or CI is the measurement of the range of estimates for a particular parameter. This is an important concept in data analysis. As ...

How to Highlight Blank Cells with Conditional Formatting in Excel

While working with a dataset in an Excel file, it is very normal that some cells may remain blank. If you apply any formula referring to the blank ...

Formula for Weekly Dates in Excel (5 Examples)

In this article we will demonstrate various formulas for Weekly Dates in Excel. We'll use the dataset below to illustrate our methods, and assign ...

Excel Confidence Interval for Difference in Means (2 Examples)

This article illustrates how to calculate the Confidence Interval for a difference in Means in Excel, both by using Excel's statistical functions and ...

How to Clear Cell Content Based on a Condition in Excel – 7 Methods

This dataset contains similar data and an overview of the methods applied. The sample dataset showcases information about sports cars. ...

How to Merge Two Columns in Excel With a Space

Users often need to merge data from two columns in Excel. Often they merge data without space. That creates obscurity in the presentation of the ...

Excel Conditional Formatting Based on Past or Due Date

Method 1 - Using Excel TODAY Function to Get Past or Due Date Steps: Insert the following formula in Cell D5- =C5<TODAY() Press ...

Convert Decimal Coordinates to Degrees Minutes Seconds in Excel

  Method 1 - Using the Text to Columns Feature Steps Make a dataset that includes several columns including decimal degrees and separate ...

How to Calculate P-Value from Confidence Interval in Excel

If you want to calculate P-Value from Confidence Interval in Excel, you have come to the right place. Here, we will walk you through 3 easy and ...

How to Add Hours, Minutes, and Seconds in Excel

In this tutorial, I am going to share with you 3 simple methods to add hours, minutes, and seconds in Excel. Whether you are working with employee ...

How to Add Hours and Minutes in Excel (4 Suitable Methods)

Below, learn 4 easy methods for adding Hours and Minutes in Excel. The following dataset contains 3 columns: Employee Name, Working Time, and Extra ...

Return Value If Time Is Greater Than and Less Than a Range in Excel: 6 Methods

Method 1 - Using Nested IF Functions Steps Select cell D5. Write down the following formula in the formula box. ...

How to Convert Time Zones in Excel (3 Ways)

Download the Practice Workbook Convert Time Zones.xlsx 3 Ways to Convert Time Zones in Excel Here is a dataset of individual times in ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo