GPT for Work (GPT for Sheets, Docs, Excel Word)
GPT for Work (GPT for Sheets, Docs, Excel Word)
  • Видео 48
  • Просмотров 890 388
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 ...
Просмотров: 63 949

Видео

GPT for Excel: a beginner's guide (101)
Просмотров 76 тыс.4 месяца назад
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
Просмотров 2,7 тыс.Год назад
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
Просмотров 4 тыс.Год назад
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
Просмотров 5 тыс.Год назад
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
Просмотров 4,7 тыс.Год назад
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
Просмотров 2,5 тыс.Год назад
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)
Просмотров 15 тыс.Год назад
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!
Просмотров 5 тыс.Год назад
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
Просмотров 2,9 тыс.Год назад
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
Просмотров 6 тыс.Год назад
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!
Просмотров 10 тыс.Год назад
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
Просмотров 6 тыс.Год назад
How to control the execution of your GPT for Sheets functions
Creating Tables of Data in Seconds with ChatGPT
Просмотров 18 тыс.Год назад
Creating Tables of Data in Seconds with ChatGPT
Let’s compare ChatGPT and GPT-3 models with GPT for Sheets
Просмотров 2,7 тыс.Год назад
Let’s compare ChatGPT and GPT-3 models with GPT for Sheets
Clean your Google Sheets with ChatGPT
Просмотров 8 тыс.Год назад
Clean your Google Sheets with ChatGPT
Format your data in Sheets automagically with ChatGPT
Просмотров 6 тыс.Год назад
Format your data in Sheets automagically with ChatGPT
Create lists of data in Sheets with ChatGPT
Просмотров 14 тыс.Год назад
Create lists of data in Sheets with ChatGPT
How to map two columns of values in Google Sheets with ChatGPT
Просмотров 29 тыс.Год назад
How to map two columns of values in Google Sheets with ChatGPT
Polish your content with ChatGPT in Google Sheets
Просмотров 7 тыс.Год назад
Polish your content with ChatGPT in Google Sheets
Classify data in Google Sheets with ChatGPT
Просмотров 20 тыс.Год назад
Classify data in Google Sheets with ChatGPT
How to summarize text with ChatGPT in Google Sheets
Просмотров 12 тыс.Год назад
How to summarize text with ChatGPT in Google Sheets
Speedrun of GPT for Sheets
Просмотров 99 тыс.Год назад
Speedrun of GPT for Sheets
Make ChatGPT translate content in Google Sheets GPT_TRANSLATE
Просмотров 17 тыс.Год назад
Make ChatGPT translate content in Google Sheets GPT_TRANSLATE
Make ChatGPT extract entities from Google Sheets data with GPT_EXTRACT
Просмотров 12 тыс.Год назад
Make ChatGPT extract entities from Google Sheets data with GPT_EXTRACT
Make ChatGPT tag your data in Google Sheets with GPT_TAG
Просмотров 11 тыс.Год назад
Make ChatGPT tag your data in Google Sheets with GPT_TAG
How to easily call ChatGPT in Google Sheets
Просмотров 26 тыс.Год назад
How to easily call ChatGPT in Google Sheets
Generate tables of data in Google Sheets with ChatGPT
Просмотров 22 тыс.Год назад
Generate tables of data in Google Sheets with ChatGPT
ChatGPT in Sheets: how to use OpenAI temperature parameter
Просмотров 7 тыс.Год назад
ChatGPT in Sheets: how to use OpenAI temperature parameter
ChatGPT in Sheets: what are OpenAI tokens and how to use the max_tokens parameter
Просмотров 12 тыс.Год назад
ChatGPT in Sheets: what are OpenAI tokens and how to use the max_tokens parameter

