How to Automate Data Entry with Smart Fill in Google Sheets
116.7 هزار بار بازدید -
4 سال پیش
-
Join 400,000+ professionals in our
Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-cou...
Smart Fill in Google Sheets is a new AI-powered feature that automatically detects patterns, generates formulas, and autocompletes columns. Google Sheets SmartFill automatically analyzes cells within a spreadsheet to assist you with data entry.
⬇️ Download the workbook here: https://pages.xelplus.com/sheets-smar...
For example if you have a column of names and you'd like to get the first name of a person, you don't have to write a formula. You just need to type the result you want and Smart Fill will recognize what you want and autofill the column with First names. The great benefit of Smart Fill is that it provides you with the formula for this. This means your results will automatically update.
Shortcut key to apply the Smart Fill results in Sheets is Control + Shift + Y.
Excel has a similar feature called Flash Fill. In this video we'll find out what SmartFill can do and where are the differences to Excel's FlashFill.
Join My Google Sheets Comprehensive Masterclass: https://www.xelplus.com/course/google...
00:00 SmartFill in Google Sheets
00:53 How to Use SmartFill in Google Sheets
04:59 What Does Not Work in SmartFill (Yet)
07:52 How to Turn Off SmartFill in Google Sheets
08:23 Google Sheets' SmartFill Pros and Cons
LINK to Google Sheet Playlist: Google Sheets Tips, Tricks & Functions
Excel Flash Fill video: Excel Flash Fill For MAJOR Time Savin...
★ My Online Excel Courses ► https://www.xelplus.com/courses/
➡️ Join this channel to get access to perks: @leilagharani
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: Instagram: lgharani
LinkedIn: LinkedIn: xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#googlesheets
Smart Fill in Google Sheets is a new AI-powered feature that automatically detects patterns, generates formulas, and autocompletes columns. Google Sheets SmartFill automatically analyzes cells within a spreadsheet to assist you with data entry.
⬇️ Download the workbook here: https://pages.xelplus.com/sheets-smar...
For example if you have a column of names and you'd like to get the first name of a person, you don't have to write a formula. You just need to type the result you want and Smart Fill will recognize what you want and autofill the column with First names. The great benefit of Smart Fill is that it provides you with the formula for this. This means your results will automatically update.
Shortcut key to apply the Smart Fill results in Sheets is Control + Shift + Y.
Excel has a similar feature called Flash Fill. In this video we'll find out what SmartFill can do and where are the differences to Excel's FlashFill.
Join My Google Sheets Comprehensive Masterclass: https://www.xelplus.com/course/google...
00:00 SmartFill in Google Sheets
00:53 How to Use SmartFill in Google Sheets
04:59 What Does Not Work in SmartFill (Yet)
07:52 How to Turn Off SmartFill in Google Sheets
08:23 Google Sheets' SmartFill Pros and Cons
LINK to Google Sheet Playlist: Google Sheets Tips, Tricks & Functions
Excel Flash Fill video: Excel Flash Fill For MAJOR Time Savin...
★ My Online Excel Courses ► https://www.xelplus.com/courses/
➡️ Join this channel to get access to perks: @leilagharani
👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: https://www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: Instagram: lgharani
LinkedIn: LinkedIn: xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#googlesheets
4 سال پیش
در تاریخ 1399/08/20 منتشر شده
است.
116,764
بـار بازدید شده