- MS Excel Basics
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Context Help

- Editing Worksheet
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Undo Changes

- Formatting Cells
- Excel - Setting Cell Type
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting

- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format

- Working with Formula
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Using Functions
- Excel - Builtin Functions

- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Keyboard Shortcuts

- MS Excel Resources
- Excel - Quick Guide
- Excel - Useful Resources
- Excel - Discussion

# How to calculate the average rate of change in Excel?

If you want to calculate the average speed and how much time you will spend going from one place and another by bicycle, then you need to know the average speed when you drive a bike.

For an instance, consider you have recorded the time and distance at the time of traveling, now with that data, you can calculate the average bicycle speed – the average rate of change in an Excel sheet.

Follow the steps given below to calculate the average rate of change in an Excel sheet.

## Step 1

Open a Microsoft excel sheet and enter the data of time and distance as shown in the below screenshot for your reference. You can also change the time and distance as per your wish.

## Step 2

Now you need to select a blank cell beside the cell with the last distance and enter the below given **formula** to calculate the average rate of change and press the enter key as shown in the below screenshot for your reference.

=(B7-B2)/((A7-A2)*24)

## Step 3

Now you need to right click the enter formula cell and then select format cell from the list as shown in the below screenshot for your reference.

## Step 4

Once you click on the format cell you will see a dialog box, in that select **number** from the category and then **type 1** in decimal place, click on **ok** as shown in the below screenshot for your reference.

Now you have calculated the average bicycle speed which is the average rate of change and format in excel. After formatting, you will see the result as 9.0 as shown in the below screenshot for your reference.

**Note** − Not only format a cell using the format cell command by right-clicking the cell which as a formula, but you can also format the average bicycle speed by selecting the increase or decrease button on the home page. Kindly find the below screenshot for your reference.

## Conclusion

In this tutorial, we used a simple example to demonstrate how you can calculate the average rate of change in Excel.

- Related Articles
- How to calculate average/compound annual growth rate in the Excel?
- How to calculate running total /average in Excel?
- How to calculate the moving/rolling average in an Excel?
- How to calculate average between two dates in Excel?
- How to calculate average cells from different sheets in Excel?
- How to calculate weighted average in an Excel Pivot Table?
- How to calculate average speed from distance and time in Excel?
- How to calculate average without max and min values in Excel?
- How to calculate average age by year/month/date in Excel?
- How to calculate the average in a column based on criteria in another column in Excel?
- How to Average the Absolute Values in Excel?
- How to calculate Accounting Rate of Return?
- How to change the case of text in Excel?
- How to calculate percentage of total in Excel?
- How to calculate / get day of the year in Excel?