Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

How to Use Timer Function in Excel VBA (3 Easy Examples)

In this article, I will show you how to use the VBA Timer function in Excel with 3 easy methods. While working on an Excel sheet, we have to do various kinds ...

How to Create Cascading Combo Boxes in Excel VBA UserForm

In this article, I will show you the procedures of cascading combo boxes in Excel VBA UserForm. While working in Excel, you may need to make some interactive ...

How to Get Excel VBA Combobox with RowSource Named Range

In this article, I will show you how to create Excel VBA Combobox using RowSource named range with four easy steps. While using Excel, you may need to do a ...

How to Get Complex Number Magnitude in Excel (2 Easy Methods)

In this article, I will show how to get the magnitude of a complex number in Excel by using 2 easy methods. You may need mathematical calculations when working ...

How to Create Excel Data Connection to Another Excel File

In this article, I will show how to create an Excel data connection to another Excel file by using 3 easy methods. When you work on an Excel worksheet, you may ...

How to Delete Text Box in Excel (3 Easy Ways)

In this article, I will show how to delete a text box in Excel in three ways. While working on an Excel worksheet, you need to handle different things. Text ...

How to Calculate Delta Delta CT in Excel (With Easy Steps)

In this article, I will show how to calculate delta delta CT (Cycle Threshold) in Excel by using 4 easy steps. When you work on an Excel worksheet, you may ...

How to Make Exponent in Excel Text (7 Easy Methods)

In this article, I will show how to make an exponent in Excel text by using 7 easy methods. You may need to do mathematical calculations when you work on an ...

How to Extract Data from Multiple Web Pages into Excel

In this article, I will show you how to extract data from multiple web pages into Excel. While working on an Excel worksheet, sometimes you may need to extract ...

How to Randomize a List in Excel Into Groups (5 Suitable Ways)

In this article, I will show you how to randomize a list in Excel into groups. While working on an Excel worksheet, you need to do a massive type of work. ...

How to Write 1st 2nd 3rd in Excel (3 Easy Ways)

While working on an Excel worksheet, you need to do a massive type of work. Sometimes you may need to rank any dataset ordinally. In this article, I will show ...

How to Change Page Margins to Wide in Excel

In this article, I will show you how to change page margins to wide in Excel. While working on an Excel workbook, sometimes you may need to plot any dataset on ...

How to Delete Empty Columns with Header in Excel (4 Easy Ways)

The article will provide you with some quick tricks to delete empty columns with a header in Excel. While working on an Excel worksheet, you may need to deal ...

How to Calculate Working Days in a Month in Excel (4 Easy Ways)

In Excel, we can do a wide range of work. One of them is to calculate working days in a month. In this article, I will show you how Excel calculates working ...

How to Write Latitude and Longitude in Excel (2 Easy Ways)

In Excel, we can do a wide range of work. We can Write Latitude and Longitude in a specific format in Excel. Here, in this article, I will show you how to ...

Browsing All Comments By: Souptik Roy

Advanced Excel Exercises with Solutions PDF