Microsoft Excel Tutorial for Beginners #13 - Updating Calculations

Visit MotionTraining at http://www.motiontrainingweb.com
In this update to the beginners series you will learn how to update calculations linked to a table of data as new data is added to the table. The tutorial covers manual and automatic updating. The video is produced with Excel 2000 and is applicable to all versions of Excel up to XP (2003).

Category:

Howto & Style

Tags:

• Microsoft
• MS
• Excel
• Spreadsheet
• Help
• Guide
• Formula
• Calculation
• Update
• Updating
• Tutorial
• Computer
• technology

[Trux74]

Error at 3.21

[MotionTraining]

Could you explain what you saw? I have checked and can't find an error at 3:21.  Please let me know.

[Trux74]

@MotionTraining

Yeah no worries... You turn the Rental column Avereage, Min & Max into monetry values.

Prior to you draging the calculation across the values are counts.

No biggy but just looks strange after thats all.

Still great videos though... very helpfull

[MotionTraining]

Ah, OK. I didn't spot that one! Probably not worth correcting, but I'll mention it in the next video. Glad you found it useful anyway.

[ctsfiddler]

wow, I just purchased software that doesn't compare to your videos. I can't thank you enough for these.

[Surakon58]

Thank you for the update

[chandraprajesh]

there is a small error at the end when u insert the title star wars the conditional formatting doesn't change the highlight to star wars as it became the highest income...thanks for ur help otherwise the whole series is perfect..

[ovaistauheed]

may i know where to download cursor u r using like it,urgent

[818607]

Ive been looking around in your tutorials, and I keep getting a circular reference errror.. Im trying to make a spread sheet where I can keep track of patients and cost at the same time. Can I make eg. B2 worth 90$ .. so when I put in 3, it will just multiply the number to 270.00 without me whipping out a calculator.. I keep getting errors when putting in function into B2. eg. B2 = 90 or B2 *90 AND I try to do that for the entire B column. I dont know how to do it

[fastupuedes1]

Thank you for the time you spend in this program let me tell you that it's very useful I didn't know anything about it but now with your help I'm finally learning

[MrQuennette]

this video is very useful, even i didnt go to school. it help me a lot to have a knolegde on ms exel, thanks to tjis channel and his video tutorials,,

[princezz086]

wow.. this is helping me so much! thank u for ur effort! goodjob! ;)

[propnash]

hi, got a problem here, automatic row formating applies only when i do addition, but not for multiplication, please help me .... Nash