It is not your Pivot Tables people come here to learn, it is your "sexy thumbnails" which people get attracted to. Hahahahaha !
@saifullahalatif20 сағат бұрын
WOWWW SUPEEERRR Helpful thank you so much
@sukhiparmarКүн бұрын
Hi
@jayaramanondaКүн бұрын
good educative
@ayyazryk2815Күн бұрын
I wished you should have attached the sample excel file for working
@bernpatton8966Күн бұрын
I followed this but I get only 'Function is invalid'
@cellmatestrainingКүн бұрын
@@bernpatton8966 which version of Excel are you using? FILTER is only available on M365 and Excel 2021.
@klaudiakacperczyk90872 күн бұрын
Omg this is great , you are great - impressive work! I think this is my first comment on youtube since few years - worth it!
@AgbaraSteve2 күн бұрын
👍
@obinnaamakor29443 күн бұрын
Wow! So glad to have come across this. Learnt a lot 😁.
@cellmatestraining3 күн бұрын
That means a lot-glad you found them useful!
@hankabeEhub10 күн бұрын
This is awesome and on point
@cellmatestraining3 күн бұрын
Thank you!
@MarlonBHall10 күн бұрын
@4:12 is actually great practice for beginners. Its good to know how to quickly clean and sort raw data in Excel.
@sonerguney322510 күн бұрын
Super❤
@cellmatestraining3 күн бұрын
Thanks 🔥
@rameshhariharan262311 күн бұрын
this is great mam. im learing
@cellmatestraining11 күн бұрын
Excellent!
@ANA-db9yn11 күн бұрын
@cellmatestraining Thank you 🙏 You are really a gift from heaven ❤️
@cellmatestraining11 күн бұрын
Wow thank you!
@fangsunny760411 күн бұрын
Its so easy tp understand😊❤thank you so much!!!
@cellmatestraining11 күн бұрын
You’re very welcome!
@komagank63111 күн бұрын
Thanks so much. This is great for people without large dataset. Very cool to discover what AI can do.
@cellmatestraining11 күн бұрын
Absolutely! :)
@westleyempeigne654113 күн бұрын
Great explanation Deb! Didn’t know we can use - and = operators
@cellmatestraining11 күн бұрын
Yes! Pretty cool, huh? :)
@ritwickgoswami818714 күн бұрын
Your tutorials are amazing!! Super helpful
@cellmatestraining11 күн бұрын
Thanks so much! :)
@lyle669916 күн бұрын
i tried. it said #value
@hissabis206817 күн бұрын
Thanks
@cellmatestraining15 күн бұрын
You’re welcome!
@markdoswell826217 күн бұрын
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 😊
@cellmatestraining15 күн бұрын
Great! Welcome to the channel! :)
@thomasw.85718 күн бұрын
Very useful! Thank you so much.
@cellmatestraining11 күн бұрын
You’re welcome!
@WillS-r2018m19 күн бұрын
Love your youtube name
@cellmatestraining11 күн бұрын
Haha thank you!
@yousefaliali-j2b19 күн бұрын
amazing your way in explaination is wonderful
@cellmatestraining19 күн бұрын
Thank you so much!
@VishalKumar-kv3dp20 күн бұрын
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.
@cellmatestraining19 күн бұрын
Absolutely! Thank you for watching :)
@samuelsule936320 күн бұрын
This is great. Thanks for sharing.
@cellmatestraining19 күн бұрын
You’re very welcome!
@hendriknieuwenhuizen439722 күн бұрын
I have a problem following the curser. You move too quickly.
@cellmatestraining19 күн бұрын
Noted.
@nibzy680324 күн бұрын
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.
@cellmatestraining19 күн бұрын
Thank you so much!
@DavidSoden25 күн бұрын
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!
@cellmatestraining19 күн бұрын
Yes I used to use mockaroo but I’ve switched to AI now! Thank you for your kind words :)
@olgapalenzuela-king917227 күн бұрын
I hadn't worked on Excel in years and I'm amazed at what you just taught us all. Thank you.
@cellmatestraining20 күн бұрын
Glad it was helpful!
@lisetteruiz608228 күн бұрын
Wow, this was such a clear and insightful explanation! You really made the topic easy to understand-thank you for sharing your knowledge!
@cellmatestraining27 күн бұрын
Glad you enjoyed it!
@Rice098728 күн бұрын
I think next time it would be better to flip picture horizontally.🤗
@cellmatestraining19 күн бұрын
🤣
@DjBobbyK-oz28 күн бұрын
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
@cellmatestraining19 күн бұрын
I’m not sure if it works on such an old version of Excel.
@DjBobbyK-oz11 күн бұрын
@@cellmatestraining I figured it out. A little bit different way but it does work with the older version Thanks for getting back to me
@isholakayode19128 күн бұрын
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
@iankr28 күн бұрын
Brilliant! Many thanks. Very clearly explained. 🙂
@cellmatestraining27 күн бұрын
You're very welcome!
@mwferg0528 күн бұрын
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.
@dogzrgood28 күн бұрын
I saw your Sharepoint video on SimonSezIT. Great work :)
@FitnessFoodRecipes28 күн бұрын
Great tutorial Deb! I always use ChatGPT to generate unique datasets, alternatively I just use Kaggle.
@walterk196329 күн бұрын
The date column remained mixed even after two GPT tries.
@hasupagla780429 күн бұрын
professional ❤
@jamesmurphy601829 күн бұрын
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 :)
@cellmatestraining19 күн бұрын
You’re welcome!
@mssh2225Ай бұрын
INCREDIBLE THANK YOU VERY VERY MUCH
@cellmatestraining27 күн бұрын
Glad you like it!
@sm-journey8281Ай бұрын
Tnx a ton! 🤩
@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Ай бұрын
Great video thanks so much!!!
@cellmatestrainingАй бұрын
Glad it was helpful!
@Kamal5Kishore5Ай бұрын
Fantastic tool, would love to learn more on how to use in depth.
@vaidhyasivАй бұрын
Good explanation, I am benefitted by this tutorial. Thanks
@cellmatestrainingАй бұрын
Glad to hear that
@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Ай бұрын
Extremely informative video. Thanks a lot mam for your brilliant ideas you shared. Regards