Пікірлер
@TonySon55
@TonySon55 Сағат бұрын
It is not your Pivot Tables people come here to learn, it is your "sexy thumbnails" which people get attracted to. Hahahahaha !
@saifullahalatif
@saifullahalatif 20 сағат бұрын
WOWWW SUPEEERRR Helpful thank you so much
@sukhiparmar
@sukhiparmar Күн бұрын
Hi
@jayaramanonda
@jayaramanonda Күн бұрын
good educative
@ayyazryk2815
@ayyazryk2815 Күн бұрын
I wished you should have attached the sample excel file for working
@bernpatton8966
@bernpatton8966 Күн бұрын
I followed this but I get only 'Function is invalid'
@cellmatestraining
@cellmatestraining Күн бұрын
@@bernpatton8966 which version of Excel are you using? FILTER is only available on M365 and Excel 2021.
@klaudiakacperczyk9087
@klaudiakacperczyk9087 2 күн бұрын
Omg this is great , you are great - impressive work! I think this is my first comment on youtube since few years - worth it!
@AgbaraSteve
@AgbaraSteve 2 күн бұрын
👍
@obinnaamakor2944
@obinnaamakor2944 3 күн бұрын
Wow! So glad to have come across this. Learnt a lot 😁.
@cellmatestraining
@cellmatestraining 3 күн бұрын
That means a lot-glad you found them useful!
@hankabeEhub
@hankabeEhub 10 күн бұрын
This is awesome and on point
@cellmatestraining
@cellmatestraining 3 күн бұрын
Thank you!
@MarlonBHall
@MarlonBHall 10 күн бұрын
@4:12 is actually great practice for beginners. Its good to know how to quickly clean and sort raw data in Excel.
@sonerguney3225
@sonerguney3225 10 күн бұрын
Super❤
@cellmatestraining
@cellmatestraining 3 күн бұрын
Thanks 🔥
@rameshhariharan2623
@rameshhariharan2623 11 күн бұрын
this is great mam. im learing
@cellmatestraining
@cellmatestraining 11 күн бұрын
Excellent!
@ANA-db9yn
@ANA-db9yn 11 күн бұрын
@cellmatestraining Thank you 🙏 You are really a gift from heaven ❤️
@cellmatestraining
@cellmatestraining 11 күн бұрын
Wow thank you!
@fangsunny7604
@fangsunny7604 11 күн бұрын
Its so easy tp understand😊❤thank you so much!!!
@cellmatestraining
@cellmatestraining 11 күн бұрын
You’re very welcome!
@komagank631
@komagank631 11 күн бұрын
Thanks so much. This is great for people without large dataset. Very cool to discover what AI can do.
@cellmatestraining
@cellmatestraining 11 күн бұрын
Absolutely! :)
@westleyempeigne6541
@westleyempeigne6541 13 күн бұрын
Great explanation Deb! Didn’t know we can use - and = operators
@cellmatestraining
@cellmatestraining 11 күн бұрын
Yes! Pretty cool, huh? :)
@ritwickgoswami8187
@ritwickgoswami8187 14 күн бұрын
Your tutorials are amazing!! Super helpful
@cellmatestraining
@cellmatestraining 11 күн бұрын
Thanks so much! :)
@lyle6699
@lyle6699 16 күн бұрын
i tried. it said #value
@hissabis2068
@hissabis2068 17 күн бұрын
Thanks
@cellmatestraining
@cellmatestraining 15 күн бұрын
You’re welcome!
@markdoswell8262
@markdoswell8262 17 күн бұрын
Thank you for the excellent tutorial. Apart from the CHATGPT aspect, I also learnt that my way of working with Excel is pedestrian in parts and can be improved. Yes, I am a new subscriber 😊
@cellmatestraining
@cellmatestraining 15 күн бұрын
Great! Welcome to the channel! :)
@thomasw.857
@thomasw.857 18 күн бұрын
Very useful! Thank you so much.
@cellmatestraining
@cellmatestraining 11 күн бұрын
You’re welcome!
@WillS-r2018m
@WillS-r2018m 19 күн бұрын
Love your youtube name
@cellmatestraining
@cellmatestraining 11 күн бұрын
Haha thank you!
@yousefaliali-j2b
@yousefaliali-j2b 19 күн бұрын
amazing your way in explaination is wonderful
@cellmatestraining
@cellmatestraining 19 күн бұрын
Thank you so much!
@VishalKumar-kv3dp
@VishalKumar-kv3dp 20 күн бұрын
Absolutely killer this time....! I am so very excited to see the possibilities CHAT GPT provides us vis-a-vis Excel. Thanks a lot Ma'am.
@cellmatestraining
@cellmatestraining 19 күн бұрын
Absolutely! Thank you for watching :)
@samuelsule9363
@samuelsule9363 20 күн бұрын
This is great. Thanks for sharing.
@cellmatestraining
@cellmatestraining 19 күн бұрын
You’re very welcome!
@hendriknieuwenhuizen4397
@hendriknieuwenhuizen4397 22 күн бұрын
I have a problem following the curser. You move too quickly.
@cellmatestraining
@cellmatestraining 19 күн бұрын
Noted.
@nibzy6803
@nibzy6803 24 күн бұрын
I started with the chat GPT out of interest and ended up binge watching whatever came next. Thank you for the clear teaching method and delivery. Well-deserved subscription.
@cellmatestraining
@cellmatestraining 19 күн бұрын
Thank you so much!
@DavidSoden
@DavidSoden 25 күн бұрын
I still use mockaroo and its free up to 1000 rows. So many uses and makes great mock api's too if your into that. Great content overall! Thanks for your hard work!
@cellmatestraining
@cellmatestraining 19 күн бұрын
Yes I used to use mockaroo but I’ve switched to AI now! Thank you for your kind words :)
@olgapalenzuela-king9172
@olgapalenzuela-king9172 27 күн бұрын
I hadn't worked on Excel in years and I'm amazed at what you just taught us all. Thank you.
@cellmatestraining
@cellmatestraining 20 күн бұрын
Glad it was helpful!
@lisetteruiz6082
@lisetteruiz6082 28 күн бұрын
Wow, this was such a clear and insightful explanation! You really made the topic easy to understand-thank you for sharing your knowledge!
@cellmatestraining
@cellmatestraining 27 күн бұрын
Glad you enjoyed it!
@Rice0987
@Rice0987 28 күн бұрын
I think next time it would be better to flip picture horizontally.🤗
@cellmatestraining
@cellmatestraining 19 күн бұрын
🤣
@DjBobbyK-oz
@DjBobbyK-oz 28 күн бұрын
Hi, tried to copy what your doing but I am not getting my folders. I see the batch file run but no folders. I am using an older version of Excel from 2000. I wanted to create folders for my record collection I have listed in Excel. I wanted the folder to look like this. My columns are as follows. YEAR - ARTIST - TITLE - CATALOG # and would like the folders to resemble this but with the actual names of my collection. Any help with the formula I would appreciate it
@cellmatestraining
@cellmatestraining 19 күн бұрын
I’m not sure if it works on such an old version of Excel.
@DjBobbyK-oz
@DjBobbyK-oz 11 күн бұрын
@@cellmatestraining I figured it out. A little bit different way but it does work with the older version Thanks for getting back to me
@isholakayode191
@isholakayode191 28 күн бұрын
Thanks, Ashby. Appreciation for all your effort. I would love it if you could do a live event where you will perform a complete data analysis step by step. Cos your videos have shaped and elevated my skills a lot. I just need a live event where you would give explicit explanations on each step on the dataset used. I would appreciate this a lot for myself now and in the future. Gracias
@iankr
@iankr 28 күн бұрын
Brilliant! Many thanks. Very clearly explained. 🙂
@cellmatestraining
@cellmatestraining 27 күн бұрын
You're very welcome!
@mwferg05
@mwferg05 28 күн бұрын
Two things that I wished you would have covered as well is the difference between the Summary vs. Pivot Table and also, if it is possible to re-arrange the Scenarios or if it is dependent on the order of creation. I Finally, I feel that this is an under utilized tool in Excel.
@dogzrgood
@dogzrgood 28 күн бұрын
I saw your Sharepoint video on SimonSezIT. Great work :)
@FitnessFoodRecipes
@FitnessFoodRecipes 28 күн бұрын
Great tutorial Deb! I always use ChatGPT to generate unique datasets, alternatively I just use Kaggle.
@walterk1963
@walterk1963 29 күн бұрын
The date column remained mixed even after two GPT tries.
@hasupagla7804
@hasupagla7804 29 күн бұрын
professional ❤
@jamesmurphy6018
@jamesmurphy6018 29 күн бұрын
Such a great video. The feature to help create multiple named files from Excel turned my 3-hour task into a 10-minute task! Thank you very much and I hope to get stuck into more of your videos :)
@cellmatestraining
@cellmatestraining 19 күн бұрын
You’re welcome!
@mssh2225
@mssh2225 Ай бұрын
INCREDIBLE THANK YOU VERY VERY MUCH
@cellmatestraining
@cellmatestraining 27 күн бұрын
Glad you like it!
@sm-journey8281
@sm-journey8281 Ай бұрын
Tnx a ton! 🤩
@francesdobbins2964
@francesdobbins2964 Ай бұрын
I didn't know ChatGPT 4o had a free version? I use the free ChatGPT 3.5 version. This is an excellent video. Thank you.
@louiseshorten9389
@louiseshorten9389 Ай бұрын
Great video thanks so much!!!
@cellmatestraining
@cellmatestraining Ай бұрын
Glad it was helpful!
@Kamal5Kishore5
@Kamal5Kishore5 Ай бұрын
Fantastic tool, would love to learn more on how to use in depth.
@vaidhyasiv
@vaidhyasiv Ай бұрын
Good explanation, I am benefitted by this tutorial. Thanks
@cellmatestraining
@cellmatestraining Ай бұрын
Glad to hear that
@POPPYCHAUN
@POPPYCHAUN Ай бұрын
Is anyone else running into ChatGPT limits when trying this, or being advised that they need to upgrade to the paid model to be able to continue?
@ultrasonic-i4s
@ultrasonic-i4s Ай бұрын
Extremely informative video. Thanks a lot mam for your brilliant ideas you shared. Regards
@cellmatestraining
@cellmatestraining 15 күн бұрын
Thanks for watching!
@MrCHATTERJEE01
@MrCHATTERJEE01 Ай бұрын
excellent tutorial 😊 🙏