How to Increase your Excel Skills with ChatGPT (10x Productivity 😉)
Vložit
- čas přidán 19. 06. 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 - Jak na to + styl
*🚀 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🙌🏼
It's amazing in one word... Thank you so much website learner 🤩 you've won this viewer... Thank you so much 👍🏻✨
Thank You.I Need it in This Time
As always brilliant content
I love you bro. You are tool much.
God bless you for your good work.
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?
Need more videos related to excel😊
Brother this is fantastic , It is working like a magic, Thanks alot for this Wonderful informative video.
Thank you 🙏
Website learner! Amazing! 😍😍
The feedback loop with 4ra is amazing, they actually listen and improve! 📣👂
Thanks bro...I am very happy today...❤
Nice presentation.. Thank you.
Bundle of thanks for Awesome information to the point and Specific love from Pakistan ❤
Amazing!
thanks for the video
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
Great video. Very informative
very helpful man
Thanks👍
Very interesting information.
Very nice technology chat gpt
Bro very nice video , it's very usefull, thanks
Superb superb
Sir, Which version of Excel is this used for doing CHATGPT?
Awesome 👍
Bro explain about HRA calculations with chatgpt integration in Excel
How in your video caption is working & where should I get from please make a video on this
Nice Video bro, 👌👌
Thanks for sharing
Thanks for watching!
Ty
Comparing between 2 different structured excels is possible using chartAI?
Nice video
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
Awesome
First viewer.. Maa ka saki Naka.. good content Webiste Learners Team ❤
Lots of love from Bangladesh ❤🇧🇩🇧🇩♥️♥️❣️🇧🇩
🇧🇩🇧🇩
@@anntarefin3637 hlw brother.
Always a fair game with 4ra, they really know how to treat bettors right 🎮👌
1.Data--> text to columns--> Delimiter give any separator. will give same output as chat gpt.
this is ama Zing
what version of chatgpt did you use here?
Sir, in text separated by commas ur copying one formula in chatGpt but at the time of paste diff formula is showing.
Man's love for sitcoms is crazy.
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
Super yaa
Wow
It's like being a last bencher and having a first bencher friend would definitely have some advantages
Average can be find simply by autosum tab in the ribbon bar
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?
We can also see yr favourite Series.
Bro please tell me that how to create ai videos pls reply I want to ask one question
Hi , do we have any AI tool to compare images? if yes, please let us know .
What are the benifts of prompt engineer course
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 .
I cant english but this is very good ❤
Once you know Excel I think it's easy without AI tools.
Yes it's damn easy
Now excel already provide the AI chatgpt tool itself so need to go on the another browser tab to complete the task
Sir, what is chat gpt! .....how can we get it to work..!!.....
how will i get work sheet
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
Chat gpt application kaise download karte hai
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😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂😂
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.
=Total/no subject=avg
=Text to column
This is something similar to Kevin stravert
Can I learn chatGPT without having the knowledge of Ms Excel?
Jisko excel nhi ata..uske liye thik hai…copy paste krke kam chl skta hai uska
What about subscription when you don't earn ?
Clients asked where did you get this data ?
Sir can you make a video in Hindi language?
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.
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
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!!!
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.
Sir ji thodi Hindi bol liya Karo ji
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.
na man not working
Arya stark got 90 marks average 😂
This is making humans dummies 🤣.. Use own mind for small formulas and type it by yourself instead of asking a bot .
Time consuming
Most worst things
making video chatgpt+excel is pointless as everybody knows chatgpt is damn easy...
*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?
😂