GPT for Work (GPT for Sheets, Docs, Excel Word)
GPT for Work (GPT for Sheets, Docs, Excel Word)
  • 48
  • 977 674
How to use ChatGPT into Microsoft Word: a beginner’s guide (101)
Like ChatGPT? Now, use it in Word too! Discover how to use the GPT for Excel Word add-in and unleash the power of OpenAI's artificial intelligence with its latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo directly into Microsoft Word! 👇
Get the GPT for Excel Word add-in: gptforwork.com/install-msft
Chat with your Word documents and edit them by inserting chat responses directly inside the documents. You can also track these changes effortlessly using Microsoft Word's Track Changes feature.
The add-in enables you to:
- translate all or parts of your documents
- quickly create new relevant content
- ask questions to quickly understand what a document is about
- spot key information in a document
and much more !
⌚️ TIMESTAMPS
00:00 Introduction
00:26 Summarize a document
00:57 Extract information from a document
01:39 Translate content
02:08 Track changes made in the document when inserting chat responses
03:23 Clear chat
03:40 Switch OpenAI’s models
03:57 How to buy a pack
▶️ PLAYLIST:
Discover all the functionalities of the GPT for Word add-in: czcams.com/play/PLI1hJP_Ps2kP0ORvlHVpUV5XFyNTJYP4r.html
📥 Find out more about how to use GPT for word : gptforwork.com/help/gpt-for-word
❗️ Do not hesitate to comment below or fill out this form with your questions and feedback, we'll be happy to answer: support.gptforwork.com/hc/en-us/requests/new
------------------------------------------------------------------------------------------
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!
GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!
👉 Install for Microsoft: gptforwork.com/install-msft
👉 Install for Google: gptforwork.com/install-google
Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.
💡 More resources and examples on our website: gptforwork.com/
🔔 Don't miss any new feature by subscribing to our channel: www.youtube.com/@gpt4work
------------------------------------------------------------------------------------------
This channel is brought to you by TALARIAN: talarian.io/
Check out our other productivity tools for Google Workspace:
🚀 YAMM : yamm.com/
🔥 AWESOME TABLE : awesome-table.com/
🤖 FORM PUBLISHER : form-publisher.com/
zhlédnutí: 91 290

Video

GPT for Excel: a beginner's guide (101)
zhlédnutí 90KPřed 6 měsíci
Like ChatGPT? Now, use it in Excel too! Discover how to use the GPT for Excel Word add-in and unleash the power of OpenAI's artificial intelligence with its latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo directly into Microsoft Excel! 👇 Get the GPT for Excel Word add-in: gptforwork.com/install-msft This add-in enables simple custom functions to help you achieve all sort of tasks suc...
Insert options in GPT for Docs
zhlédnutí 2,8KPřed rokem
In this video, find out what the different insertion options available in GPT for Docs are. Simply decide where your output should be generated in your Google Docs and easily manage all the insert settings directly from the sidebar. There’s more: GPT for Docs has a highlight feature to make your output stand out from the rest of your text. You can also choose whether to insert your prompt in yo...
Use document context with ChatGPT in Google Docs
zhlédnutí 4,3KPřed rokem
Feeding your prompt with the right context is very important to generate specific and accurate content with ChatGPT. In this video, we explain to you how to use the GPT for Docs sidebar to use your document or portions of your documents as context to generate more writing with ChatGPT in Google Docs. ⌚️TIMESTAMPS 00:00 Use the whole document as context 1:16 Use a selection as context to expand ...
Comparing Google Translate and ChatGPT for Hindi to English
zhlédnutí 10KPřed rokem
In this video, we compare Google Translate and ChatGPT through a compelling example of an English/Hindi translation. Unlike Google Translate, with ChatGPT you can customize your prompts and provide some context to get more accurate results. Make sure your translations are consistently spot-on by using ChatGPT and GPT for Sheets and Docs 😉 ⌚️TIMESTAMPS 00:00 Introduction 00:27 Translate indian n...
Split your text with GPT for Sheets
zhlédnutí 5KPřed rokem
Our new function GPT_SPLIT enables you to semantically split text and get one item per cell. Use GPT_SPLIT to return outputs listed vertically and GPT_HSPLIT if you prefer to get the outputs listed horizontally. You can split your text into: - sections - paragraphs - sentences - punctuations and even letters! ⌚️TIMESTAMPS 00:00 Vertically split your text into paragraphs 01:39 Horizontally split...
Translate text with a custom dictionary and GPT_TRANSLATE
zhlédnutí 2,7KPřed rokem
Do you need to translate text but want to avoid literal translations for specific terms or words? Introducing the refined GPT_TRANSLATE function, which allows you to effortlessly translate text using your own customized dictionary. This is super useful when translating: - generic words into very specific terms (such as brand names) - common source-language abbreviations or terms that have no st...
How to use ChatGPT into Google Docs: a beginner's guide (101)
zhlédnutí 16KPřed rokem
Like ChatGPT? Use it in Google Docs! The possibilities of ChatGPT are almost endless. Discover how to use the GPT for Docs add-on and unleash the power of OpenAI GPT-3 and GPT-4 artificial intelligence directly into Google Docs - no need to mess with apps script! 👇 Get the GPT for Sheets and Docs add-on: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654 Our custom sideba...
Introducing the GPT for Sheets sidebar!
zhlédnutí 6KPřed rokem
We just released the GPT for Sheets sidebar! A brand-new interface that will help you be even more efficient when using ChatGPT in Google Sheets. In this video, we show you the latest features we developed including: a list of all our functions to easily spot which GPT function best suits your needs a Google Sheets assistant for you to quickly understand and generate Google Sheets formulas a ce...
Create an interactive FAQ with GPT for Sheets
zhlédnutí 3,1KPřed rokem
Create your own interactive FAQ in Google Sheets! In this video, we explain step-by-step how to build an interactive FAQ with GPT for Sheets. Now, you can ask your questions directly in your spreadsheet and let ChatGPT answer them! Function in this video Syntax =GPT_MAP(search_keys, range, [confidence], [stats], [top_k]) ⌚️ TIMESTAMPS 00:00 See how it works (example) 01:21 Step 1: Identify rel...
Bulk write and send unique emails with ChatGPT and YAMM
zhlédnutí 6KPřed rokem
Discover how to write and send unique personalized emails in bulk thanks to GPT for Sheets and YAMM. ⌚️TIMESTAMPS 00:00 Draft your first email body 02:28 Get different emails for each recipient 04:50 Write email subject lines 06:14 Create a Gmail email draft 7:46 Run YAMM and send your emails 09:00 Track your emails status ▶️ PLAYLIST: Discover all the functionalities of the GPT for Sheets and ...
Autofill your ranges based on examples with ChatGPT in Sheets!
zhlédnutí 11KPřed rokem
Sometimes describing what you want in a prompt can be tricky! With the GPT_FILL function of GPT for Sheets, just write a few example rows to show what you expect, and ChatGPT will fill the rest of your list rows according to the defined pattern. In this video, we present two use cases but you can use GPT_FILL() in Google Sheets to: - clean up your lists - extract entities - classify content and...
How to control the execution of your GPT for Sheets functions
zhlédnutí 6KPřed rokem
How to control the execution of your GPT for Sheets functions
Creating Tables of Data in Seconds with ChatGPT
zhlédnutí 19KPřed rokem
Creating Tables of Data in Seconds with ChatGPT
Let’s compare ChatGPT and GPT-3 models with GPT for Sheets
zhlédnutí 2,8KPřed rokem
Let’s compare ChatGPT and GPT-3 models with GPT for Sheets
Clean your Google Sheets with ChatGPT
zhlédnutí 8KPřed rokem
Clean your Google Sheets with ChatGPT
Format your data in Sheets automagically with ChatGPT
zhlédnutí 7KPřed rokem
Format your data in Sheets automagically with ChatGPT
Create lists of data in Sheets with ChatGPT
zhlédnutí 16KPřed rokem
Create lists of data in Sheets with ChatGPT
How to map two columns of values in Google Sheets with ChatGPT
zhlédnutí 31KPřed rokem
How to map two columns of values in Google Sheets with ChatGPT
Polish your content with ChatGPT in Google Sheets
zhlédnutí 7KPřed rokem
Polish your content with ChatGPT in Google Sheets
Classify data in Google Sheets with ChatGPT
zhlédnutí 22KPřed rokem
Classify data in Google Sheets with ChatGPT
How to summarize text with ChatGPT in Google Sheets
zhlédnutí 12KPřed rokem
How to summarize text with ChatGPT in Google Sheets
Speedrun of GPT for Sheets
zhlédnutí 110KPřed rokem
Speedrun of GPT for Sheets
Make ChatGPT translate content in Google Sheets GPT_TRANSLATE
zhlédnutí 19KPřed rokem
Make ChatGPT translate content in Google Sheets GPT_TRANSLATE
Make ChatGPT extract entities from Google Sheets data with GPT_EXTRACT
zhlédnutí 13KPřed rokem
Make ChatGPT extract entities from Google Sheets data with GPT_EXTRACT
Make ChatGPT tag your data in Google Sheets with GPT_TAG
zhlédnutí 11KPřed rokem
Make ChatGPT tag your data in Google Sheets with GPT_TAG
How to easily call ChatGPT in Google Sheets
zhlédnutí 28KPřed rokem
How to easily call ChatGPT in Google Sheets
Generate tables of data in Google Sheets with ChatGPT
zhlédnutí 23KPřed rokem
Generate tables of data in Google Sheets with ChatGPT
ChatGPT in Sheets: how to use OpenAI temperature parameter
zhlédnutí 7KPřed rokem
ChatGPT in Sheets: how to use OpenAI temperature parameter
ChatGPT in Sheets: what are OpenAI tokens and how to use the max_tokens parameter
zhlédnutí 12KPřed rokem
ChatGPT in Sheets: what are OpenAI tokens and how to use the max_tokens parameter

Komentáře

  • @fahadhussain9824
    @fahadhussain9824 Před 4 dny

    hey stan i have an issue i used gpt fill but the function didnot fill the other remaining rows it only fills one row i tried several ways use dragging the way down but it gives error whats the problem plz guide me thankyu

  • @ninastales
    @ninastales Před 5 dny

    wow...this is amazing.

  • @oscarguinane2184
    @oscarguinane2184 Před 8 dny

    Wow

  • @retrorecordings
    @retrorecordings Před 12 dny

    so you need a pay openai account for using this?

    • @gptforwork
      @gptforwork Před 4 dny

      not any more. it was needed at the launch of the product and through 2023

    • @retrorecordings
      @retrorecordings Před 4 dny

      @@gptforwork Thanks a Lot!!!

  • @AshokKumar-dk2xp
    @AshokKumar-dk2xp Před 17 dny

    🎉🎉🎉🎉🎉❤❤❤❤😂

  • @RodrigoCamarena-p7o
    @RodrigoCamarena-p7o Před 19 dny

    How can you personalize the email with the name of the person?

    • @gptforwork
      @gptforwork Před 18 dny

      you can include the name in the prompt with a reference to the cell or column

    • @RodrigoCamarena-p7o
      @RodrigoCamarena-p7o Před 16 dny

      @@gptforwork Thank you Stan, very useful. One last question, can GPT for Work can browse the internet?

    • @gptforwork
      @gptforwork Před 4 dny

      Yes, in Sheets / Excel, via GPT_WEB or the "Search the web" Bulk tool, which use the perplexity.ai API under the hood

  • @prashantrajaji9550
    @prashantrajaji9550 Před 20 dny

    is there a limit to the amount of times i can use this with ms word

    • @gptforwork
      @gptforwork Před 18 dny

      you're only limited by what you pay for.

  • @小漠-i4r
    @小漠-i4r Před 21 dnem

    非常感谢您的分享,您把您的智慧充分发挥出来,充分帮助到了那些需要的人,我作为一个英文不好的中国人,无法顺畅的使用这个工具,感觉错过了一个宝藏。还是感谢您的分享。

    • @gptforwork
      @gptforwork Před 18 dny

      thank you for your feedback! we will try to make it easier for Chinese speakers to use our product in 2025 (translating the UI and our video tutorials)

  • @DRKHATEEBO
    @DRKHATEEBO Před 23 dny

    Add glossary support to customize translation , add Claude sonnet 3.5 models.

    • @gptforwork
      @gptforwork Před 18 dny

      roger that! sonnet 3.5 is coming soon to Word, and then we will add the glossary.

  • @LuizPedrodaSilva-f4h
    @LuizPedrodaSilva-f4h Před měsícem

    ok

  • @AnielJaquez-g6f
    @AnielJaquez-g6f Před měsícem

    And height

  • @mikehem
    @mikehem Před měsícem

    I have a MS 365 personal license, when I click "sign in with Microsoft', it brings up a sign in window in the left, i input the correct details, it then closes the sign in window and nothing happens (still showing the 'Welcome to GPT for Word' window to the right) - Any ideas / help would be appreciated!

    • @gptforwork
      @gptforwork Před měsícem

      Microsoft had a big outage last week, could you please try again?

  • @user-wg7st4nw7z
    @user-wg7st4nw7z Před měsícem

    Use the example of a ready-made table to show why you are showing an empty table, creating it in front of us?

  • @Comments123123
    @Comments123123 Před měsícem

    I like the addin a lot. Can I also use default prompts in word? I usually only want it to correct a selection of word text and I do not want to retype my prompt ("correct this") again and again. Thank you!

    • @gptforwork
      @gptforwork Před měsícem

      thanks for the feedback, makes a lot of sense. we'll work on that soon!

  • @AndriusMinkevičius
    @AndriusMinkevičius Před měsícem

    Nothing fancy, but thanks, you saved some of my brain cells, so now I don't have to invent all this :)

  • @lolashelma3479
    @lolashelma3479 Před měsícem

    wow thankyou

  • @elearningmarketplace5024
    @elearningmarketplace5024 Před měsícem

    Hi, I've installed the extension, my =GPT formula is working on 50% of the rows. Where it is not working it is saying #Error and states Error: Empty balance. Go to: Extensions > GPT for Sheets™ and Docs™ > Billing. (line 8204). I have looked to try and renew the API key, however the API key is not listed in the extension menu. Any help will be greatly received.

    • @elearningmarketplace5024
      @elearningmarketplace5024 Před měsícem

      I am using GPT 4 and the sidebar says that no API key needed, which i now realise is why I don't have it in the menu.

    • @elearningmarketplace5024
      @elearningmarketplace5024 Před měsícem

      I have $20 credits in the OpenAI account.

    • @gptforwork
      @gptforwork Před měsícem

      hello, you need to buy a pack from us. We need to make some money too!

  • @Soproni_Larynx_Forditoiroda

    *A VERY IMPORTANT and USEFUL FACT I'd like to point out:* What else needs to be mentioned about this add-in, and what makes it exceptionally good, is that most other ChatGPT-based programs, add-ins, or add-ons that use an API key tend to forget the previous context. In most cases, every API key query is a separate instruction that connects with the ChatGPT servers, where ChatGPT itself handles only that one request, regardless of the previous request(s). However, here I see that even when using an API key, it maintains the previous context. At least for 5-6 prompts, it’s guaranteed. This is a significant and outstanding feature (whether intentionally designed or accidentally discovered) that should be highlighted in any advertisement! For shorter texts, it does an excellent job even with an API key, maintaining context for up to 5-6 sentences. Even if I process sentences individually, it consistently keeps track of the context up to 5-6 sentences. Personally, I use a mix of both methods-uploaded credits for longer texts, as it handles extensive context, and API keys for shorter ones. This way, this add-in strikes a balance and offers a win-win solution for everyone. In summary, I don't know if you personally created it or just made the reviews about it, but either way, thank you to the developer for this sensational MS Word add-in! this is excellent and highly versatile, especially considering related context, depending on the length of the text to be processed! Just an exceptional return on investment!

  • @cgc2300
    @cgc2300 Před 2 měsíci

    hello

  • @faridbinzainudinjmg5510
    @faridbinzainudinjmg5510 Před 2 měsíci

    how to get the editing tabs that next to share tab at upper right .

  • @user-dh5ds8jv4j
    @user-dh5ds8jv4j Před 2 měsíci

    한국어

  • @NewkFritz
    @NewkFritz Před 2 měsíci

    How many lines can it do?

    • @gptforwork
      @gptforwork Před 18 dny

      with our bulk tools, up to 200k rows in a single run works well. It will take ~10 hours.

  • @danielaflores9217
    @danielaflores9217 Před 2 měsíci

    hello! can i use this without chat gpt and create my own questions and answers?

  • @nerdsdoitbettervid
    @nerdsdoitbettervid Před 2 měsíci

    Is there a way to do this in the sidebar? This is the one thing I think this is missing is the ability to chat with a sheet

  • @ibh9999
    @ibh9999 Před 2 měsíci

    The answer that visible is short.

  • @mobtro86
    @mobtro86 Před 2 měsíci

    This was great

  • @iticotaco5603
    @iticotaco5603 Před 2 měsíci

    Can this help me make macros to automate my workflow?

  • @mikekaneceo
    @mikekaneceo Před 2 měsíci

    Is there a way to extract data from a PDF?

    • @gptforwork
      @gptforwork Před 18 dny

      Hi, just recently we have added integration with OpenAI assistants, so you could upload your PDF to an OpenAI assistant and then use it to extract data. If this doesn't work for you, we'd be interested in hearing more detail (how do your PDF look like, what data do you want to extract, etc) about your use-case so we can improve the product for you. Please contact our support!

  • @jobarmure6169
    @jobarmure6169 Před 2 měsíci

    Great video, quick and efficient, thanks!

  • @josuepablopenacorrea109
    @josuepablopenacorrea109 Před 2 měsíci

    This amazing!, but ... can i also use this AI for excel formulas?

    • @user-tj9qd4vh3e
      @user-tj9qd4vh3e Před 2 měsíci

      想的美

    • @gptforwork
      @gptforwork Před 18 dny

      you can use GPT for Excel to write/edit/translate/analyse text in Excel, but not yet for formulas

  • @DannielleSzuba
    @DannielleSzuba Před 3 měsíci

    Thanks for the tutorial it was very intuitive, however I believe you might need to update your video as some of the features you mentioned aren't available on the new installments.

    • @gptforwork
      @gptforwork Před 18 dny

      Hello, yes indeed, the product has improved a lot, I need to make new videos, they will come soon :)

  • @seizuhanaizumi9173
    @seizuhanaizumi9173 Před 3 měsíci

    Will I be charged if I install in extension?

    • @gptforwork
      @gptforwork Před měsícem

      No, only if you purchase a pack. There is no hidden charges!

  • @Jesussanchezsustentable
    @Jesussanchezsustentable Před 3 měsíci

    Estimado, donde puedo ver estos tutoriales en español???

    • @gptforwork
      @gptforwork Před 18 dny

      Lo siento, aún no tenemos tutoriales en español.

  • @malcolmklein9316
    @malcolmklein9316 Před 3 měsíci

    Not sure what your "Chinese" translation actually stated. Chinese is not a language. The major languages spoken in China is Mandarin and Cantonese. Was your translation to mandarin or cantonese? If you don't know, how do you know it serves the interest of your target group?

    • @chezKw
      @chezKw Před měsícem

      As a Cantonese native speaker, I can tell that although Cantonese also has its own writing system, we normally don't use it in formal situation. What you can see is the "written Chinese", defaulted to simplified Chinese, which is used in China, Malaysia, Singapore, etc.. If you target group is from Hong Kong or Tai Wan, you gotta ask it to translate to Traditional Chinese. Hope it helps.

    • @gptforwork
      @gptforwork Před 18 dny

      Hello, sorry if my example was poorly chosen and thank you for teaching me. I'll be more careful next time. You can of course input Mandarin or Cantonese instead of "Chinese".

  • @apkrishnadas
    @apkrishnadas Před 3 měsíci

    This is annoyingly the best tutorial ever...!

  • @user-wl5yn5uo1q
    @user-wl5yn5uo1q Před 3 měsíci

    In the past few months, I've used this plugin to process over 20 million tokens. It's truly an incredibly efficient tool, and words cannot express my gratitude.

  • @muneebbolo
    @muneebbolo Před 3 měsíci

    Thank you so much ♥

  • @desmosedici1272
    @desmosedici1272 Před 3 měsíci

    Thanks for this video, but I would like to know if this extension for Google Document is free or paid. or if it has a limited-time free trial.

  • @EytanMichaeli
    @EytanMichaeli Před 3 měsíci

    Hi , can you demonstrate an example of a table with two columns with numbers and I want a third column with GPT analysis about the relations between the 2 numbers in each raw

    • @gptforwork
      @gptforwork Před 18 dny

      hello, sure this can now be done by using an OpenAI assistant (we've recently integrated with them). Will make a video of it soon. Would you have an example of numbers you'd like to analyse?

  • @samuelelouest4857
    @samuelelouest4857 Před 3 měsíci

    Mw vle tandem kreyol

  • @keithkeith2106
    @keithkeith2106 Před 3 měsíci

    Is this GPT 4 ?

    • @gptforwork
      @gptforwork Před 3 měsíci

      you can use GPT-4 if you choose it yes

  • @freshfingersff
    @freshfingersff Před 4 měsíci

    What are the data privacy assurances ?

    • @gptforwork
      @gptforwork Před 3 měsíci

      Hello, this is addressed in our FAQ: gptforwork.com/help/faq/questions-word

  • @beneditagalvao3643
    @beneditagalvao3643 Před 4 měsíci

    portugues

  • @pcstream1248
    @pcstream1248 Před 4 měsíci

    WHICH RECORDER U R USING ?

  • @Mod-mi2wf
    @Mod-mi2wf Před 4 měsíci

    if we rephrase using the gpt like you showed in the video, could it be detected by Turnitin or any AI detector?

    • @gptforwork
      @gptforwork Před 4 měsíci

      It likely depends on the input and instructions you give.

  • @AJShiningThreads
    @AJShiningThreads Před 4 měsíci

    im already paying for chatgpt I dont want pay for it twice

    • @gptforwork
      @gptforwork Před 4 měsíci

      chatgpt is made by openai, we're a different company.

  • @zackempire
    @zackempire Před 4 měsíci

    Hello, just a sincere suggestion for possible future videos. Please don't zoom in to explain specific functions. That actually hinders more than it helps. It's much easier to follow all the modifications with the screen full. It would make sense if the video were smaller than 1080p, but it's up to 4k. Despite the criticism, thank you for your video.

    • @gptforwork
      @gptforwork Před 4 měsíci

      thanks for the feedback. I will turn off the automated zooming, I think I agree with you