Look Who it Was Random video

Excel - Fibonacci Sequence in Excel - Episode 645

1,981 views · Published 26 March 2009 · 1:38 · Indexed 6 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Fibonacci Sequence in Excel
Welcome back to another episode of MBExcel netcast! In today's video, we have a question from John in New York. John wants to know if there's a way to create the Fibonacci sequence in Excel. For those who are not familiar, the Fibonacci sequence is a series of numbers where each number is the sum of the two previous numbers, starting with 0 and 1. And the good news is, it's really easy to do in Excel!

To create the Fibonacci sequence, we simply need to enter a formula that follows the pattern of adding the two previous numbers. For example, we can start with 0 and 1, and then use the formula =A1+A2 to get the next number in the sequence. Then, we can use the fill handle to copy the formula down and extend the sequence as far as we want. It's that simple!

This is a great example of how Excel can make complex calculations and patterns easy to create and understand. In fact, it's a common exercise in classrooms to have students create a Fibonacci sequence in Excel to demonstrate the power and simplicity of the program. So thank you, John, for sending in this question and thank you for tuning in to another episode of MBExcel netcast. Don't forget to hit that subscribe button and we'll see you next time for more Excel tips and tricks from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


John from New York asks if Excel can be used to create the Fibonacci sequence. Episode 645 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Table of Contents:
(00:00) Introduction to Fibonacci sequence in Excel
(00:15) Explanation of Fibonacci sequence
(00:25) Basic rule for creating the sequence
(00:35) Entering the formula in Excel
(00:49) Using the fill handle to extend the sequence
(01:03) Benefits of using Excel for Fibonacci sequence
(01:16) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Classroom activity: Creating Fibonacci sequence in Excel
Copying formula for Fibonacci sequence in Excel
Creating Fibonacci sequence with Excel formula
Easy way to create Fibonacci sequence in Excel
Excel Fibonacci sequence
Excel fill handle for Fibonacci sequence
Excel netcast: Creating Fibonacci sequence
Extending Fibonacci sequence in Excel
Fibonacci sequence tutorial Excel
Formula for Fibonacci sequence in Excel
How to create Fibonacci sequence in Excel
MrExcel netcast: Fibonacci sequence tutorial


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152285/

More from this channel