 | Extending Charts and Equations for Dynamic Data |  |
|
Added to Library on 12 Oct 2008
Length: 9 mins
View Tutorial Movie
Download File Used |
In this presentation we are going to look at how we can use dynamic data within graphs and equations in Excel. It is quite an ambitious tutorial and users techniques and functions that are covered in more details in the tutorials listed below. So if you get stuck then it is recommended that you watch the tutorial a couple of times and/or refresh your knowledge with the tutorials below.
The results are amazing and will ensure that when you put financial spreadsheets, or indeed any spreadsheets together you will ensure that they will continue to work no matter how much data you put in them. This is vital as it is often the case that spreadsheet stop working only once the person who put them together has left the company&
Enjoy and please let me have feedback on whether you found the tutorial useful.
|
|
Related Tutorials:
Introduction to Excel Offsetting
Introduction to Named Ranges
Mastering the Excel AutoFill Features
|
Feedback for this tutorial:
"Absolutely excellent and very useful for stock market graphs. You are doing wonderful job. I wish you a very great success!!"
"I work a lot with spreadsheets and graphs which have periodically added data and I solved having to update the graphs by using a progressing 5 year period. This allows me to make visible a much longer period without updating the graphs everytime."
"I had heard of dynamic names, but had not really grasped how the offset worked. Seeing it on the screen mad the whole difference. definitely a must use option!
Thanks!"
"After watching this I have a wonderful idea for a spreadsheet I've been using at work ! Thank you so much !"
"Wonderful tutorial. If possible, might consider adding a piece on plugging in a number or a scroll control to increase or decrease the duration of the months and also to control the starting point. These things are very important in many business functions. Thank you."
"Hi Clayton, this is a super utility, I can see loads of opportunities to expand on it :-) Have got my head rounf offset now after this tutorial :-) "
"Very helpful tutorial .... Thanks"
"Clayton
Very simple concepts but very powerful. I thought this tutorial was was worth viewing. Thanks, Michael"
"Very educative and wonderful to know how easy things can be worked if we know the proper methods to operate excel. I really liked it. I thank you for helping me to know more about excels and all the interesting formulaes."
"This is great for those of us struggling on our own to understand Excel. Keep it up, please!!!!!"
"Simply excellent!"
"Your videos are very informative however, they move at a very fast pace. Thanks for the downloads otherwise, I will not be able to try to practice them at a later time. I'm sure with practice, I will become as fast as you."
"That's nice for me. I'll use it to prepare dynamic graphs of macro economic datas of central bank every month. Also I will be able to use this on financial datas too. "
"Excellent tutorial. It is nice to see something a little more advanced.
Good job!"
"I have used named ranges for simple purposes in the past. This tutorial really showed the power of this feature. Thanks."
"Talk about timing, I was needing to do this very subject when your e-mail came in! I have to do weekly updates and this will save me many headaches. Thanks!"
"This tutorial is very useful to me, because i am a planner so i need so much how to analyse data as well as make a chart for them.
I hope that you remember me every time you have another movie.
Thank you very much.
Nhu Thao - Vietnam"
"Superb, Ultimate......Actually I am a Equity Research analyst in one of the Indian company...and especially this tutorial has made your big fan, I would request you to give some tips on Financial modelling with the help of Excel.....I am still not good in using financial formulaes in Excel.
Thanks
Hitesh"
|
|
|
| |
 | |  |
|
|
|