Комментарии

  • @DannielleSzuba
    @DannielleSzuba 7 дней назад

    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.

  • @seizuhanaizumi9173
    @seizuhanaizumi9173 8 дней назад

    Will I be charged if I install in extension?

  • @Jesusignaciosa
    @Jesusignaciosa 11 дней назад

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

  • @malcolmklein9316
    @malcolmklein9316 12 дней назад

    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?

  • @apkrishnadas
    @apkrishnadas 18 дней назад

    This is annoyingly the best tutorial ever...!

  • @user-wl5yn5uo1q
    @user-wl5yn5uo1q 20 дней назад

    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 22 дня назад

    Thank you so much ♥

  • @desmosedici1272
    @desmosedici1272 24 дня назад

    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 26 дней назад

    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

  • @samuelelouest4857
    @samuelelouest4857 Месяц назад

    Mw vle tandem kreyol

  • @keithkeith2106
    @keithkeith2106 Месяц назад

    Is this GPT 4 ?

    • @gptforwork
      @gptforwork Месяц назад

      you can use GPT-4 if you choose it yes

  • @freshfingersff
    @freshfingersff Месяц назад

    What are the data privacy assurances ?

    • @gptforwork
      @gptforwork Месяц назад

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

  • @beneditagalvao3643
    @beneditagalvao3643 Месяц назад

    portugues

    • @gptforwork
      @gptforwork Месяц назад

      it works in portugues

  • @pcstream1248
    @pcstream1248 Месяц назад

    WHICH RECORDER U R USING ?

    • @gptforwork
      @gptforwork Месяц назад

      loom.com in this case

  • @Mod-mi2wf
    @Mod-mi2wf Месяц назад

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

    • @gptforwork
      @gptforwork Месяц назад

      It likely depends on the input and instructions you give.

  • @AJShiningThreads
    @AJShiningThreads Месяц назад

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

    • @gptforwork
      @gptforwork Месяц назад

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

  • @zackempire
    @zackempire Месяц назад

    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 Месяц назад

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

  • @KentLundgrenLarsErik
    @KentLundgrenLarsErik Месяц назад

    Thank you!

  • @sunnysideup9096
    @sunnysideup9096 Месяц назад

    hi, i want to split a long paragraph into 200-word paragraphs. Can you help me please?

    • @gptforwork
      @gptforwork Месяц назад

      please contact support

  • @CHRISTINERICHEBOEUF
    @CHRISTINERICHEBOEUF Месяц назад

    je ne parle pas anglais et je souhaiterais me servir de ChatGPT en langue française comment faire ? MERCI

    • @gptforwork
      @gptforwork Месяц назад

      bonjour, notre produit n'est pas encore disponible en français

    • @gptforwork
      @gptforwork Месяц назад

      il vous suffit d'écrire en français :)

  • @essamelgenedy
    @essamelgenedy Месяц назад

    If I need to summarize while providing specific instructions, how can I achieve that? I want to include multiple sentences in the prompt, such as providing the context of the text and brief style guide instructions. How can I do this? Similarly, how can I accomplish the same with the translate function? My kindest regards

    • @gptforwork
      @gptforwork Месяц назад

      Hello, please use the format parameter of the GPT_SUMMARIZE function as described here: gptforwork.com/help/gpt-for-sheets/gpt-functions/all-available-functions#gpt_summarize-function For translation, please use the instructions parameter of GPT_TRANSLATE as described here: gptforwork.com/help/gpt-for-sheets/gpt-functions/all-available-functions#gpt_translate-function You can also set custom instructions globally here: gptforwork.com/help/gpt-for-sheets/settings/add-custom-instructions If you need further help, please contact support support.gptforwork.com/hc/en-us/requests/new

    • @essamelgenedy
      @essamelgenedy Месяц назад

      Many thanks for the reply and for the fantastic clips!

  • @essamelgenedy
    @essamelgenedy Месяц назад

    Hi Stan

  • @getfanmedia
    @getfanmedia Месяц назад

    nice share

  • @paulinaArangomar
    @paulinaArangomar Месяц назад

    Hi! Very useful, works only in english?

    • @gptforwork
      @gptforwork Месяц назад

      no, it works in most languages :)

    • @gptforwork
      @gptforwork Месяц назад

      It works in most languages! :)

  • @mill-qo6ly
    @mill-qo6ly Месяц назад

    How do you get the bar that says GPT_LIST(promt, [value], [temperature], [max_tokens], [model])

    • @gptforwork
      @gptforwork Месяц назад

      Hello, I'm not sure I understand the question?

    • @gptforwork
      @gptforwork Месяц назад

      Hello, I'm not sure I understand the question?

  • @Lalmonte1993
    @Lalmonte1993 Месяц назад

    Interesante

  • @badmother3167
    @badmother3167 Месяц назад

    comment faire pour changer des chiffres en lettres ?

    • @gptforwork
      @gptforwork Месяц назад

      avez-vous essayer de le demander dans GPT?

  • @luerPy-kw8hu
    @luerPy-kw8hu 2 месяца назад

    really great helpful ,thank you

  • @Gamingvibesop
    @Gamingvibesop 2 месяца назад

    but middle name how to extract

    • @gptforwork
      @gptforwork Месяц назад

      could you please detail your question

  • @h0oner
    @h0oner 2 месяца назад

    Claude AI Opus support would be nice. I could also use the ability to create and save my own one-click prompts.

    • @gptforwork
      @gptforwork Месяц назад

      roger that, we'll add Claude models soon and work on one-click prompts

  • @lynnw7618
    @lynnw7618 2 месяца назад

    Wow!

  • @nikhil.singhal
    @nikhil.singhal 2 месяца назад

    Is it free or paid?

  • @link-zelda-lz
    @link-zelda-lz 2 месяца назад

    Amazing!!!

  • @AllNoti
    @AllNoti 2 месяца назад

    wow it wonderful

  • @rubal1738
    @rubal1738 2 месяца назад

    is it free?

  • @ayseozkal1208
    @ayseozkal1208 2 месяца назад

    hi I am using office 365 from my university account. Do I have to pay if I use these gpt for office

  • @abdullahesmail9681
    @abdullahesmail9681 2 месяца назад

    what version are you using?

  • @SrinxBruhYEAH
    @SrinxBruhYEAH 2 месяца назад

    It is useful but come on man, why I need to pay for everything. If it were free but with limits it would have a better welcome by everyone.

    • @gptforwork
      @gptforwork 2 месяца назад

      hi, it takes a lot of work to create this tool, why would it be free?

    • @agentsmith7947
      @agentsmith7947 2 месяца назад

      how much is it?

  • @PsychFacts-main
    @PsychFacts-main 2 месяца назад

    Apart from the tool itself, perfect video to be honest. i'm guessing he's a developer, possibly on the team that integrated this.

    • @gptforwork
      @gptforwork 2 месяца назад

      thanks a lot for the compliment! I used to be a developer, now I run the company.

  • @aakabli86
    @aakabli86 2 месяца назад

    Thats just amazing!!

  • @noorpreetkaur5075
    @noorpreetkaur5075 2 месяца назад

    It's really helpfull thankyou so much for sharing this information with us 😊💕

  • @SteveBanaszak
    @SteveBanaszak 2 месяца назад

    You go way too fast and your examples are too specific to apply on my own.

    • @gptforwork
      @gptforwork 2 месяца назад

      sorry about that. what examples would you be interested in?

  • @HanqingLi-nr1kd
    @HanqingLi-nr1kd 2 месяца назад

    so cool

  • @albertog.valencia8874
    @albertog.valencia8874 2 месяца назад

    I am trying to use the GPT_EXTRACT function and it returns this error: =GPT_EXTRACT(A59;H1;0;;"|##:##|v1_ff6e465216e5f6ca8e8b7ca255c391c4|##:##|eyJhaUh0dHBSZXNwb25zZUNvZGUiOjQwMCwiYWlSZXNwb25zZSI6eyJlcnJvciI6eyJtZXNzYWdlIjoiVGhpcyBtb2RlbCdzIG1heGltdW0gY29udGV4dCBsZW5ndGggaXMgODE5MiB0b2tlbnMuIEhvd2V2ZXIsIHlvdXIgbWVzc2FnZXMgcmVzdWx0ZWQgaW4gODc1NiB0b2tlbnMuIFBsZWFzZSByZWR1Y2UgdGhlIGxlbmd0aCBvZiB0aGUgbWVzc2FnZXMuIiwidHlwZSI6ImludmFsaWRfcmVxdWVzdF9lcnJvciIsInBhcmFtIjoibWVzc2FnZXMiLCJjb2RlIjoiY29udGV4dF9sZW5ndGhfZXhjZWVkZWQifX0sImFpSHR0cEhlYWRlcnMiOnsiY29udGVudC1sZW5ndGgiOiIyODEiLCJjb250ZW50LXR5cGUiOiJhcHBsaWNhdGlvbi9qc29uIiwiYWNjZXNzLWNvbnRyb2wtYWxsb3ctb3JpZ2luIjoiKiIsIngtY29udGVudC10eXBlLW9wdGlvbnMiOiJub3NuaWZmIiwieC1yYXRlbGltaXQtcmVtYWluaW5nLXJlcXVlc3RzIjoiODkiLCJhcGltLXJlcXVlc3QtaWQiOiI2NDVkNGZiZC1mMDcyLTRjZDAtYjFiMy1hZTBiNTEzZjk2YjkiLCJ4LXJhdGVsaW1pdC1yZW1haW5pbmctdG9rZW5zIjoiODk5ODQiLCJ4LW1zLXJhaS1pbnZva2VkIjoiZmFsc2UiLCJ4LXJlcXVlc3QtaWQiOiJmMTI1ZmRmNy1iODM5LTRlMDItODc1NC1lMDc0ODRkNTc5OTIiLCJtcy1henVyZW1sLW1vZGVsLWVycm9yLXJlYXNvbiI6Im1vZGVsX2Vycm9yIiwibXMtYXp1cmVtbC1tb2RlbC1lcnJvci1zdGF0dXNjb2RlIjoiNDAwIiwieC1tcy1jbGllbnQtcmVxdWVzdC1pZCI6IjY0NWQ0ZmJkLWYwNzItNGNkMC1iMWIzLWFlMGI1MTNmOTZiOSIsIngtbXMtcmVnaW9uIjoiRWFzdCBVUyIsImF6dXJlbWwtbW9kZWwtc2Vzc2lvbiI6ImdwdDQtMDYxMy1jMzI0Njg4ZCIsInN0cmljdC10cmFuc3BvcnQtc2VjdXJpdHkiOiJtYXgtYWdlPTMxNTM2MDAwOyBpbmNsdWRlU3ViRG9tYWluczsgcHJlbG9hZCIsImRhdGUiOiJTdW4sIDE3IE1hciAyMDI0IDE5OjU3OjMzIEdNVCIsImNvbm5lY3Rpb24iOiJjbG9zZSJ9fQ=="). Where A59 is a text copied from Google Maps listing basic data of 60 restaurants in a Madrid area, H1 is (the restaurants' address), and 0 indicates no creativity. Is this the best function for creating a table extracting restaurant name, rating, number of reviews, price, restaurant type, address, etc., from the text? Thanks

  • @JeroendeRaaf
    @JeroendeRaaf 2 месяца назад

    Can it also be the other way around? Expand the text. Where you create a prompt describing what output you want. For example. Turn two words: "Cost reduction" into a SMART objective.

    • @gptforwork
      @gptforwork 2 месяца назад

      of course, you could do =GPT("expand those words into a SMART objective", "Cost reduction")

  • @luckycharmswarrior
    @luckycharmswarrior 2 месяца назад

    This doesn't seem right. When you select the sentence at 2:30 and instruct GPT to "continue this paragraph", it simply responds with the next paragraph you already wrote. Then you insert this duplication into your paper. Were you not aware that it hadn't generated any unique content or was this redundancy intentional somehow? The only useful thing was translating into another language, but why would I use GPT tokens I have to pay for instead of a free translator that requires a simple copy/paste?

    • @gptforwork
      @gptforwork 2 месяца назад

      Very well spotted, thanks. I didn't notice that when making the video. I'm assuming this was due to the original next paragraph being included in the chat history, which messed up the prompt. We will try to improve this, although it is quite a particular corner case which shouldn't happen often. An easy way to prevent it completely for now is to clear the chat if you do continuation prompts.

    • @jjiknokn
      @jjiknokn Месяц назад

      @@gptforwork good

  • @alexanderbalakhontsev5563
    @alexanderbalakhontsev5563 2 месяца назад

    Oh yes, man, it's an amazing tool! Especially in terms of summarizing and compiling information. That really saves my poor brain

  • @franclommm
    @franclommm 2 месяца назад

    Hello, this tool is fantastic, thanks a lot. Can I ask you one question? For each URL I have in my sheet I would like chatGPT to get a summary of the content (so it should check online) and a categorisation. Any easy way I could do this?

    • @gptforwork
      @gptforwork 2 месяца назад

      hi, yes you can do this with the GPT_WEB function (pricing is $0.05 / request)

  • @user-fl4jd2kt3v
    @user-fl4jd2kt3v 2 месяца назад

    Thank you for sharing this. I need to calculate the mean and standard deviations by group in Excel and paste into a table in Word. Do you think gpt can help with this ?

    • @gptforwork
      @gptforwork 2 месяца назад

      hi there, currently that's not doable with our add-in

    • @user-fl4jd2kt3v
      @user-fl4jd2kt3v 2 месяца назад

      @@gptforwork thank you for answer.