Notice:  As of December 14, 2016, the MindBites Website and Service will cease its operations.  Further information can be found here.  

Hi! We show you're using Internet Explorer 6. Unfortunately, IE6 is an older browser and everything at MindBites may not work for you. We recommend upgrading (for free) to the latest version of Internet Explorer from Microsoft or Firefox from Mozilla.
Click here to read more about IE6 and why it makes sense to upgrade.

Learn Excel Basics, Part 2 - Create Formulas

Screencast HD Screencasts now available in their original high resolution. Click here to view this video in a new window at actual size!

Like what you see? false to watch it online or download.

You Might Also Like

About this Lesson

  • Type: Video Tutorial
  • Length: 11:05
  • Media: Video/mp4
  • Use: Watch Online & Download
  • Access Period: Unrestricted
  • Download: MP4
  • Size: 70 MB
  • Posted: 03/23/2009

This lesson teaches you how to create useful formulas in Microsoft Excel that will let you easily change and calculate data for analysis. The power of formulas is that they automatically adjust if a change is made in one of the cells to which the formula refers. Learn the Sum formula, and a quick shortcut located in the toolbar, the Autosum. Also, learn that the result of the formula appears in the cell, but that you can view and change the actual formula in the formula bar. You will also learn how to easily copy the formula to adjacent cells using the fill handle.

This is part 2 of Learn Excel Basics. View other Excel lessons:
Intro to Excel:
Learn Excel Basics, Part 1 - Data Entry:
Learn Excel Basics, Part 3 - Cell References
For the entire course in Excel and more, please visit

About this Author

David Wang
David Wang
25 lessons

Knowledgecity offers convenient and affordable online video training in a wide variety of categories and topics from business skills, computer software, finance, to lifestyle and many more. All courses are taught by university professors and certified industry experts to ensure the highest quality training videos. We offer ALL YOU CAN LEARN unlimited access to ALL training courses to fit anyone’s schedule and budget.

Check out our new website at:


Recent Reviews

This lesson has not been reviewed.
Please purchase the lesson to review.
This lesson has not been reviewed.
Please purchase the lesson to review.

Embed this video on your site

Copy and paste the following snippet: