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 3 - Cell References

by David Wang

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

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

Full size Buy lesson Buy lesson

(only $0.99)

You Might Also Like

About this Lesson

  • Type: Video Tutorial
  • Length: 11:53
  • Media: Video/mp4
  • Posted: 03/23/2009
  • Use: Watch Online & Download
  • Download: MP4
  • Size: 15 MB

This lesson in Microsoft Excel teaches you the concept and usage of absolute and relative cell references within formulas to analyze your data. a cell is the intersection of a column, noted by a letter, and a row, noted by a number. The cell reference is the combination of the letter and number. For example, the first cell in a spreadsheet is A1. When you create your own formulas, you usually need to reference cells within the spreadsheet. A relative cell reference will adjust the formula by changing the cells referenced as you drag to copy. An absolute formula will maintain a reference to a certain row, column, or cell as you drag to copy the formula.

This is part 3 of Learn Excel Basics. View other Excel lessons:
Intro to Excel: http://www.mindbites.com/lessons/1964
Learn Excel Basics, Part 1 - Data Entry: http://www.mindbites.com/lessons/1965
Learn Excel Basics, Part 2 - Formulas: http://www.mindbites.com/lessons/1963
For the full Excel course and more, please visit Knowledgeocity.com

About this Author

David Wang
David Wang
25 lessons
Joined:
03/05/2009

Knowledgeocity 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: www.Knowledgeocity.com

More..

Recent Reviews

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

Recent Comments

Be the first to comment on this lesson!
This lesson has not been reviewed.
Please purchase the lesson to review.
Be the first to comment on this lesson!

Buy Now and Start Learning

Buy this lesson to watch it immediately. View it as many times as you need and download it to your computer or iPod (most lessons). Satisfaction's guaranteed, so go get started!

Associates Program Monthly Plan

CommunityMore

Painting with Acrylics: Layering Te...
Nancypainter
Nancypainter says
I am taking a class from Polly right now, and this lesson is a great way for me to unde...
Trigonometry: Trig Function Composi...
ht1979
ht1979 says
great explanation of trig function composition and inverse trig functions.
Flower painting 1-Water Color Pencils
MRS
MRS says
Excellent, easy to follow instruction.
I want to learn how to build a slid...
lucas
lucas says
I want to learn how to build a slideboard
compound subjects and predicates
chiconem
chiconem says
compound subjects and predicates
I want to learn Trigonometry
Sandria
Sandria says
I want to learn Trigonometry
Embed this video on your site

Copy and paste the following snippet: