hello I'm Dennis from Sheetgo and today I'm going to show you how to import
filtertered data from Excel to Google Sheets for this you need Sheetgo, so if you don't
have Sheetgo yet click on the link in the description. first we need to save
this document in the Google Drive for this I used drive for office if you haven't
installed this yet click on the link in the description this is very easy to
use because you just click on document save as and you click on the Google
Drive button you can click on save as and you can just type in the name of the
sheet how you want to call it so we call it a import filtered just press ok and
lt'ss now making a connection with Google Drive and it's done it's very easy to
use and so the first thing that we have to do to import filtertered data is to go to
an empty spreadsheet you start up sheet go and once this is done just go over
the green you mouse over the green plus button you have three options import
data export and use a template we are going to import you press connect
you select the spreadsheet that you want to share it to that you want to import
it from so just want the import Filtered data that we just saved you selected
then you go to edit bio filter by and you edit it you switch it on and you use
query language then you fill in the formula like then you fill in the
formula like this select where C is Kentucky or C is Washington or C is
Wyoming so if you press this in you press ok then you connect it
so it's now importing and once this is done you can see only the Washington
Wyoming and the Kentucky are in this sheet so now we imported fill the data
from Excel to Google sheets this is very easy to use and I hope you've learned
something if you have any questions leave them in the comments below this
video is based on a blog post so if you want to read more click on the link in
the description thank you for your time and if you like the video please put a
thump up have a good day bye
For more infomation >> Trump's 12 Cokes of Christmas, Elf on the Shelf Hits the ER - Monologue - Duration: 3:49. 
For more infomation >> Alabama's Special Election, Prince Harry Quits Smoking - Monologue - Duration: 3:00. 
For more infomation >> Anthony Anderson Had No Idea Who His Ferdinand Co-Stars Were - Duration: 3:35. 
For more infomation >> 12 Days of Christmas Sweaters 2017: Day 3 - Duration: 2:38. 
For more infomation >> Anthony Anderson Golfed With Michael Phelps, Chris Paul and President Obama - Duration: 4:46. 
For more infomation >> Tiendas de juegos en Amsterdam - Duration: 22:23. 
For more infomation >> Shitstorm für Pietro Lombardi: Jetzt wehrt er sich gegen seine Kritiker - Duration: 5:06. 
For more infomation >> தினமும் 3 முறைக்கு மேல் உடலுறவு வைக்கும் பெண்களுக்கு பின்புறம் பெரிதாகும் அதிர்ச்சி தகவல்கள் Tamil - Duration: 2:56. 
For more infomation >> Büssis Best of Bachelor - FINALE - Duration: 7:31. 
Không có nhận xét nào:
Đăng nhận xét