business.tutsplus.com: Spreadsheets are one of the best ways to log and organize data. Frequently, I use them to organize projects or take notes on something new I'm learning. It's easy to use a spreadsheet like a blank canvas, and then order the data into a structured format later.
3 comments:
First off, the video was very helpful, clear cut and recently made, which is always helpful for a tutorial video. I think the functions discussed in the video: linking sheets as well as workbooks is extremely helpful especially for long-term projects. I could definitely see myself implementing these formulas/connections for a system that has consistent changes to data. At a certain point I do start to wonder, why not just make a database? After you link a couple Sheets, it seems better just to establish a database where you have more control over data relationships. Besides the video, the article also included a few handy formulas that really caught my eye. The google specific formulas have amazing capabilities beyond what Excel can do, but it is hard to compete with a spreadsheet that has the power of a search engine behind it. However, it does begin to ask the question, how are you supposed to update data without wifi? Particularly for people who work on business while traveling. Additionally, the printed versions of Sheets still has no way to compete with Excel's formatting capabilities.
I thought this video was actually beneficial and pointed out some good features of google sheets. I personally really like the ability tot have multiple people working on a document at the same time, allowing others to see changes made in real time and the ability to see who made what change when should a problem arise. I do see some places where using Microsoft products would be easier: print formatting, using access, or for excel-only functions. The big plus to google, however, is that it is free and everyone can access it; which might make it worth the few inconveniences. I wasn't very familiar with the linking sheets feature of google sheets and I think that could be great way to accomplish more complex data manipulation if google sheets is already the default program being used and excel, for some reason, is not an option. Overall I found this video pretty informative and learned a good amount about the complex capabilities of google sheets.
I truly think that once the developers of google sheets add the ability to do something similar to Pivot Tables and Pivot Charts, the entire world will have no choice but to move from Excel. While it certainly has it's limitations, especially when working on slow internet connections or even no connection at all, but the interconnectivity and unique functions tha one is able to create and implement in a google sheet, espeically when integrating with google developer and cloud functions, far surpass the capabilities of excel beyond any of our wildest dreams. But even with all of these fancy features and functions, the fact of the matter is that Google sheets stands out, just like the other Drive applications, because of their multi-user capability. Office is trying to approximate some of the functionality of Drive with their One Drive product, but Google has another significant and perhaps game-breaking advantage: It's free.
Post a Comment