- 57
- 214 840
Tech Tricks with Eli
Netherlands
เข้าร่วมเมื่อ 5 ส.ค. 2023
Hello there! I'm Eli, your guide to navigating the exciting world of MS Office and G Suite. 🌟
With a passion for productivity and a love for all things tech, I'm here to bring you tutorials that demystify the ins and outs of these powerful tools. Whether you're a newbie looking to master the basics or a seasoned user aiming to uncover advanced features, you're in the right place.
With a passion for productivity and a love for all things tech, I'm here to bring you tutorials that demystify the ins and outs of these powerful tools. Whether you're a newbie looking to master the basics or a seasoned user aiming to uncover advanced features, you're in the right place.
Auto-Sync Data from Excel to Google Sheets
#google_sheets #excel #apps_scripts
Looking to streamline your data workflows? In this tutorial, we'll show you how to **auto-sync data from Excel to Google Sheets** effortlessly. Whether you're managing data across multiple platforms or seeking to automate manual updates, this step-by-step guide will help you integrate Excel and Google Sheets seamlessly.
Discover how to use Google Apps Script to create a real-time sync between your Excel files and Google Sheets without constant uploads or manual intervention. Perfect for businesses, students, and anyone who wants to simplify data management!
Stay tuned and learn how to save time and boost productivity by automating data synchronization. Don’t forget to like, share, and subscribe for more tech tips and tricks!
------------------------------------------------------------------------------------------------------
Timestamps
00:00 Intro
01:01 Prepare excel data
01:39 Upload excel to google drive
02:15 Prepare google sheets
02:45 Apps scripts coding
05:53 Wrap up
----------------------------------------------------------------------------------------------------
❤️ Link to the Sheet & Code❤️
🔗 sheetfacts.com/product/how-to-auto-sync-data-from-excel-to-google-sheets/
--------------------------------------------------------------------------------------------------------
❤️ Link to the Website❤️
sheetfacts.com/
---------------------------------------------------------------------------------------------------------
Subscribe link
youtube.com/@TechTrickswithEli2023
-------------------------------------------------------------------------------
Related Links and useful playlists
Google sheets playlist
th-cam.com/play/PL2RWe5phcvVbtatCxlxZ6K-QK1zH3Uebu.html&si=H2D2OPXqldLCQoCX
Google Forms playlist
th-cam.com/play/PL2RWe5phcvVbcER3ePAmkSbwpRtDPpRBf.html&si=26WOOvAMRn85NqQX
Looking to streamline your data workflows? In this tutorial, we'll show you how to **auto-sync data from Excel to Google Sheets** effortlessly. Whether you're managing data across multiple platforms or seeking to automate manual updates, this step-by-step guide will help you integrate Excel and Google Sheets seamlessly.
Discover how to use Google Apps Script to create a real-time sync between your Excel files and Google Sheets without constant uploads or manual intervention. Perfect for businesses, students, and anyone who wants to simplify data management!
Stay tuned and learn how to save time and boost productivity by automating data synchronization. Don’t forget to like, share, and subscribe for more tech tips and tricks!
------------------------------------------------------------------------------------------------------
Timestamps
00:00 Intro
01:01 Prepare excel data
01:39 Upload excel to google drive
02:15 Prepare google sheets
02:45 Apps scripts coding
05:53 Wrap up
----------------------------------------------------------------------------------------------------
❤️ Link to the Sheet & Code❤️
🔗 sheetfacts.com/product/how-to-auto-sync-data-from-excel-to-google-sheets/
--------------------------------------------------------------------------------------------------------
❤️ Link to the Website❤️
sheetfacts.com/
---------------------------------------------------------------------------------------------------------
Subscribe link
youtube.com/@TechTrickswithEli2023
-------------------------------------------------------------------------------
Related Links and useful playlists
Google sheets playlist
th-cam.com/play/PL2RWe5phcvVbtatCxlxZ6K-QK1zH3Uebu.html&si=H2D2OPXqldLCQoCX
Google Forms playlist
th-cam.com/play/PL2RWe5phcvVbcER3ePAmkSbwpRtDPpRBf.html&si=26WOOvAMRn85NqQX
มุมมอง: 84
วีดีโอ
Auto Refresh Google Sheets Every 1 minute (With Apps Script)
มุมมอง 422หลายเดือนก่อน
#Time-based_automation_Google_sheets Want your Google Sheets to stay up-to-date automatically without manual refreshes? This tutorial has you covered! In this video, I’ll show you how to set up an Auto Refresh feature in Google Sheets using Google Apps Script. You’ll learn step-by-step how to create a script that updates your spreadsheet every 1 minute, making it perfect for tracking dynamic da...
Multiple Dependent Drop-Down List in Google Sheets (Apps Script)
มุมมอง 349หลายเดือนก่อน
#multiple_dropdown_list #googlesheets In this tutorial, we’ll show you how to create multilevel dependent dropdown lists in Google Sheets using Google Apps Script! This method allows you to make your dropdown options dynamic, where the selection of one dropdown list controls the options available in the next. Perfect for organizing complex data or creating more interactive forms. Timestamps 00:...
5x Faster and Powerful Data Entry Form in Google Sheets (Save & Search in Multiple Sheets)
มุมมอง 7792 หลายเดือนก่อน
#google_sheets #data_entry_form #googlesheets Learn how to create a data entry form that allows you to save and search in multiple sheets. This tutorial will show you step-by-step how to streamline your data entry process and easily find information across different sheets. ❤️ Link to the sheet and code❤️ sheetfacts.com/product/data-entry-form-save-search/ Timestamps 00:00 Intro 01:03 Create a ...
5 Minute Image Resizing Hack for Busy Professionals!
มุมมอง 502 หลายเดือนก่อน
#MS_Word #resize_image #microsoft_word You may have a Microsoft word document with multiple images of various sizes. Now you can resize pictures one by one, or You need to resize them all at once. In this tutorial, you will learn several methods to resize images individually or all together. TimeStamps 00:00 Intro 00:26 Method 1 02:33 Method 2 03:46 Wrap up Code Sub ResizeImage() Dim x As Long ...
Make Google Docs read texts to you out loud!!
มุมมอง 1822 หลายเดือนก่อน
#Google_Docs Make Google Docs read texts to you out loud!! Do you know you can make Google Docs read texts to you out loud? Yes, you can! All you need is a useful and productive extension for your google chrome. ❤️ Link to the Website❤️ sheetfacts.com/ Subscribe link youtube.com/@TechTrickswithEli2023 Related Links and useful playlists Google sheets playlist th-cam.com/play/PL2RWe5phcvVbtatCxlx...
The Easy Way to Save Google Docs on Computer
มุมมอง 2273 หลายเดือนก่อน
#Google_Docs Learn the easy way to save Google Docs on your computer! Follow these simple steps to ensure your important documents are safely stored. In this tutorial, I will show you how to save your google docs document into your computer and work with that offline. You will learn two methods: 1) Save to your computer as Microsoft word directly from your Google Docs, 2) Save to your computer ...
PROTECT Your Google Sheets Data from Editing!
มุมมอง 2453 หลายเดือนก่อน
#googlesheets #ProtectGoogleSheets Google Sheets - Protect (Lock) Certain Cells, Ranges, Sheets, and Formulas from Editing In this tutorial, I will show you how to protect cells, ranges, and sheets. If you wanna share your spreadsheets with your friends or colleagues but you want nobody can change certain data, you should protect your google sheet from editing. In this video, I will show you ho...
How to create button to go to specific sheet in Google Sheet
มุมมอง 2.4K3 หลายเดือนก่อน
#GoogleSheets #ButtonLink How to create a button to go to a specific sheet in Google Sheet In this tutorial, I will show you how to create a clickable button in google sheets, that goes directly to a certain sheet. In this video, there are three steps, first, create a button, then write the script, and at the end assign the script with the button. If you need any kind of button, let me know in ...
Type Exponents Like a PRO in Google Docs in under 5 Minutes
มุมมอง 1963 หลายเดือนก่อน
#google_docs How to Type Exponent in Google Docs. In this tutorial, I will show you three methods to add exponent in your document in google docs. You will learn different useful shortcut keys and easy ways to have power in your document. ⏰Timestamps 00:00 Intro 00:15 Method one (Superscript feature) 00:50 Method 2 (Shortcut key) 01:43 Method 3 (Equation) 02:20 Wrap up ❤️ Link to the Website❤️ ...
How to set print area in google sheets
มุมมอง 4864 หลายเดือนก่อน
#Google_sheets How to set print area in google sheets! In this tutorial, I will help you to learn how to set the print area in google sheets. When it comes time to print a spreadsheet, setting the print area is an essential part of the process of getting the necessary information on paper. In Google Sheets, you can set the print area to print everything in the workbook, the current sheet, or se...
Generate Unique IDs in Google Sheets LIKE A PRO! (Acronym)
มุมมอง 9505 หลายเดือนก่อน
#Google_sheets In this tutorial, I will show you how to create a formula for generating a unique ID that contains acronyms. In this video, you learn to create an ID that is unique for your data and extract useful info from that. Formula👇 =TEXTJOIN("-",True,IF(LEN(B2)-LEN(SUBSTITUTE(B2," ",""))=0,LEFT(B2,1),IF(LEN(B2)-LEN(SUBSTITUTE(B2," ",""))=1,LEFT(B2,1)&MID(B2,FIND(" ",B2) 1,1),LEFT(B2,1)&MI...
Create a Reservation System in Google Sheets (Apps script version)
มุมมอง 1.5K5 หลายเดือนก่อน
#google_sheets #googlesheetstutorial #appsscript Welcome to your channel! In this tutorial, I will guide you step-by-step on how to create a fully functional reservation system using Google Sheets and Google Apps Script. Whether you need to manage bookings for a hotel, restaurant, event, or any other reservation-based service, this tutorial will provide you with all the tools you need. In this ...
Stock Inventory Management System in Google Sheets
มุมมอง 4186 หลายเดือนก่อน
#google_sheets #inventorymanagementsystem Stock Inventory Management System in Google Sheets In this tutorial, I will show you how to create an inventory management list in Google Sheets. You will learn how to create a simple inventory list that you can filter columns, create reorder alerts, remove products that you don't want to reorder, automatically calculate "inventory value", total invento...
How to Use the Google Sheets Mobile App Like a Pro
มุมมอง 4076 หลายเดือนก่อน
#GoogleSheets #MobileApp Welcome to [Your Channel Name]! In this tutorial, I'll show you how to effectively use the Google Sheets mobile app to manage your spreadsheets on the go. Whether you're new to Google Sheets or looking to enhance your mobile experience, this video has got you covered! ❤️ Link to the Website❤️ sheetfacts.com/ Subscribe link youtube.com/@TechTrickswithEli2023 Related Link...
Build a Habit Tracker in Google Sheets!
มุมมอง 2286 หลายเดือนก่อน
Build a Habit Tracker in Google Sheets!
Mastering Page Breaks in Google Docs: The Ultimate Guide
มุมมอง 4427 หลายเดือนก่อน
Mastering Page Breaks in Google Docs: The Ultimate Guide
How to Create an Online Voting Form with Google Forms
มุมมอง 3K7 หลายเดือนก่อน
How to Create an Online Voting Form with Google Forms
Convert Google Slides to Video: 3 Easy Methods
มุมมอง 3118 หลายเดือนก่อน
Convert Google Slides to Video: 3 Easy Methods
How to create organizational chart in google sheets//Easy Method!
มุมมอง 2888 หลายเดือนก่อน
How to create organizational chart in google sheets//Easy Method!
The Quick and Easy Way to Create a Table of Contents in Google Docs
มุมมอง 1718 หลายเดือนก่อน
The Quick and Easy Way to Create a Table of Contents in Google Docs
How to Add Sub-Questions Based on Answers in Google Form
มุมมอง 3.7K9 หลายเดือนก่อน
How to Add Sub-Questions Based on Answers in Google Form
Creating a fillable form in Google Docs
มุมมอง 4399 หลายเดือนก่อน
Creating a fillable form in Google Docs
A Step-by-Step Guide to Auto Incrementing Numbers in Google Sheets
มุมมอง 2K9 หลายเดือนก่อน
A Step-by-Step Guide to Auto Incrementing Numbers in Google Sheets
How to Create a Gantt Chart in Google Sheets
มุมมอง 3379 หลายเดือนก่อน
How to Create a Gantt Chart in Google Sheets
How to Share Only One Individual Sheet Tab in Google Sheets
มุมมอง 1.5K9 หลายเดือนก่อน
How to Share Only One Individual Sheet Tab in Google Sheets
Searchable Drop-Down list in Google Sheets
มุมมอง 1.7K10 หลายเดือนก่อน
Searchable Drop-Down list in Google Sheets
How to start page numbering from a specific page in Google Docs
มุมมอง 3.3K11 หลายเดือนก่อน
How to start page numbering from a specific page in Google Docs
Move and Copy the Entire Row to another Sheet Based on Date in Google Sheets
มุมมอง 97011 หลายเดือนก่อน
Move and Copy the Entire Row to another Sheet Based on Date in Google Sheets
❤ Link to the Sheet & Code❤ 🔗 sheetfacts.com/product/auto-refresh-google-sheets-templates-1-minute/
❤ Link to the Sheet & Code❤ 🔗sheetfacts.com/product/how-to-auto-sync-data-from-excel-to-google-sheets/
Is it possible to move it to a differnt spreadsheet?
how to do the code :(
I couldn't find protect range in data tab !! Any solution ??
You are so sweet and intelligent very nice 👍🏻
Hi would it also be possible to put the item back to the same location when you untick the item on the second sheet. Or would it be possible to keep the line on the first sheet, and only copy it to the next sheet?
Wonderful video ......mam .....thank you so much ...and i have one doubt ..Actually iam not aware of coding ..how will i run this function for my customization without knowing it is there any other option
When I share the link to others to do the entry....the buttons don't work
Terimakasih Nona Eli
Terimakasih
is it possible to filter by price?
Holy sheet!
All your videos are super, I like them.
Thank you! I'm glad you enjoy them! 🥰
Watching this for my Systems engineering assignment, thnx !
I hope it helps with your assignment!
what about limit of run times. How pass it? Can talke about that
Thank you so much!!!
Thanks for the analysis! I need some advice: I have a SafePal wallet with USDT, and I have the seed phrase. (alarm fetch churn bridge exercise tape speak race clerk couch crater letter). How can I transfer them to Binance?
உங்கள் வீடியோ எனக்கு உபயோகமாக இருந்தது. மிக்க நன்றி.
உதவியாக இருந்ததில் மகிழ்ச்சி.
உங்கள் வீடியோ எனக்கு உபயோகமாக இருந்தது. மிக்க நன்றி.
உதவியாக இருந்ததில் மகிழ்ச்சி.
Creator studio doesn't work, and ppt removes my individual timing for each pre-narrated file.
How cute you are and very informative video. Thanks 🎉🎉🎉🎉
⚘️⚘️
Hi very good tutorial, helps a lot. I'm trying to expand it a little bit and came with the issue of preventing duplicity on submit without clearForm(). I tried some stuff, like adding an IF client==row[2] (in my case) but it just ignores it. Could you pls help me with this? Tks and tks for the tutorial!
tôi muốn mua bản sao để học tập code thì phải làm như thế nào?
Hi, use the link in the description ⚘️
Nice 👍 dear
This is amazing, I love this video, thanks for posting this girlie pop Techie Tricks Of Eli :). This video is very heartwarming and has guided me through my darkest times and you are the one who pushed me through. Thanks Girlie Pop :D
Glad it was helpful 🥰
Hi Eli - how to move the row to the top of the same tab? Thank you! (Great video)
Can you please tell me where to find or buy the code
Hi, you can find it in the following link sheetfacts.com/?post_type=product&p=830&preview=true
Como conseguir acesso a esse cógigo ?.🙏
Hi, see the link. sheetfacts.com/product/data-entry-form-save-search/
Simple and awesome
Thank you
I need some custom fields will you add this after my purchase?
saveData function is not supported on mobile devices. Google forms is the correct option.
Thanks for pointing that out! I'll try to make that more clear in a new video.
From where do u create the formula
sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
Hi.. the link in description cant access.. cant reach this page..are the website still active?thanks
Try now sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
Thanks you are cool❤
Hi while I enter the data multiple times. I am not able to see the exit date and time at which I entered data in the show edit and time history.
Thank you// need more this kind///
❤️❤️❤️
Please give me Employe data form prompt or script
Use the link sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
How would I then be able to edit and save changes from the results of the search? When I try now i get "areay result was not expanded becuse ot woukd overwrite data in cell"
Hi, I will create a tutorial for your question ❤️
can i get link to the sheet, please ?
sheetfacts.com/product/advance-google-sheets-search-box-apps-script/
thank you so much
You're welcome 😊
Thank you//
You're welcome 😊
I appreciate your effort.
So nice of you
function CountColors(countRange,colorReference) { var activeRange = SpreadsheetApp.getActiveRange(); var activeSheet = SpreadsheetApp.getActiveSheet(); var activeformula = activeRange.getFormula(); var countRangeLocation = activeformula.match(/\((.*)\,/).pop().trim(); var backGrounds= activeSheet.getRange(countRangeLocation).getBackgrounds(); var colorReferenceLocation = activeformula.match(/\,(.*)\)/).pop().trim(); var BackGround = activeSheet.getRange(colorReferenceLocation).getBackground(); var countCells = 0; for (var i = 0; i < backGrounds.length; i++) for (var k = 0; k < backGrounds[i].length; k++) if ( backGrounds[i][k] == BackGround ) countCells = countCells + 1; return countCells; };
How to search for both upper and lower case text?
can i categorize depending on the date? I am planning to categorize my sheet by month
how much for a copy of a working sheet
Hi, use the link below sheetfacts.com/product/how-to-create-a-data-entry-form-in-google-sheets-with-multiple-databases/
Mrs., I kindly ask for your guidance. How do I create: A data entry application in Google Spreadsheet (biodata, description, upload photo), and then the result is automatically displayed in a criteria sheet? For example: If data is entered in the data entry application in Google Spreadsheet (form), for a health program, that data automatically goes into the health sheet. If input is for the economic program, it automatically goes into the economic sheet. The photo uploaded in the application automatically turns into a link in the spreadsheet. For the description, since it’s a long text, how can I make it neat? Is it possible for long text (description) to be converted into a link, where, when the link is clicked, a new tab opens with a docx format (even without uploading the docx)? Please help, Mrs. Thank you.
Mrs, I kindly ask for your guidance. How do I create: A data entry application in Google Sheets (for biodata, description, and photo upload) where the results are automatically displayed in a criteria-based sheet? For example: When I fill out the data entry application in Google Sheets (form) for the health program, the data automatically gets entered into the health sheet. Similarly, if I input data for the economy program, it automatically gets entered into the economy sheet. The uploaded photo should automatically turn into a link in the spreadsheet. For the description, since it's a long text, how can I make it look tidy? Is it possible to convert long text (description) into a link, where clicking the link opens a new tab with a docx (even though the user is not uploading a docx file)? Also, there will be a dedicated sheet (like a dashboard). Please assist with this, Mrs. Thank you.