Anything Excel can do, I can do ...differently

This page has 0 threads | Add post

7,359 reviews

Blogs

Finding our blogs useful? Please consider helping us to share more!

Google Sheets: 5 reasons you should be using them Part two of a five-part series of blogs
This blog lists 5 reasons why you might like to consider using Google Sheets (perhaps as an alternative to Excel?). Free cloud based version of Excel, yes please! Anything Excel can do, I can do ...differently (this blog) Automation with Google Scripts (VBA) No account needed for collaboration Familiar formulae (you are already a pro!) Google Sheets is an online spreadsheet application. In this blog we show 5 reasons you should give it a try.

Google Sheets: 5 reasons you should be using them

Part two of a five-part series of blogs

This blog lists 5 reasons why you might like to consider using Google Sheets (perhaps as an alternative to Excel?).

Free cloud based version of Excel, yes please!
Anything Excel can do, I can do ...differently (this blog)
Automation with Google Scripts (VBA)
No account needed for collaboration
Familiar formulae (you are already a pro!)

Google Sheets is an online spreadsheet application. In this blog we show 5 reasons you should give it a try.

Posted by Sam Lowrie on 21 July 2023

Excel can create tables and spreadsheets; Google Sheets can too.

Can you spot which application is which?

The major visual difference in Google Sheets is the lack of the Ribbon. In Google Sheets this is replaced with a series of menus.

Most of the standard Data transforms are available

You can find all the main data transformations in the Data menu.

Replicating your Excel formatting in Google Sheets is fairly straightforward. You can set up custom themes, apply conditional formatting and apply styles in a few clicks.

Format pain has the most important features

Unfortunately the Format Painter can't be used to copy formatting from Excel to Sheets.

Options to control things like scrollable headers, hidden gridlines and data groups are all in sensibly named menus.

None of these settings are duplicated between menus, which makes Google Sheets feels less cluttered!

Finally, the toolbox has everything you need in one place for editing your sheet. All the icons you are familiar with are always on screen within easy reach.

The only ones missing are the ones you never clicked in Excel anyway.

Parts of this blog
Free cloud based version of Excel, yes please! Anything Excel can do, I can do ...differently (this blog) Automation with Google Scripts (VBA) No account needed for collaboration Familiar formulae (you are already a pro!)