Did A Google Earth Mistake Cause A Couple's Brutal Murder?
Tumblr 101: Tips And Tricks To Get Started
Google Spreadsheets gains filtering, one more reason not to use Excel
Filtering allows you to instantly deep dive into both large or small amounts of data in ways which would take hours if done manually. Google's added pretty comprehensive filtering that mimics what's available in Excel. You can filter by row or column, by multiple keywords, or partial search terms, all indicated on the spreadsheet by green highlights. Add this to the existing sorting function of Spreadsheets and you've got yet another reason to use the light cloud-based Google Docs over the juggernaut that is Microsoft Office.
Comments
8
Subscribe to commentsbkj216Mar 24th 2011 8:16AM
When it comes to maintaining lists and minor calculations I go with Google Docs every time. However, its just not powerful enough to replace Excel when it comes to the really complicated stuff.
Its still much easier, friendlier, and a joy to use overall tho.
WM2Android2WP7Mar 24th 2011 9:46AM
That's not a reason to use this over Excel
DustinMar 24th 2011 10:17AM
Until Google docs has programmability like Excel it will never replace it for a power user. I can't count how many times I have used Visual Basic in Excel. It simply can't be beat....yet.
Adrian MeliMar 24th 2011 5:43PM
@Dustin Agreed. I think Google was innovative in trying to break the Microsoft stronghold but as of right now their spreadsheet functionality is not good enough for most major tasks. I am curious to see if Google loses any traction it has already gotten once a lower priced consumer version of Excel in the cloud is released...
Jeff HesserMar 24th 2011 10:56AM
I think googleDocs get a bit of extra praise from bloggers across the board due to the nature of their business/work flow. in a standard enterprise world the apps don't bring much to the table. Even really small businesses probably could find use for Google Docs but I can't ever see myself getting too comfy with them. Glad to see they are pushing forward and providing some competition though.
Samuel GibbsMar 24th 2011 10:59AM
@Jeff Hesser Agreed, for blogging they're just about perfect, because most of what we do is in the cloud anyway, it makes sense to have just another tab for a document open. But I also agree that they're no where near there yet for anything more advanced. I can't, for instance, use them for data analysis as they just don't have the formula and macro support I need to do it. I mean if I really had to I could resort to doing it by hand, but hell would have to freeze over for that to happen.
DeanoMar 24th 2011 12:08PM
For very simple tasks I commend the use of Google docs. But for deadline-orientated work, crunching lots of numbers and using more than just @sum? Excel all the way. It's my favourite program in all the time I've been computing.
xxdesmusMar 24th 2011 4:45PM
Comparing Google Spreadsheets to Excel 2010 is laughable. Stop kidding yourself. They aren't even remotely even. I use Excel every day, and you can't do half of the same things on Google Spreadsheets. It's a decent viewer (for basic spreadsheets) and that's about it.