# Sudipta Chandra Sarker

About author

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel. Here I will be posting articles related to this. My educational degree is BSc in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology, Bangladesh. I have a great interest in research and development. I always try to gather knowledge from various sources and try to make innovative solutions.

## How to Calculate Shadow Price Linear Programming in Excel

In this article, we will learn how to calculate shadow price linear programming in Excel. The Shadow Price is the change in the value of the objective function ...

## How to Use Excel LARGE Function with Criteria (4 Suitable Ways)

In this article, we will learn how to use the LARGE function with criteria in Excel. With the LARGE function, you can get the maximum number from a range. ...

## How to Add Vertical Line to Histogram in Excel (With Easy Steps)

In this article, we will show you how to add vertical line to histogram in Excel. Basically, a histogram is a column chart that displays how frequently a ...

## Excel IF Statement Between Two Numbers (4 Ideal Examples)

In this article, we will show 4 ideal examples of how to use if statement between two numbers in Excel. To check if a number is within 2 boundary ranges, we ...

## How to Do 2D Interpolation in Excel (2 Suitable Ways)

In this article, we will show how to do 2D interpolation in Excel. It is possible to do the task of interpolation for both linear and non-linear datasets. You ...

## How to Create Progress Doughnut Chart in Excel

In this article, we will show how to create a progress doughnut chart in Excel. The Progress Doughnut Chart shows the percentage of progression of a task. It ...

## How to Convert Negative Value to Positive in Excel Using Formula

In this article, we will show how to convert negative value to positive in Excel using formula. We will create Excel formulas with common functions like IF, ...

## How to Create Construction Bar Chart in Excel (With Easy Steps)

In this article, we will learn how to create a Construction Bar Chart in Excel. The construction Bar Chart is a part of construction management. It is used for ...

## How to Set Logarithmic Scale at Horizontal Axis of an Excel Graph

In this article, we will learn how to set the logarithm scale as the horizontal axis in Excel. If you want to observe the change of data over a large period of ...

## Excel Formula for Finding Odd or Even Numbers

In this article, we will show formula for finding odd or even numbers in Excel. We will create Excel formula with common functions like IF, MOD, ISEVEN and ...

## How to Create Product Catalogue in Excel (with Easy Steps)

In this article, we will learn how to create a product catalogue in Excel. A Product Catalogue carries information on new or main products of a store. It is ...

## How to Use DEVSQ Function in Excel (3 Suitable Examples)

In this article, we will show how to use the DEVSQ function in Excel. The DEVSQ function is used to calculate the sum of squares of deviations of data points ...

## How to Use Advanced Filter for Date Range in Excel (2 Easy Ways)

In this article, we will learn how to use the advanced filter for the date range in Excel. Assume you have sales data for one month but don't want to know ...

## [Fixed!] NUM Error in Excel (4 Reasons with Solutions)

In this article, we will learn what are the reasons behind #NUM! error in Excel and show you how to solve the problem. When working with an Excel Worksheet, ...

## Delta Hedging Example in Excel (3 Ideal Examples)

In this article, we will learn how to perform Delta Hedging in Excel. Delta Hedging concept is used in Stock Exchanges. It is a strategy used for reducing the ...

Browsing All Comments By: Sudipta Chandra Sarker

Advanced Excel Exercises with Solutions PDF