Results 1 to 13 of 13
  1. #1
    iNET Interactive
    Join Date
    Jan 2011
    Location
    Seattle, WA
    Posts
    738
    Thanks
    11
    Thanked 72 Times in 57 Posts

    Going Google (apps) Part 3: Share/collaborate




    TOP STORY

    Going Google (apps) Part 3: Share/collaborate


    By Woody Leonhard

    If you've ever tried to share documents or struggled with merging edits from multiple collaborators, Google's productivity apps make the process easy.

    Here's how to share and collaborate with Google Docs, Sheets, and Slides — three apps that are both capable and free.

    The full text of this column is posted at windowssecrets.com/top-story/going-google-apps-part-3-sharecollaborate/ (paid content, opens in a new window/tab).

    Columnists typically cannot reply to comments here, but do incorporate the best tips into future columns.
    Last edited by Tracey Capen; 2013-05-08 at 18:48.

  2. #2
    New Lounger
    Join Date
    Mar 2010
    Location
    Switzerland
    Posts
    16
    Thanks
    1
    Thanked 1 Time in 1 Post
    I'd like to see WS (and the online world) change how they describe software and online products. "Paid" (licensed) vs. "free" is no longer a valid split, and increasingly is a lie. Today there is "open source" that is open in so many ways (and can also be profitable), then there is "free" in the original sense that the user gives, donates, sacrifices, etc absolutely nothing known or hidden, and then there is the bulk of software, including most of the brilliant software that Google delivers and which has admittedly changed my life for the better. For lack of a better term (and arguably imagination I'll call this last category "fee-based" software. Whether the user gives money for a license, accepts ads and tracking of personal behavior, agrees to test another product, first buys some hardware or whatever, this category is decidedly not free.


    I don't love or loath any category in particular, but I hate and take great offense to misrepresentation and the intense and intentional lack of transparency and honesty in the current software environment.


    Google makes more money in a year than recently existed in the entire world by collecting and selling everything ever known or thought about everything in the known or imagined universe. Apple litters every device and polutes all iOS bandwidth with ads and tracking via so-called "free" apps. This I don't like, the lack of honesty, despite how much I love and depend on the products.

    Tech journalists have a great responsibility to bring greater transparency to the current state.
    And for that, I depend on you
    GG

  3. #3
    New Lounger
    Join Date
    Jul 2010
    Location
    Dublin, Ireland
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The inline file sharing capabilities of Google docs is fantastic. Great that you are alerting your readers to it's strength. Wonder if you have reviewed IBM's offering in this area via their Connections product as the file editing capability has multi-person edit capabilities also.

  4. #4
    New Lounger
    Join Date
    Dec 2009
    Location
    Christchurch, NZ
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Woody, you say that "No, there are no pivot tables in Google Sheets". In fact, Google sheets do have pivot tables. Their functionality is limited, compared to Excel, but they're easy to use and very useful. I use them all the time.

    I would also comment that in my experience it's important to either stick with Office or move completely to Google. Mixing the two is a recipe for disaster - misformatted documents and spreadsheets, comments confused and all over the place. Moving documents from Google to Office and back (or vice versa) is not a trivial exercise. I think it's worth mentioning that to anyone who is considering making the switch - don't dip your toe in, jump in the deep end (with appropriate backup strategies if it doesn't work out...)

  5. #5
    Banned Member
    Join Date
    Apr 2013
    Location
    Miami Beach
    Posts
    46
    Thanks
    1
    Thanked 1 Time in 1 Post
    Here's a short video on pivot tables in Google Sheets

    Quote Originally Posted by rjh4242 View Post
    Woody, you say that "No, there are no pivot tables in Google Sheets". In fact, Google sheets do have pivot tables. Their functionality is limited, compared to Excel, but they're easy to use and very useful. I use them all the time.

    I would also comment that in my experience it's important to either stick with Office or move completely to Google. Mixing the two is a recipe for disaster - misformatted documents and spreadsheets, comments confused and all over the place. Moving documents from Google to Office and back (or vice versa) is not a trivial exercise. I think it's worth mentioning that to anyone who is considering making the switch - don't dip your toe in, jump in the deep end (with appropriate backup strategies if it doesn't work out...)

  6. The Following User Says Thank You to Google Apps Expert For This Useful Post:

    bobprimak (2013-05-10)

  7. #6
    New Lounger
    Join Date
    Dec 2009
    Location
    Salt Lake City, Utah, USA
    Posts
    3
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Using Google Docs may be wonderful for some things (multiple editors, rapid response to edits, etc) but if you are working with a report that includes figures, tables, and pictures, it is very difficult to use compared to Word. Although Word isn't as friendly as WordPerfect in this regard either. And since it's difficult to use Word for some things and Google Docs for others, you are still better off using just Word; even though it is going to be more expensive in terms of $$$$. It's still less expensive in terms of time.

  8. #7
    Lounge VIP bobprimak's Avatar
    Join Date
    Feb 2009
    Location
    Hinsdale, IL, USA
    Posts
    2,329
    Thanks
    140
    Thanked 117 Times in 100 Posts
    Quote Originally Posted by GentleBen View Post
    Using Google Docs may be wonderful for some things (multiple editors, rapid response to edits, etc) but if you are working with a report that includes figures, tables, and pictures, it is very difficult to use compared to Word. Although Word isn't as friendly as WordPerfect in this regard either. And since it's difficult to use Word for some things and Google Docs for others, you are still better off using just Word; even though it is going to be more expensive in terms of $$$$. It's still less expensive in terms of time.
    I think Woody covered this issue in his columns pretty thoroughly.


    For many Office users, some missing features will make using Google’s productivity apps a nonstarter. For example: Yes, Google Docs does not have anything like MS Word’s Document Map. No, there are no pivot tables in Google Sheets and cell data does not automatically flow into an adjacent empty cell. True, you can’t go back and retrieve an email you deleted three years ago. If Google apps don’t provide some feature you can’t live without, that’s cool. Stick with Office.
    Even with Pivot Tables now available in Google Apps, there are format and compatibility issues which I doubt that even our resident Google Apps Expert can fully resolve.

    By the way, one of the complaints about GMail is precisely how DIFFICULT it is to absolutely, completely, forever delete ANYTHING. Mail "deleted" often shows up as only being "Archived" -- often much more than three years after it was "deleted". A second "delete" operation is often needed to really make a Message or Conversation disappear -- and Google still retains their own copies for up to two years, according to their own Privacy Policy.
    Last edited by bobprimak; 2013-05-10 at 16:59.
    -- Bob Primak --

  9. #8
    Banned Member
    Join Date
    Apr 2013
    Location
    Miami Beach
    Posts
    46
    Thanks
    1
    Thanked 1 Time in 1 Post
    Bob,

    Gmail's Trash, just like inbox, spam, sent, etc are just "views" created with labels.
    When you Trash a message you are attaching the Trash label, which is a special label that overrides all the other labels. Messages in Trash retain any other labels, so that when, as and if you restore them, they will again be visible in the other label "views".

    Gmail's Trash is similar to Windows Recycle Bin in some ways. The messages stay there until they are actually deleted. You may go to Trash and delete messages manually. Messages in Trash older than 30 days are deleted automatically. The consumer edition of Gmail includes an archive of about 10 GB and the Business edition includes an archive of about 25 GB, so you may not need to spend much time deleting messages. To find messages larger than 10 MB, just search for: larger:10m

    Quote Originally Posted by bobprimak View Post
    I think Woody covered this issue in his columns pretty thoroughly.




    Even with Pivot Tables now available in Google Apps, there are format and compatibility issues which I doubt that even our resident Google Apps Expert can fully resolve.

    By the way, one of the complaints about GMail is precisely how DIFFICULT it is to absolutely, completely, forever delete ANYTHING. Mail "deleted" often shows up as only being "Archived" -- often much more than three years after it was "deleted". A second "delete" operation is often needed to really make a Message or Conversation disappear -- and Google still retains their own copies for up to two years, according to their own Privacy Policy.
    Last edited by Google Apps Expert; 2013-05-10 at 20:26.

  10. #9
    Lounge VIP bobprimak's Avatar
    Join Date
    Feb 2009
    Location
    Hinsdale, IL, USA
    Posts
    2,329
    Thanks
    140
    Thanked 117 Times in 100 Posts
    Quote Originally Posted by Google Apps Expert View Post
    Bob,

    Gmail's Trash, just like inbox, spam, sent, etc are just "views" created with labels.
    When you Trash a message you are attaching the Trash label, which is a special label that overrides all the other labels. Messages in Trash retain any other labels, so that when, as and if you restore them, they will again be visible in the other label "views".

    Gmail's Trash is similar to Windows Recycle Bin in some ways. The messages stay there until they are actually deleted. You may go to Trash and delete messages manually. Messages in Trash older than 30 days are deleted automatically. The consumer edition of Gmail includes an archive of about 10 GB and the Business edition includes an archive of about 25 GB, so you may not need to spend much time deleting messages. To find messages larger than 10 MB, just search for: larger:10m
    And this makes GMail easier to use -- HOW???

    I also note you conveniently did not answer the complaint about Google retaining copies of all email for up to two years. Still an issue for a lot of folks!
    -- Bob Primak --

  11. #10
    Star Lounger
    Join Date
    Feb 2010
    Location
    London
    Posts
    68
    Thanks
    0
    Thanked 4 Times in 4 Posts
    The newsletter and website are called Windows Secrets, not Google Secrets. Has Woody been paid to go into bat for Google? In my opinion, Google is a bad company that doesn't obey the rules it sets for other websites and lives off the efforts off others without paying much in the way of tax and invades personal privacy to an utterly unacceptable degree in order to offer customised ads, so I don't buy or use anything associated with it. Google has joined the list of companies facing criticism over tax avoidance in the UK after public accounts showed it paid only £600,000 in UK corporation tax despite local revenues of more than £1.25bn. It stashes its income away in tax havens.
    Last edited by Medico; 2013-05-13 at 04:54.

  12. #11
    New Lounger
    Join Date
    Apr 2013
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    You might want to practice this a bit before working on important documents. Play around with dueling edits — see whose edits, typed in simultaneously, take precedence over another's. In general, it's easy to stay on top of the changes — in real time on your netbook, MacBook Air, iPhone, Galaxy Tab, or other Web-connected device.
    I'm rather curious, why the omission of MS surface tablets? Doesn't Google Apps work with surface?

  13. #12
    New Lounger
    Join Date
    May 2013
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Woody,
    As you going to talk about outlook as an email backup in your next column, I would highly recommend the free [for non-commercial use] MailStore Home currently on version 8. It can be found at http://www.mailstore.com/en/mailstore-home.aspx. it will archive and index multiple email accounts. I have used it for a couple of years to backup 5 different email addresses, including one that can no longer receive email as the domain does not exist. I highly recommend this program for maintaining an offline copy of your email accounts.
    Rick

  14. #13
    Lounge VIP bobprimak's Avatar
    Join Date
    Feb 2009
    Location
    Hinsdale, IL, USA
    Posts
    2,329
    Thanks
    140
    Thanked 117 Times in 100 Posts
    Quote Originally Posted by 2noob2bTrue View Post
    I'm rather curious, why the omission of MS surface tablets? Doesn't Google Apps work with surface?
    Yes and no. It doesn't work the same way in an ARM environment as in a x86 environment, and it doesn't look the same. Some of the Google Apps (like GMail and Google Drive) aren't supported in Windows RT. The Chrome Browser isn't supported in Windows RT either. It is not available as a Metro App.

    http://blogs.cio.com/windows-8/17996...youre-out-luck
    Last edited by bobprimak; 2013-05-16 at 18:04.
    -- Bob Primak --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •