The 101 Library
The 101 Library
  • 29
  • 1 138
Discover This Awesome Free ChatGPT Extension for Your Google Sheets 📥
Don't forget to like 👍, and subscribe 🔔for more tips and tutorials!
Welcome to The 101 Library! In this video, we'll dive into the amazing GPT Sheets Extension for Google Sheets-an AI-powered tool that will take your spreadsheets to the next level! 🚀 Whether you’re looking to automate tasks, generate insights, or streamline your workflow, this extension has got you covered. And the best part? You can do it all within your spreadsheet without having to go back and forth between ChatGPT and your data. 🧠💡
🔗 Install GPT Sheets Extension Here:
workspace.google.com/u/0/marketplace/app/gpt_for_docs_sheets_slides/451400884190
📚 What You'll Learn in This Video:
How to Install GPT Sheets 📥
How to Summarize Reviews with GPT Sheets ✏️
Formula: =GPT("Summarize this review in one sentence: " & B2)
How to Perform Sentiment Analysis 🎯
Formula: =GPT("Analyze the sentiment of this review: " & B2 & " and return 'Positive', 'Negative', or 'Neutral'")
How to Tag Categories Automatically 🏷️
Formula: =GPT("Tag the main themes of this review as keywords: " & B2 & ". Choose from 'Quality', 'Delivery', 'Support'")
How to Generate a List with GPT Sheets
Formula: =GPT_LIST("Generate a list of five different colors'")
🎥 Chapters:
0:00 Introduction: How AI is Revolutionizing Our Work and Lives
0:31 How to Install GPT Sheets Extension
1:49 Example 1: Summarizing Reviews in Google Sheets
3:10 Example 2: Performing Sentiment Analysis
4:13 Example 3: Automatically Tagging Review Categories
5:00 Advanced Tips and Tricks for Using GPT Sheets
🔧 Useful Resources & Tips:
Check Out More Google Sheets Tutorials:
Dynamic Dashboards in Google Sheets:th-cam.com/video/uZPoZW0H5XM/w-d-xo.htmlsi=H3yZXWmh92x63G0G
Mastering the SWITCH Function in Google Sheets:th-cam.com/video/0MH1PKakklI/w-d-xo.htmlsi=JNQXbnVmOgayAPjI
🎯 Get More from The 101 Library:
Don't forget to like 👍, subscribe 🔔, and hit the notification bell so you never miss an update! We’re always here to help you unlock the full potential of your digital tools. For more tips and in-depth tutorials, check out our other videos and playlists. You can also leave a comment below if you have any questions or suggestions! 💬
🌟 Thanks for Watching! Don't forget to check out our other videos for more Google Sheets tips and AI-powered tools that can transform your workflow. Until next time, happy spreadsheeting! 📈💻
🏷️ Tags:
#GoogleSheets #GPTSheets #ChatGPT #AIAutomation #SpreadsheetTips #DataAnalysis #ProductivityTools #TechTutorial #SpreadsheetAutomation #DataSummarization #SentimentAnalysis #AIPowered
มุมมอง: 10

วีดีโอ

Make a Dynamic Dashboard in Google Sheets in Just 14 Minutes
มุมมอง 11114 วันที่ผ่านมา
If you enjoyed the video, don’t forget to LIKE, SUBSCRIBE, and SHARE for more awesome content from The 101 Library! 💻📚 🚀 Ready to level up your data game? In this video, I’ll show you how to create a dynamic dashboard in Google Sheets that will take your productivity and data analysis to the next level! 📊✨ Whether you're tracking sales, analyzing trends, or managing projects, this tutorial will...
Stop Using NESTED IF in Your Spreadsheet! Use SWITCH Instead for Simplicity
มุมมอง 6621 วันที่ผ่านมา
🔔 Don’t Forget to: Like 👍 and Subscribe 🔔 to 'The 101 Library' for more tech tips and tutorials! Comment Below 💬 with your questions or let us know how you use SWITCH in your sheets! 🚀 Unlock the Power of Google Sheets with the SWITCH Function! 🚀 Are you tired of struggling with complex nested IF statements in Google Sheets? Say goodbye to confusion and hello to simplicity! In this video, we di...
How to Use the Hole Feature in Solid Edge
มุมมอง 2428 วันที่ผ่านมา
🔔 Subscribe for more Solid Edge tips and tutorials: www.youtube.com/@The101Library 👍 Like and Share this video if it helped you! 👋 Welcome to another tutorial from 'The 101 Library'! Today, we're focusing on the Hole feature in Solid Edge. We'll show you how to effectively use this tool to add various types of holes to your designs. Key Topics: Selecting and using the Hole tool 🛠️ Creating simp...
Introduction to Solid Edge for Beginners
มุมมอง 29หลายเดือนก่อน
🔔 Subscribe for more Solid Edge tips and tutorials: www.youtube.com/@The101Library 👍 Like and Share this video if it helped you! 👋 Hi everyone! Welcome back to 'The 101 Library'. In this beginner's guide to Solid Edge, we'll cover the basics you need to get started. Learn how to navigate the interface, create your first sketch, and extrude it into a 3D model. Key Topics: Solid Edge interface ov...
Solid Edge Tutorial: SYNCHRONOUS vs. ORDERED - Discover the Key Differences
มุมมอง 55หลายเดือนก่อน
🔔 Subscribe for more SolidEdge tips and tutorials: www.youtube.com/@The101Library 👍 Like and Share this video if it helped you! 👋 Welcome to 'The 101 Library'! Today, we dive into the 🔑 differences between Synchronous Mode and Ordered Mode in Solid Edge. Understanding these modes is essential for efficient 3D modeling. We'll demonstrate how to use each mode, their strengths, and when to use the...
How to Make a Line Graph in Google Sheets | Quick and Easy Tutorial |
มุมมอง 29หลายเดือนก่อน
Welcome back to The 101 Library! In this tutorial, we'll learn how to create line charts in Google Sheets with this step-by-step tutorial for beginners. Use this chart type to show trends over time (years, months, and days) or categories. Whether you're tracking sales, website traffic, or any other data over time, line plots are an excellent way to visualize trends and patterns. Follow along wi...
How to Generate BARCODES and QR CODES in Google Sheets for FREE
มุมมอง 231หลายเดือนก่อน
Welcome back to 'The 101 Library'! In this video, I'll show you how to easily generate barcodes and QR codes in Google Sheets using the IMAGE function and the free API from barcodeapi.org. Whether you need barcodes for inventory management or QR codes for quick links, this method is simple and cost-effective. 🔔 Subscribe for more Google Sheets tips and tutorials: / @the101library 👍 Like and Sha...
Understanding Loops in MATLAB: For, While, and Nested Loops Explained
มุมมอง 192 หลายเดือนก่อน
🔔 Subscribe for more MATLAB tips and tutorials: www.youtube.com/@The101Library 👍 Like and Share this video if it helped you! Welcome to The 101 Library! In this video, we dive into one of the fundamental concepts in programming: loops. Specifically, we'll cover 'For' and 'While' loops in MATLAB, and also explore nested loops for more complex tasks. Whether you're a beginner or looking to refres...
Automating Tasks & Data Transfer with Make | Simple & Easy Guide|
มุมมอง 182 หลายเดือนก่อน
🔔 Subscribe for more tips and tutorials: www.youtube.com/@The101Library 👍 Like and Share this video if it helped you! Welcome to The 101 Library! In this video, we dive into the world of automation using "Make" (formerly Integromat). Discover how to effortlessly connect different apps and automate routine tasks to save time and boost productivity. What You'll Learn: Introduction to Make (Integr...
Trello Tutorial for Beginners: How to Create Boards, Lists, and Cards
มุมมอง 272 หลายเดือนก่อน
🔔 Subscribe for more tips and tutorials: www.youtube.com/@The101Library 👍 Like and Share this video if it helped you! Welcome to The 101 Library! In this video, we'll introduce you to Trello, a fantastic tool for organizing projects and tasks. We'll guide you through a live example of creating a Trello board, adding lists, cards, and card details. Perfect for beginners and anyone looking to enh...
Creating a Simple Floor Plan in AutoCAD | Quick & Easy |
มุมมอง 352 หลายเดือนก่อน
🔔 Subscribe for more AUTOCAD tips and tutorials: www.youtube.com/@The101Library 👍 Like and Share this video if it helped you! Welcome to The 101 Library! In this video, we will walk you through the process of creating a simple floor plan in AutoCAD. We'll cover everything from setting up your drawing to creating walls, doors, and windows, and using AutoCAD's premade blocks from the Design Cente...
Master Microsoft LISTS in 5 Minutes! | Quick & Easy Tutorial |
มุมมอง 982 หลายเดือนก่อน
🔔 Subscribe to The 101 Library for more tech tips and tutorials: www.youtube.com/@UCX8CzczlojUGVy8KbIxGBfQ Welcome to The 101 Library! In this video, we dive into Microsoft Lists and explore why it’s a powerful tool for managing information. We’ll compare it to Excel, discuss the benefits of linking your lists with other Microsoft apps like Forms and Power Automate, and provide a step-by-step g...
Master Microsoft FORMS in Under 5 Minutes! | Quick & Easy Tutorial |
มุมมอง 282 หลายเดือนก่อน
🔔 Subscribe to The 101 Library for more tech tips and tutorials: www.youtube.com/@The101Library Welcome back to The 101 Library! 📚 In this quick tutorial, we'll show you how to master Microsoft Forms in less than 5 minutes! Learn how to access Microsoft Forms, create and customize a form, share it, and collect responses efficiently. Perfect for anyone needing to create surveys, quizzes, or feed...
How to use Microsoft Apps for FREE!
มุมมอง 262 หลายเดือนก่อน
🔔 Subscribe for more Microsoft Apps tips and tutorials: www.youtube.com/@The101Library 👍 Like and Share this video if it helped you! Welcome to The 101 Library! 📚 In this first video of our new series on mastering Microsoft apps, we show you how to access Microsoft Word, Excel, PowerPoint, and more for FREE through the Microsoft Apps website. Learn how to create an account, navigate the dashboa...
Fundamental Concepts of IF Function in MATLAB
มุมมอง 62 หลายเดือนก่อน
Fundamental Concepts of IF Function in MATLAB
PIVOT TABLES in Google Sheets
มุมมอง 152 หลายเดือนก่อน
PIVOT TABLES in Google Sheets
AutoCAD Dynamic Blocks: A Comprehensive Tutorial
มุมมอง 223 หลายเดือนก่อน
AutoCAD Dynamic Blocks: A Comprehensive Tutorial
Essential Guide to MATLAB Scripts and Functions: Boost Your EFFICIENCY
มุมมอง 93 หลายเดือนก่อน
Essential Guide to MATLAB Scripts and Functions: Boost Your EFFICIENCY
MATLAB Basics: Your ULTIMATE Getting Started Guide
มุมมอง 143 หลายเดือนก่อน
MATLAB Basics: Your ULTIMATE Getting Started Guide
ANNOTATION and PARAMETRIC Modeling in AutoCAD
มุมมอง 313 หลายเดือนก่อน
ANNOTATION and PARAMETRIC Modeling in AutoCAD
Mastering AutoCAD: BLOCKS and LAYERS
มุมมอง 253 หลายเดือนก่อน
Mastering AutoCAD: BLOCKS and LAYERS
AutoCAD: Essential COMMANDS for BEGINNERS (Line, Circle, Copy, Trim, Move)
มุมมอง 203 หลายเดือนก่อน
AutoCAD: Essential COMMANDS for BEGINNERS (Line, Circle, Copy, Trim, Move)
AutoCAD Basics: Your ULTIMATE Getting Started Guide
มุมมอง 1253 หลายเดือนก่อน
AutoCAD Basics: Your ULTIMATE Getting Started Guide
VLOOKUP, HLOOKUP & XLOOKUP: All You Need To Know!
มุมมอง 83 หลายเดือนก่อน
VLOOKUP, HLOOKUP & XLOOKUP: All You Need To Know!
Google Sheets IF FUNCTION: Beyond the Basics
มุมมอง 93 หลายเดือนก่อน
Google Sheets IF FUNCTION: Beyond the Basics
Google Sheets: Introduction to IF FUNCTION for BEGINNERS
มุมมอง 104 หลายเดือนก่อน
Google Sheets: Introduction to IF FUNCTION for BEGINNERS
Essential Guide: Top 5 Google Sheets FORMULAS for Beginners
มุมมอง 214 หลายเดือนก่อน
Essential Guide: Top 5 Google Sheets FORMULAS for Beginners
5 GOOGLE SHEETS Essentials for BEGINNERS
มุมมอง 194 หลายเดือนก่อน
5 GOOGLE SHEETS Essentials for BEGINNERS

ความคิดเห็น

  • @The101Library
    @The101Library 2 วันที่ผ่านมา

    🚀 What GPT function do you find most useful in your spreadsheets? Drop a comment below and let’s share ideas! Your insights could inspire others to try new things, and I’d love to hear how you're using AI to boost your productivity. Don’t forget to hit that 👍 if you found this video helpful, and share any tips or tricks you’ve discovered with GPT Sheets! Let’s keep the conversation going!"

  • @SamiaMuraweh
    @SamiaMuraweh 25 วันที่ผ่านมา

    I love this! Very clear to understand and will make writing my functions in Sheets so much easier!

    • @The101Library
      @The101Library 21 วันที่ผ่านมา

      Thank you for watching

  • @The101Library
    @The101Library 25 วันที่ผ่านมา

    👉 Want to learn more about Google Sheets? Check out our playlist here for more tips and tricks to master your spreadsheets! 📊✨ Google Sheets Tutorials: th-cam.com/play/PLIOBVXau5TJH-qQVngpfTUE6hS4LFwCpu.html If you found this video helpful, make sure to LIKE 👍 and SUBSCRIBE 🔔 to 'The 101 Library' for more awesome tutorials! 💡 Got questions or feedback? Drop a comment below! 💬 And let us know how you're using the SWITCH function in your projects. 🚀 Happy Spreadsheeting! 🎉 #The101Library #GoogleSheets #TechTips #SpreadsheetMasteryth-cam.com/users/sgaming/emoji/7ff574f2/emoji_u1f680.png

  • @The101Library
    @The101Library หลายเดือนก่อน

    🎉 Thanks for watching! If you found this video on how to use the hole tool in Solid Edge helpful, don't forget to smash that 👍 button and subscribe to 'The 101 Library' for more awesome tech tutorials! 🚀🔔 💬 Got questions or video suggestions? Drop them in the comments below! 👇 📺 Check out our other videos to boost your Solid Edge skills: ISYNCHRONOUS vs. ORDERED mode: th-cam.com/video/H4lsL_--fAs/w-d-xo.htmlsi=zWAFnrjPLYIPDeYa Intro to Solid Edge: th-cam.com/video/vPzTh4yRZN4/w-d-xo.html Stay connected and subscribe to 'The 101 Library' for more updates and tips! 🌟📲"

  • @The101Library
    @The101Library หลายเดือนก่อน

    🎉 Thanks for watching! If you found this introduction video helpful, don't forget to smash that 👍 button and subscribe to 'The 101 Library' for more awesome tech tutorials! 🚀🔔 💬 Got questions or video suggestions? Drop them in the comments below! 👇 📺 Check out our other videos to boost your Solid Edge skills: 🔄 Synchronous vs. Ordered Mode: th-cam.com/video/H4lsL_--fAs/w-d-xo.htmlsi=zWAFnrjPLYIPDeYa 🛠 Intro to Solid Edge: th-cam.com/video/vPzTh4yRZN4/w-d-xo.html Stay connected and subscribe to 'The 101 Library' for more updates and tips! 🌟📲

  • @The101Library
    @The101Library หลายเดือนก่อน

    🎉 Thanks for watching! If you found this video on the difference between Synchronous Mode and Ordered Mode helpful, don't forget to smash that 👍 button and subscribe to 'The 101 Library' for more awesome tech tutorials! 🚀🔔 💬 Got questions or video suggestions? Drop them in the comments below! 👇 📺 Check out our other videos to boost your Solid Edge skills: Intro to Solid Edge: th-cam.com/video/vPzTh4yRZN4/w-d-xo.html How to use the Hole tool in Solid Edge: th-cam.com/video/vPzTh4yRZN4/w-d-xo.html Stay connected and subscribe to 'The 101 Library' for more updates and tips! 🌟📲

  • @corynnecasten5515
    @corynnecasten5515 หลายเดือนก่อน

    Can you do a video how to scale the codes so they don't print super tiny?

  • @corynnecasten5515
    @corynnecasten5515 หลายเดือนก่อน

    Also I'm working with Square POS what is the best way to print this into labels?

  • @corynnecasten5515
    @corynnecasten5515 หลายเดือนก่อน

    Thank you for this video. When I hit enter to generate the code mine has the word auto in front of the numbers.. what did I do wrong?

    • @The101Library
      @The101Library หลายเดือนก่อน

      Hello, sorry for the late reply. I am not sure why your barcode has "auto" in front. This is the formula I used (=IMAGE("barcodeapi.org/api/auto/"&A1 )). All you have to do is to replace "A1" with the cell that has your code value. Make sure that your code value is set as Text (refer to video for that). If all this does not work, try to replace auto with a specific barcode type from the barcode list. As for the size of the barcode and how to print them in labels, I suggest that you copy the generated barcode into a Google Doc or a Word document and past the code as a "Picture". Then, you can resize your code as needed and then print it as a label. I will try to make a video of that soon in the future. Hope this helps! Let me know how it goes.

  • @abdulwasim1205
    @abdulwasim1205 หลายเดือนก่อน

    very useful dude please do a video for applying these in loops in matlab function in simulink block

    • @The101Library
      @The101Library หลายเดือนก่อน

      Thanks for watching. Very glade it helps. I do not have much experience with Simulink but I will try to look into this. Appreciate your feedback.

  • @The101Library
    @The101Library หลายเดือนก่อน

    Thanks for watching! 🎉 If you found this video on making line charts in Google Sheets helpful, don't forget to smash that 👍 button and subscribe to 'The 101 Library' for more awesome tech tutorials! 🚀 Got questions or video suggestions? Drop them in the comments below! 💬 Check out our other videos to boost your tech skills: 👉How to use Microsoft Lists: th-cam.com/video/D4qy16UXqus/w-d-xo.htmlsi=fIxrY4ilRb-rnawQ 👉 Essential Google Sheets Tips for Beginners: th-cam.com/play/PLIOBVXau5TJH-qQVngpfTUE6hS4LFwCpu.html Stay connected and subscribe to the101library for more updates and tips! 📱

  • @The101Library
    @The101Library หลายเดือนก่อน

    Thanks for watching! 🎉 If you found this video on generating barcodes and QR codes in Google Sheets helpful, don't forget to smash that 👍 button and subscribe to 'The 101 Library' for more awesome tech tutorials! 🚀 Got questions or video suggestions? Drop them in the comments below! 💬 Check out our other videos to boost your tech skills: 👉How to use Microsoft Lists: th-cam.com/video/D4qy16UXqus/w-d-xo.htmlsi=fIxrY4ilRb-rnawQ 👉 Essential Google Sheets Tips for Beginners: th-cam.com/play/PLIOBVXau5TJH-qQVngpfTUE6hS4LFwCpu.html Stay connected and subscribe to the101library for more updates and tips! 📱

  • @The101Library
    @The101Library 2 หลายเดือนก่อน

    MATLAB is packed with valuable tools that can help you master data analysis and mathematical processes. Leave your questions and thoughts in the comments below! Also, let us know what other MATLAB topics you'd like us to cover. Check out the full playlist for more MATLAB tips and tricks!" th-cam.com/play/PLIOBVXau5TJFgcOk_JCIAKg5KrhXMLuya.html&si=1nt5NJODI5CrGFRD

  • @The101Library
    @The101Library 2 หลายเดือนก่อน

    🚀 Let us know how you like this AutoCAD tutorial! For more AutoCAD beginner-friendly tutorials, check out the playlist here: th-cam.com/play/PLIOBVXau5TJHIQY7axL1_-EFeP-sFUynH.html 👍 🖊✨ How are you planning to use AutoCAD in your projects? Share your ideas and goals! 🏗💡

  • @The101Library
    @The101Library 2 หลายเดือนก่อน

    🚀 Microsoft Lists is packed with valuable tools that can help you master organization and streamline your workflow. 📋✨ What innovative ways do you use Microsoft Lists to manage your tasks? Share your best tips! 📌💡 For more detailed guides and tips, check out the full playlist here: th-cam.com/play/PLIOBVXau5TJF38ZIJBV2YUGve3Gq8bXEH.html.

  • @The101Library
    @The101Library 2 หลายเดือนก่อน

    🚀 This Trello tutorial is a game-changer! The tips and tricks shared here can really boost your productivity and organization skills. 📝✨ Let us know what are the top tips you use to customize your Trello boards to stay organized? Share your unique setups! 📌💡 For more insightful productivity hacks, check out the full playlist here: th-cam.com/play/PLIOBVXau5TJF38ZIJBV2YUGve3Gq8bXEH.html.

  • @The101Library
    @The101Library 2 หลายเดือนก่อน

    🚀 Loved this tutorial on automating tasks and data transfer with Make! It's incredible how much time and effort you can save by connecting different apps. ❓✨ What apps are you automating with Make? Share your favorites! 💡🔧! For more productivity tips and tricks, check out the full playlist here: th-cam.com/play/PLIOBVXau5TJF38ZIJBV2YUGve3Gq8bXEH.html. Keep up the great work, The 101 Library! 👍