Latest Blog Posts

How to Paste in Reverse Order in Excel – 7 Methods

This is the sample dataset. Method 1 - Using the Sort Command 1.1 Pasting in Reverse Order Vertically Steps: Select D5 and enter 1. ...

Excel VBA: Select Visible Cells After Autofilter (4 Examples)

The following dataset has 4 columns displaying people's Names, where they are From, their Age, and Income. Method 1 – Selecting Visible ...

[Solved]: Remove Hyperlink Not Showing in Excel (2 Solutions)

Dealing with hyperlinks in Microsoft Excel can be problematic sometimes. If the users accidentally, press on the cell with the hyperlink, the link ...

How to Use COUNTIF for Date Greater Than 30 Days in Excel

Looking for ways to know how to count dates greater than 30 days using the COUNTIF Function in Excel? Sometimes, we want to count dates that are ...

How to Convert Seconds to Hours Minutes Seconds in Excel

Since Excel stores time in a numeric system, it is a simple process to convert seconds into hours, minutes, and seconds format. In this article we ...

How to Select Names Randomly in Excel (5 Useful Methods)

We have made a dataset as a List of Players. Method 1 - Using the RAND Function to Randomly Select Names in Excel Use the following ...

How to Find Upper and Lower Limits of Confidence Interval in Excel

We have the following sample dataset containing some samples showing their weight distribution. Using this dataset, we will determine the upper and ...

How to Convert Minutes to Hundredths in Excel (3 Easy Ways)

In this article, we demonstrate how to use arithmetic operators and formulas to convert minutes to hundredths in Excel. Say we have the dataset ...

How to Merge Two Columns in Excel Without Losing Data

In this tutorial, I am going to show you 5 easy methods to merge two columns in Excel without losing data. You can quickly use these methods even in ...

How to Reverse the X and the Y Axis in Excel – 4 Methods

The dataset showcases the yearly orders of an online shop. In the chart, Excel keeps the first column horizontally and the second column vertically ...

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 Mirror Cells with Formula in Excel (3 Simple Ways)

Sometimes, we have to deal with a huge amount of data stored in several worksheets. In that case, we can mirror the cells in Excel instead of writing ...

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 Reverse Order of Data in Excel (4 Useful Methods)

To illustrate, we have used 2 types of datasets in Excel; one for horizontally reversing, and the other one for vertically reversing, the data order ...

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

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo