Sudipta Chandra Sarker

About author

Sudipta Chandra Sarker, BSc, Electrical and Electronic Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked on the ExcelDemy project for over a year. For ExcelDemy, he has authored 42 articles and reviewed over ten articles. He is employed as a junior software developer at the moment. He aims to create various useful Microsoft Office Add-ins, extending the functionality of Office programs. His interests span Microsoft Office Suites, Data Science, VBA, VB.NET, ASP.NET, C#, Excel, and Desktop application development.


Junior Software Developer

Education in Electrical and Electronic Engineering, BUET


VB.NET, C#, C, Matlab, Verilog, Assembly Programming, Microsoft Excel, Microsoft Office, Machine Learning (Basic)


  • Technical Content Writing
  • Software Developing
  • Team Work

Undergraduate Projects and Thesis

  • SymSwarm: A Two-staged Decentralized Symmetrical Pattern Formation paradigm for a Swarm in Mobile Robots
  • Identify sources and estimate the amount of carbon emission in local areas to aid scientists in mapping carbon sources and sinks. (NASA Space APP Challenge 2020)

Research & Publication


  • Currently working as Junior Software Developer in Software Development Team.
  • Started technical content writing of Excel & VBA on 1 November 2022.

Latest Posts From Sudipta Chandra Sarker

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

Method 1 - Use IF Statement Between Two Numbers in Excel 1.1. Use IF Statement Between Two Numbers Exclusively Declare the boundary numbers. We have ...

How to Do 2D Interpolation in Excel: 2 Suitable Ways

Method 1 - Perform Interpolation of Linear 2D Data in Excel 1.1 Apply Mathematical Equation for Linear Interpolation There is an established mathematical ...

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 Create Construction Bar Chart in Excel (With Easy Steps)

  Step 1 - Prepare the Dataset The dataset needs to contain the task schedule of a project. Column B contains the various tasks. Column C ...

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

How to Create A Product Catalog in Excel: 5 Methods

Method 1 - Make the Dataset Ready Collect the information about the mobiles stored in the shop. Collect the images of the mobiles that are available. ...

How to Use Advanced Filter for a Date Range in Excel – 2 Methods

    The dataset showcases sales quantity of electronic products on different dates in January, February and March of 2022. Method 1- ...

Delta Hedging in Excel – 3 Examples

  What Is Delta Hedging? In stock markets, delta hedging is used to lower the risk and maximize profit.   Example 1- Calculate Delta ...

How to Create Monthly Duty Roster Format in Excel

To create a monthly duty roster in Excel, first we'll create a roster template, then fill the roster for a specific month into this remplate as an example. ...

How to Create a Lottery Prediction Algorithm in Excel – Easy Steps

  The sample dataset contains 2 columns. The 1st one with a series of lottery numbers and a 2nd column, in which the probability of selecting a serial ...

How to Create Pipeline Report in Excel (With Easy Steps)

In this article, we will learn how to create a pipeline report in Excel. A pipeline report is very important for any company. The company can track how many ...

How to Create Fibonacci Calculator in Excel: 8 Methods

Method 1 - Insert Format of Fibonacci Calculator Insert a format of the calculator. We have our format for the Up Trend. Method 2 - Add ...

Browsing All Comments By: Sudipta Chandra Sarker

Advanced Excel Exercises with Solutions PDF