How to Perform Calculus in Excel? (Differentiation and Integration)

Calculus is an important part of mathematics. We may have to perform several calculus operations for practical analysis. Even though there are no Excel functions dedicated to Calculus operation, we can find the Differentiation and Integration in an Excel worksheet.

In this article, we will show how to perform Differentiation and Integration in Excel. We will calculate Differentiation and Integration by manual formula. Also, we are going to use the Formula with finite difference method for finding derivatives. On the other hand, we will also find the area under a curve by Integration.

Also, we will show how to calculate average velocity by the SLOPE function.

Calculus in Excel

Download Practice Workbook

What are the Ways to Calculate Differentiation in Excel?

There are two ways to calculate Differentiation in Excel. We can do so manually (mathematical calculation) or by using a generic Excel formula with functions.

1. How to Calculate Differentiation Manually in Excel?

We can calculate the differentiation manually with some easy steps.

  • First, set the differentiation equation.
y= x2+7x+5
Dy/Dx = 2x+7
  • Then, use the differentiation result as a reference formula.
  • We have taken several x-values and their corresponding y-values. As we have the differential formula for our equation, we can find differentiation at every x-value.

Showing Dataset to find Differentiation

  • To find the differentiation, write the following formula in D8 and press ENTER.
  • We got differentiation for the first point which is -1.
  • Now, hold and drag the D8 cell downwards to find differentiation for all points.

Showing Result after finding all Differentiations

2. Can We Find Differentiation by Formula?

Yes, we can use a basic differential formula of finite difference to find Differentiation. The finite difference formula is given as:

f’(x)= {f(x+h)-f(x)}/h

In this method, we are going to set the value of h and find f(x+h) and f(x). And, from these values, we will find the differentiation f’(x). We have set the value of h as 0.0001.

Showing Dataset to find Differentiation with Formula

  • Write the following formula in E8 to find the value of x+h.

  • Then, hold and drag the E8 cell downwards to get all x+h values.

Finding x+h values

  • To find the values of f(x+h), write the following formula in F8 and press ENTER.

  • Then, hold and drag the F8 cell downwards to find all f(x+h).

Finding F(x+h) Values

  • Now, to find f’(x), write the following formula in G8 and press Enter.

  • Then, hold and drag the G8 cell downwards to find all f’(x).

Using manual formula to find Differentiations

What are the Ways to Find Integration in Excel?

We can find Integration manually in Excel. Also, we can find the Area of a surface using the Trapezoidal formula.

1. How Can You Calculate Integration Manually?

To calculate Integration manually, first, we have to find the Integration result. Then, we will insert that reference formula in the Excel sheet.

The integration of the equation is given as:

∫y.dx =x^3/3+(7x^2)/2+5x

Showing Dataset for Manual Integration

  • Write the following formula in D8 and press ENTER.

  • Now, hold and drag the D8 cell downwards to find integration at all points.

Finding Integration with Manual Formula

2. How Can We Find the Area under the Curve with Integration?

To find the Area under a curve, we can use the Trapezoidal integration formula.

Let’s find the Area under the same equation from the x-values of -2.5 to 2.5. For this procedure, we will use the trapezoidal area rule. And, for accurate values, we have to set the x-value interval as low as possible. We will find the areas of each interval and then we can sum all those interval areas to get the total area.

Showing Dataset to Find Area Under Curve

  • Write the following formula in D8 and press ENTER.

  • Then, hold and drag the D8 cell downwards to get all the interval areas.

Using Trapezoidal Formula to Calculate each Interval Area

  • And lastly, to sum up all these area intervals, we will use the SUM function. Here is the overview of the SUM function:
Syntax of SUM Function

Click the image for a detailed view

  • Use the following formula in D18.


Applying the SUM function to find total Area Under Curve

Can You Find a Derivative with the SLOPE function?

Yes. With the SLOPE function, we can determine the average slope or derivative of a given dataset.

The overview of the SLOPE function is given in the following image:

Syntax of SLOPE Function

Click the image for a detailed view

Let’s find the average velocity with this in-built function.

  • Write the following formula in C14 and press ENTER.

  • You will get the average velocity which is 4.74 ms-1.

Using SLOPE Function to Find Derivative

Which Things Should You Remember?

  • When you are finding an area under a curve, you should take as much interval as possible. The more interval you take the more your result becomes accurate.
  • The result from these procedures is not cent percent accurate. Different methods may give you different results.
  • While differentiating with the finite difference method, you have to take the value of h very small for more accuracy.
  • Be careful while using the formulas. Especially in the case of relative and absolute referencing.

Frequently Asked Questions

1. Can I Graph Calculus Formulas in Excel?

Answer: Yes. You can insert the linear or exponential formulas, their derivatives, integrals, etc. in an Excel graph. Navigate to the Insert tab and select a suitable Area, Line, or any other chart to show your differentiation or integration values. Plotting the calculus results will visualize your results in a meaningful way.

2. Are there any Limitations to Using Calculus in Excel?

Answer: You can use Excel to solve simple Calculus problems. To find derivatives, you can use the SLOPE function. However, MS Excel doesn’t have any dedicated functions to solve complex calculus equations.

3. What can I Use Calculus for?

Answer: We can use calculus to find velocity, acceleration, or data trends with differentiation. Also, we can find the area under a curve or the volume of an object by integration.


We have shown you how to perform Calculus in Excel. As there is no dedicated Excel function, we had to find differentiation and integration manually. To find basic differentiation and integration, first, we had to find the generic formula manually. Then, we used Excel to find their values for different X-values. Also, we used the finite difference formula to find derivatives. We also showed you how to find the area under the curve using basic Excel tricks.  We hope you find the content of this article useful. If there are more queries or suggestions, feel free to mention them in the comment section.

Calculus in Excel: Knowledge Hub

<< Go Back to | Excel for Math | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Sourav Kundu
Sourav Kundu

Sourav Kundu, BSc, Naval Architecture & Marine Engineering, Bangladesh University of Engineering and Technology, is a dedicated technical content creator of the ExcelDemy project. He has a keen interest in Excel and he leverages his problem-solving skills to provide solutions on user interface with Excel. In his position as an Excel & VBA Content Developer at ExcelDemy, Sourav Kundu not only adeptly addresses challenging issues but also demonstrates enthusiasm and expertise in navigating complex situations. Apart from creating... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF