Microsoft Excel Tutorial for Beginners #13 – Updating Calculations
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).
March 26th, 2010 at 5:01 pm
This is so helpful. Brushing up for a “situational” computer test — phase two of a job interview. I’m a Mac user and can’t find “options” under “tools” in menu bar. (Using 2004).
March 26th, 2010 at 5:01 pm
thanks a lot man you have done realy good job
March 26th, 2010 at 5:01 pm
thank you so much for the a great tutorial…
March 26th, 2010 at 5:01 pm
Very impressed by these videos. I just watched and wrote down notes for all of them during my 8 hour work day. I had little to do at work and needed to brush up on my excel skills, which I had little of. Very, very helpful, nice and slow. Great job, thank you!
March 26th, 2010 at 5:01 pm
A rare find of something actually usefull on this website. Crazy. You know you should seriously narrate documentaries on wildlife or something.
March 26th, 2010 at 5:01 pm
Thank you i have learnt a lot from these brilliant lessens.
March 26th, 2010 at 5:01 pm
Thank you,its because of you few good men that this world still revolves for
March 26th, 2010 at 5:01 pm
These tutorials are extremely helpful!! Thank you so much!!
March 26th, 2010 at 5:01 pm
With your reminder to save frequently and use of ‘undo’ as well as the delete key I’m a Mac user following your videos with little need to pause and rewind – thank you again.
March 26th, 2010 at 5:01 pm
very good video
March 26th, 2010 at 5:01 pm
wow, I just purchased software that doesn’t compare to your videos. I can’t thank you enough for these.
March 26th, 2010 at 5:01 pm
wil we gonna C a next episode?! Alin, Europe.
March 26th, 2010 at 5:01 pm
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.
March 26th, 2010 at 5:01 pm
@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
March 26th, 2010 at 5:01 pm
Could you explain what you saw? I have checked and can’t find an error at 3:21. Please let me know.
March 26th, 2010 at 5:01 pm
?????!
March 26th, 2010 at 5:01 pm
May God bless you because you are such a blessing with your wonderful teaching!
March 26th, 2010 at 5:01 pm
Error at 3.21
March 26th, 2010 at 5:01 pm
Thank you. Now, I can actually say that I know how to use Excel. I have an interview tomorrow, and these tutorials helped me to refresh my memory and I have learned many new things. I can always refer back to this for future help. Thanks again, you know this was very appreciated.
March 26th, 2010 at 5:01 pm
Thanks, very good work and very well elaborated. I have learn so much from all these 13 tutorials.
March 26th, 2010 at 5:01 pm
i can’t thank you enough! i have more confident now than ever, i hope many people do the same thing you do,,,thank you so much!
March 26th, 2010 at 5:01 pm
Thank you so much for all these useful tutorials for excel..
March 26th, 2010 at 5:01 pm
Your tutorial is very educational. I have more confident and don’t want to be on the side line. Thanks and God bless.
March 26th, 2010 at 5:01 pm
Thank you so much motion training, for many years i have been avoiding excel for so reasons but after going through this tutorials I found out that I could understand it. God bless you..
March 26th, 2010 at 5:01 pm
Thank you very much for this tutorial. It was so helpful to learn basic excel. I have watched all 13 in one day and feel really confident to use excel. Excellent video.
Thank you very much again and have a wonderful weekend.
p.s. Do you have a tutorial for Word too?
Cheers