- Видео 48
- Просмотров 890 388
GPT for Work (GPT for Sheets, Docs, Excel Word)
Добавлен 21 май 2021
Like ChatGPT? Imagine having it in Google Sheets, Google Docs, Microsoft Word and Microsoft Excel! 🤠
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.
💡Website: gptforwork.com
🛟Help: gptforwork.com/help
This channel is brought to you by Talarian: talarian.io
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.
💡Website: gptforwork.com
🛟Help: gptforwork.com/help
This channel is brought to you by Talarian: talarian.io
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 ...
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
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
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.
Will I be charged if I install in extension?
Estimado, donde puedo ver estos tutoriales en español???
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?
This is annoyingly the best tutorial ever...!
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.
Thank you so much ♥
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.
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
Mw vle tandem kreyol
Is this GPT 4 ?
you can use GPT-4 if you choose it yes
What are the data privacy assurances ?
Hello, this is addressed in our FAQ: gptforwork.com/help/faq/questions-word
portugues
it works in portugues
WHICH RECORDER U R USING ?
loom.com in this case
if we rephrase using the gpt like you showed in the video, could it be detected by Turnitin or any AI detector?
It likely depends on the input and instructions you give.
im already paying for chatgpt I dont want pay for it twice
chatgpt is made by openai, we're a different company.
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.
thanks for the feedback. I will turn off the automated zooming, I think I agree with you
Thank you!
hi, i want to split a long paragraph into 200-word paragraphs. Can you help me please?
please contact support
je ne parle pas anglais et je souhaiterais me servir de ChatGPT en langue française comment faire ? MERCI
bonjour, notre produit n'est pas encore disponible en français
il vous suffit d'écrire en français :)
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
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
Many thanks for the reply and for the fantastic clips!
Hi Stan
hi!
hi!
@@gptforwork You are an exceptional person!
nice share
Hi! Very useful, works only in english?
no, it works in most languages :)
It works in most languages! :)
How do you get the bar that says GPT_LIST(promt, [value], [temperature], [max_tokens], [model])
Hello, I'm not sure I understand the question?
Hello, I'm not sure I understand the question?
Interesante
comment faire pour changer des chiffres en lettres ?
avez-vous essayer de le demander dans GPT?
really great helpful ,thank you
but middle name how to extract
could you please detail your question
Claude AI Opus support would be nice. I could also use the ability to create and save my own one-click prompts.
roger that, we'll add Claude models soon and work on one-click prompts
Wow!
Is it free or paid?
paid
Amazing!!!
wow it wonderful
Thank you! Cheers!
is it free?
no it is not free
hi I am using office 365 from my university account. Do I have to pay if I use these gpt for office
yes you do
what version are you using?
version of what?
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.
hi, it takes a lot of work to create this tool, why would it be free?
how much is it?
Apart from the tool itself, perfect video to be honest. i'm guessing he's a developer, possibly on the team that integrated this.
thanks a lot for the compliment! I used to be a developer, now I run the company.
Thats just amazing!!
It's really helpfull thankyou so much for sharing this information with us 😊💕
You go way too fast and your examples are too specific to apply on my own.
sorry about that. what examples would you be interested in?
so cool
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
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.
of course, you could do =GPT("expand those words into a SMART objective", "Cost reduction")
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?
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.
@@gptforwork good
Oh yes, man, it's an amazing tool! Especially in terms of summarizing and compiling information. That really saves my poor brain
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?
hi, yes you can do this with the GPT_WEB function (pricing is $0.05 / request)
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 ?
hi there, currently that's not doable with our add-in
@@gptforwork thank you for answer.