Latest Blog Posts

[Fixed!] Cells Are Not Highlighting in Excel Formula (2 Solutions)

In Microsoft Excel, we use different formulas for analysis and calculation. As a default feature in Excel, after clicking on the cells containing ...

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 Graph an Equation in Excel Without Data – 4 Steps

A simple linear equation: y = mx + c will be used. This equation will return straight lines when plotted on a graph. Here, x is an independent ...

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 Undo a Table in Excel: 2 Easy Methods

Method 1 - Undo a Table by Converting to Range Steps: Select any of the cells in the table. In the ribbon, a tab named Design or Table Design ...

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

How to Convert Minutes to Seconds in Excel (2 Quick Ways)

Here, we have a dataset containing the Player Name and Swim Time in minutes of swimmers. Method 1 - Using an Arithmetic Formula to Convert ...

How to Draw Lines in Excel (2 Easy Methods)

Excel is a versatile software with many features. One of the most used features is generating graphs with it and then showing the data related to ...

How to Go to Last Non Empty Cell in Column in Excel (9 Easy Ways)

We'll use the following sample dataset to check how to go the last non-empty cell. Method 1 - Using the XMATCH Function The XMATCH ...

How to Convert Hours to Days in Excel: 6 Effective Methods

The dataset below shows a Project Schedule from beginning to end. Along with it, we can see the Working Hours of each phase in the schedule. As you ...

[Fixed!] Paste Visible Cells Only Not Working (4 Possible Solutions)

With Microsoft Excel’s filtering feature, we can hide irrelevant rows and make particular rows visible. It is a handy feature to sort out and work ...

How to Select Visible Cells in Excel with VBA: 5 Easy Methods

Method 1 - Select Only Visible Cells Steps: ⧭ Open VBA Window: VBA has its own separate window to work with. You have to insert the code in ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo