Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

google docs

ResolvedVersion 2010

Ed has attended:
Excel Intermediate course
Excel Advanced course

Google docs

Which excel functionality links with google docs?

RE: Google docs

Hi Ed

Thank you for using the forum to ask a question.

There is a great deal of similarity between Google Sheets and Excel.

Most of the Formulas including Vlookup, Offset, Index and Match all work with Google Sheets.

You can expect a like for like experience.The key is Google Sheets is designed for real-time collaboration, Excel isn't, by default.

The only time you will see a difference is when you try to analysis very large data sets, complicated pivot tables and VBA Dashboards. This is best done in Excel only.

Kind regards

Richard Bailey
Microsoft Office Specialist Trainer

Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 26 May 2015: Automatically marked as resolved.

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.