Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

I have to work on Google Excel Sheet sometimes (on Google Drive) and there are many differences from working with the normal Excel Sheet. Functions, Format, many features are not the same. I would appreciate any information about using Google Excel Sheet with more sufficient way?

user-image
Question added by Mahmoud Hamid , Finance Manager , Experts
Date Posted: 2016/03/26
Jazir Thahir
by Jazir Thahir , Executive Secretary , Al Farida Beauty Intl Co. (PUIG)

My Suggestion for you is to prepare the document using Microsoft excel then upload it to google drive and use the google sheet only to view the file. 

 

I don't prefer google sheet for regular use.

حسين محمد ياسين
by حسين محمد ياسين , Finance Manager , مؤسسة عبد الماجد محمد العمر للمقاولات العامة

agree with answers .........................................

Ahmed Mohamed Ayesh Sarkhi
by Ahmed Mohamed Ayesh Sarkhi , Shared Services Supervisor , Saudi Musheera Co. Ltd.

agree with great answer given by ms. ghada

 

Thanks for the invite, I apologize for the answer, I leave the answer to the specialists.

Mohammad Iqbal Abubaker
by Mohammad Iqbal Abubaker , Jahaca Pty Ltd - Accounts Administrator , Jahaca Pty Ltd - Accounts Administrator

 I AGREE WITH THE ANSWER GIVEN BY Ghada Eweda   Medical sales hospital representative AND ALL THE TEAM MEMBERS.

Ghada Eweda
by Ghada Eweda , Medical sales hospital representative , Pfizer pharmaceutical Plc.

In moving from Excel to Google Spreadsheets, some may find the need to work with data or ranges from one spreadsheet in another spreadsheet by using formulas and not manually copying the data into multiple sheets, sometimes this is called linking Google spreadsheets.

Google does provide a solution to this via the ImportRange function, however there is still more to learn and know about this function, and it is best to start with the help from Google.(https://support.google.com/drive/table/25273?page=table.cs&rd=3)

Now that you have probably read the Google support notes on the ImportRange function, here are some tips and notes via examples on how it works:

(please note the spreadsheet links are not valid, and only for illustration purposes)Spreadsheet1 – https://docs.google.com/spreadsheet/ccc?key=0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E#gid=0There are two sheets named Sheet1 and Sheet2

Spreadsheet2 – https://docs.google.com/spreadsheet/ccc?key=0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc#gid=0There are two sheets named SALES and EXPENSESThere are named ranges called SALES_SUMMARY, MONTHLY_SALES

TIP: The name of the sheet and named/protected range within the file is NOT case-sensitive

Using a new spreadsheet of your own creation, I will try to give you some good examples of how to pull data from another Google Spreadsheet.Examples of getting data from file Spreadsheet1, sheet named Sheet1=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”A1″)=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”A1:D1″)=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”sheet1!A1:B1″)

Examples of getting data from file Spreadsheet1, sheet named Sheet2NOTE: If you are not accessing the FIRST sheet created, you must specify the sheet name!=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”sheet2!A1″)=ImportRange(“0Ak__Spreadsheet1__ZoUzRhNFBIaGo2WXk3eFZPU1E”,”sheet2!A1:D1″)

Examples of getting data from file Spreadsheet2, sheet named SALES=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”A5:F5″)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”sales!A5:F5″)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”SALES!A6″)

Examples of getting data from file Spreadsheet2, sheet named EXPENSES=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”expenses!A5:F5″)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”Expenses!A5:F5″)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”EXPENSES!A6″)

Examples of getting data from file Spreadsheet2, named range SALES_SUMMARY=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”SALES_SUMMARY”)=ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”Sales_Summary”)

Examples of getting data from file Spreadsheet2, named range MONTHLY_SALESNOTE: You can use the ImportRange Function inside of some functions, but not VLOOKUPTo use VLOOKUP, you must basically pull that data into the same file (optionally in a new sheet), then do a VLOOKUP against the current sheet.=SUM(ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”MONTHLY_SUMMARY”))=3*MIN(ImportRange(“0Ak__Spreadsheet2__XaBC1LaDdSd1EzblQ1N3BBcWc”,”MONTHLY_SUMMARY”))

NOTE: The “auto” update of data between spreadsheets when using the ImportRange function seems to be between a few seconds and about two minutes.

I hope this helps you get more use out of your Google Spreadsheets!

abdul khayyum bashir ahmed
by abdul khayyum bashir ahmed , Human Resources Administrator , Al Diwan Al Amiri

Checkout this website hope u will get some idea.... http://www.gcflearnfree.org/googlespreadsheets

Abu Bakar Ashfaq
by Abu Bakar Ashfaq , Senior Consultant , PricewaterhouseCoopers Middle East

No idea of it. Thanks for invitation

Nasir Munir
by Nasir Munir , typist , Data Entry

I have to work on Google Excel Sheet sometimes (on Google Drive) and there are many differences from working with the normal Excel Sheet. Functions, Format, many features are not the same. I would appreciate any information about using Google Excel Sheet with more sufficient way

More Questions Like This