SITEMAP ABOUT
MiC Quality

FREE COURSE Excel Primer

  PROCESS IMPROVEMENT AND SIX SIGMA
ONLINE COURSES FREE TRIAL SIX SIGMA FAQ BROCHURES LICENSES ENROLL
FREE TRIAL
:: Online Courses
:: Free Trial
>> Statistics Module
>> Excel Primer
:: Six Sigma
:: FAQ
:: Brochures
:: Licenses
:: Discounts
 
Welcome to MiC Quality
Online Course Instructor
Glen Netherwood
MiC Quality
Online Learning
:: Home :: FREE TRIAL :: CURRENT STUDENTS LOGIN
:: The Basics Syllabus    PreviousNext


In Excel the data are contained in ‘cells’ that are referenced using a grid numbering system similar to that used on maps.

You select a cell by clicking on it. Cell ‘D5’ is selected in the illustration below. It contains the value ‘8’. The formula bar shows the formula that led to that value, it is the addition of the contents of cells ‘C3’ and ‘D3’:

5 + 3 = 8

If you change the values in any of the source cells ('C3' or 'D3') then the value in 'D5' will automatically update:

If you play the movie it will show you how to create the formula, and what happens when you change the value in cell 'C3'.

After studying the movie, try it for yourself in Excel. A spreadsheet with the completed exercise is here.

Click the Button to Play >

The power of Excel lies in this. You set up the 'model'. If you subsequently change any 'input' data values then all the formulae that use those values are automatically updated. There can be as many links as you wish in the 'chain' of formulae.


What value will be in cell 'D8'?

 

Roll your mouse over the image to check the answer.

 


 
Copyright 1998-2014 MiC Quality Legal Notices and Privacy Policy