Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Data Analysis Spreadsheet Basics Getting Started With Spreadsheets Adding Data to A Spreadsheet

Posted by Gabriel Kantor
Gabriel Kantor
1,098 Points

Is there a source I can learn about auto updates from?

A link would be helpful.

Alexander Davison
Alexander Davison
65,469 Points

Congrats on the first Data Analysis question :laughing:

3 Answers

Steven Parker
Steven Parker
231,261 Points
Steven Parker
Steven Parker
231,261 Points

If you mean calculations, you can go to File :arrow_right: Spreadsheet settings... :arrow_right: Calculation tab and then in the "Recalculation" drop-down box and choose one of the settings that includes an interval.

If you mean updates of a reference to an external sheet, I found this blog post and this other one that may be helpful.

Michael Watson
STAFF
Michael Watson
Treehouse Teacher
Michael Watson
Michael Watson
Treehouse Teacher

Hi Gabriel Kantor, what specifically on the auto updating subject would you like to learn more about? Maybe something I can teach in another course...

Parker Brown
Parker Brown
24,308 Points
Parker Brown
Parker Brown
24,308 Points

Possibly walking through an example of an auto-updated spreadsheet you encountered or developed during your fina. investment days. Would be an interesting workshop possibly.

Michael Watson
Michael Watson
Treehouse Teacher
Michael Watson
Michael Watson
Treehouse Teacher

Thanks for the suggestion Parker. I'll keep that in mind as we build out the roadmap.

Alex Franklin
Alex Franklin
12,403 Points
Alex Franklin
Alex Franklin
12,403 Points

HELLO!

I understand I'm late to this thread, but I also would like to see material covering the use of writing data to a spreadsheet from a web page, reading data from the spreadsheet, editing existing spreadsheet data, deleting data, etc...

This is what I, and most other users I expect, were hoping to learn here. There are hundreds of Youtube videos that explain the basic functionality of spreadsheets. Google themselves have 5 minute quick start tutorial video explaining everything in this course. .

I love you guys, but please update with some more in depth courses on this topic.