How to Increase your Excel Skills with ChatGPT (10x Productivity 😉)
HTML-код
- Опубликовано: 8 июн 2024
- 🏆 #1 Content Generator - gravitywrite.com/
🌐 The Best Place to Host your Website - webspacekit.com/
Boost your Excel skills to new heights with ChatGPT! Discover the incredible power of getting formulas directly from ChatGPT and effortlessly implementing them in your spreadsheets/excel sheet. So without any delay Upgrade your Excel productivity like never before.
In this video, we will show you how to use ChatGPT to automate your Excel tasks.
👉 𝗚𝗲𝘁 𝟱𝟬% 𝗢𝗙𝗙 𝗢𝗡 𝘁𝗵𝗲 𝗦𝗨𝗣𝗘𝗥 𝗙𝗔𝗦𝗧 𝗪𝗼𝗿𝗱𝗣𝗿𝗲𝘀𝘀 𝗛𝗼𝘀𝘁𝗶𝗻𝗴 ➜ go.webspacekit.com/Excellwith...
🎬𝗧𝗮𝗯𝗹𝗲 𝗼𝗳 𝗰𝗼𝗻𝘁𝗲𝗻𝘁𝘀
0:00 Intro
0:35 How to find the average in excel with chatGPT
1:33 How to Organize your data in excel
2:38 How to automatically label cell based on time values
3:20 How to highlight a cell based on values in excel
4:38 Explore advance examples in excel with ChatGPT
5:53 Create Macro in excel
7:47 Compare two sheets in excel
ChatGPT is a powerful AI tool that can help you automate your Excel tasks. With ChatGPT, you can easily find the average, organize your data, label cells, highlight cells, and create macros. You can also use ChatGPT to compare two sheets and get the duplicate entries in another sheet.
If you are looking for a way to automate your Excel tasks, then ChatGPT is the perfect tool for you.
Here are some additional tips for using ChatGPT in Excel:
Use natural language to describe what you want ChatGPT to do.
Be as specific as possible when describing your task.
Use keywords that are relevant to the task you are trying to complete.
Experiment with different commands to see what ChatGPT can do.
With a little practice, you will be able to use ChatGPT to automate your Excel tasks and save time.
#ExcelProductivity #AIExcelTools #DataAnalysisAutomation #ChatGPT #MachineLearningExcel #ChartGeneration #DataVisualizationPlugin #productivityhacks
🎁 𝗧𝗼𝗼𝗹𝘀 & 𝗗𝗶𝘀𝗰𝗼𝘂𝗻𝘁𝘀
🟡 📋 GravityWrite | gravitywrite.com/
🟡 📊 WebSpaceKit | 50% off | wl.tools/webspacekit
🟡 🌐 Hostinger|10% off | Coupon: WL10|wl.tools/hostinger
🟡 🔍 Grammarly|20% off|wl.coupons/Grammarly
🟡 📈 Mangools|10% off|wl.coupons/mangools
🟡 🖼️ Astra|10% off Coupon WLDiscount|wl.coupons/Astra
🙌 𝗢𝗳𝗳𝗶𝗰𝗶𝗮𝗹𝗹𝘆:
𝗪𝗲❜𝗿𝗲 𝗛𝗶𝗿𝗶𝗻𝗴: websitelearners.com/careers/
Want your website developed by us? Email us your requirements to contact@websitelearners.com
💬 𝗙𝗼𝗹𝗹𝗼𝘄 & 𝗖𝗵𝗮𝘁 𝘄𝗶𝘁𝗵 𝘂𝘀:
Instagram ➜ / websitelearners
Facebook ➜ / websitelearners
LinkedIn ➜ / website-learners - Хобби
*🚀 Check out these tools made by Website Learners*:
😥 Save Time Let AI Write For You ➜ Visit GravityWrite.com _(Rated 4.7/5 by customers)_
⚡ Get Lightning Fast Website at WebSpaceKit ➜ WebSpaceKit.com/offer
Share the awesome Excel output you created with ChatGPT's help after watching this video! 👇 Let's see your 10x productivity in action 💪
I was just about to enroll in a course for this purpose and suddenly your video popped up. Thank you so much🙌🏼
Thank You.I Need it in This Time
I love you bro. You are tool much.
God bless you for your good work.
As always brilliant content
Man's love for sitcoms is crazy.
It's amazing in one word... Thank you so much website learner 🤩 you've won this viewer... Thank you so much 👍🏻✨
Thank you 🙏
Website learner! Amazing! 😍😍
Need more videos related to excel😊
Great insights! ChatGPT's tips offer practical ways to enhance Excel proficiency. Thank you for sharing this valuable resource!
Love the contents! Can you do link building and copywriting next pleaseee?
Amazing!
Brother this is fantastic , It is working like a magic, Thanks alot for this Wonderful informative video.
Always a fair game with 4ra, they really know how to treat bettors right 🎮👌
Nice presentation.. Thank you.
Thanks bro...I am very happy today...❤
Thanks👍
Superb superb
thanks for the video
very helpful man
Great video. Very informative
The feedback loop with 4ra is amazing, they actually listen and improve! 📣👂
Very interesting information.
Very nice technology chat gpt
Awesome 👍
Bundle of thanks for Awesome information to the point and Specific love from Pakistan ❤
Bro very nice video , it's very usefull, thanks
Thanks for sharing
Thanks for watching!
Ty
It is really amazing...I will try to do like this only ....by using chat gpt I can learn Excel formulas and ways to create report
Bro explain about HRA calculations with chatgpt integration in Excel
Nice Video bro, 👌👌
Nice video
this is ama Zing
Awesome
How in your video caption is working & where should I get from please make a video on this
First viewer.. Maa ka saki Naka.. good content Webiste Learners Team ❤
Sir, Which version of Excel is this used for doing CHATGPT?
Comparing between 2 different structured excels is possible using chartAI?
Actully to learn this i have wasted 100rs in instagram ads and wasted 3 hrs but now u can able to learn this for free and save time too
Lots of love from Bangladesh ❤🇧🇩🇧🇩♥️♥️❣️🇧🇩
🇧🇩🇧🇩
@@anntarefin3637 hlw brother.
Super yaa
It's like being a last bencher and having a first bencher friend would definitely have some advantages
I am not sure for this easy step do we even need chat gpt, when we already have option for same in excel itself , like to seperate data we have option already for data separation based on delimiter. waste of time for some cases, indeed useful for some
what version of chatgpt did you use here?
Wow
Sir, in text separated by commas ur copying one formula in chatGpt but at the time of paste diff formula is showing.
Hi , do we have any AI tool to compare images? if yes, please let us know .
We can also see yr favourite Series.
1.Data--> text to columns--> Delimiter give any separator. will give same output as chat gpt.
Average can be find simply by autosum tab in the ribbon bar
What are the benifts of prompt engineer course
is it automatic as long as you open the excell file you wanted to do the data analyzation? or do i need to upload the excell in chat gpt?
I cant english but this is very good ❤
These all are very simple any beginner can also do this without the help of ai, ai fails when with comes to a complex data .
Bro please tell me that how to create ai videos pls reply I want to ask one question
Once you know Excel I think it's easy without AI tools.
Yes it's damn easy
how will i get work sheet
Now excel already provide the AI chatgpt tool itself so need to go on the another browser tab to complete the task
Chat gpt application kaise download karte hai
Jisko excel nhi ata..uske liye thik hai…copy paste krke kam chl skta hai uska
I just tried for an hour to make it spit out a formula to add zeros somewhere specific. It trolled me for an hour with incorrect formulas.
This is something similar to Kevin stravert
=Total/no subject=avg
=Text to column
Could you please tell the formula how to delete one specific email from all the tabs of an excel sheet.
Just ctrl+F, enter email, click on find all, press ctrl+A to select all, and hit delete button, done, no formula needed.
@@DevendraKumar9 that would need to be done for all sheets
Sir, what is chat gpt! .....how can we get it to work..!!.....
Clients asked where did you get this data ?
What about subscription when you don't earn ?
00:04 Learn how to boost your Excel skills with the help of Cha GPT
01:14 Extracting and organizing data from a single column into separate columns
02:24 Extract and separate data values using formulas in Excel
03:31 Highlighting late arrivals in yellow
04:42 Quickly find and highlight late arrivals in Excel
05:49 You can search for any employee name by employee ID
07:06 Creating buttons in Excel and calculating Emi
08:25 Compare and get duplicate entries from multiple sheets in Excel.
Crafted by Merlin AI.
Can I learn chatGPT without having the knowledge of Ms Excel?
Sir can you make a video in Hindi language?
Ye Sab to sahi hai pr Bro Comma separated me jab chatgpt ne IFERROR se formula start kiya to copy karke excel me TRIM se kese start ho gya😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂
Just learn Advanced Excel than this dependence of AI for silly ones, if it was until a large data pool...AI is not necessary. Bcz you'll be incompetent if you depend on other things for simple ones. Like they say use calculator for precision, but it just makes lazy and dumb every day forgetting the simple math calculation for how much change to collect from vegetable vendor after giving 500Rs note.
But we can do with flash fill
You're silly enough to learn advanced excel to use on small amount of datas.. we work on huge amount of datas
@@kavithakarthkeyan1695 it's not silly . I also use this formula for very large data . There are 20000 rows + 100 plus columns.
Off course just silly because of the ai tool we might forget much from ms excel.
Ur frustrated
Time consuming -100X productivity 😅😅😅😅😅
So think vlookup is advance
Now the time has come that no one need to know any thing except English and how to elaborate what you want from AI to do.
na man not working
Default concepts wont help for working professional in excel !! Without the human skill and knowledge AI cant help for the exact particular thing !! You just cant go and copy the formulas to get the required results as showing in this video !! Its wont workout in the reality!!!
Sir ji thodi Hindi bol liya Karo ji
Arya stark got 90 marks average 😂
formula shown by ChatGPT is different than yours in the case of text to Columns....this is misguiding video. Pause at 2:16 and 2:23, see it by urself.
Time consuming
This is making humans dummies 🤣.. Use own mind for small formulas and type it by yourself instead of asking a bot .
making video chatgpt+excel is pointless as everybody knows chatgpt is damn easy...
Most worst things
*Useless...*
Worst video 😂😂 using chat gpt to do google search 😂😂
copycat
Can I have the WhatsApp number to enroll in classes
Love the contents! Can you do link building and copywriting next pleaseee?
😂