Видео

can we do this viceversa?

11:00 - EXTREMELY USEFUL. Many thanks.

Question for you! If I have cells of a specific color that are in bultiple different rows and different columns, will this still work? or does it need to be a nice and neat column like your example in the video?

Great video. to make it even quicker you can separate each part of the name into multiple columns, to allow you to drag and copy, i.e. the main folder name then concatenate all the fields in a different cell. The concatenated cell is the one you select and copy into notepad. Hate retyping when I can copy.

Thank you for this wonderful video. Is it possible to SUM by cell color using the "Get.Cell" command?

thank you, your tutorial helped me a lot :)

RIGHT and LEFT crying in the corner

🤯

Amazing Video ♥

I like this Channel ♥ more than great really Amazing

LOVE IT!!!

Great explanation

Simply explained! Thank you!

Excellent explanation!

Pls help. What formula do I use in excel for the following: cost price + 160% (markup).

Thanks. You’ve got a beautiful voice 😂😂

Amazing tutorial first of its kind. Very useful application.

Why is it that youtube content creators keep promoting the "Reference a File" feature on youtube - the majority of the client base for these softwares on youtube audience are not corporate users (MS Copilot for 365), they regular home users. This is misleading people. Copilot is bad, generally. GPT4o still reigns.

more great more than simple

more than great

I want to thank you for this tutorial which was easy peasy but necessary. I will be watching a lot more of your videos going forward. I am an excel finatic. Every tip that's useful is a tip I need. Thank you again.

Great vid! But still wondering what's use case for GETPIVOTDATA? Since i can just create another pivot table or calculated field.

🤯

Tq!!!!!

Thanks Deb🎉

Hi this is very good instruction, but can you help me name Sheet1 after what I put in a cell? for example if I put someones name in cell D4 it changes the tab name to that persons name I typed in that cell D4? any help in that would be great.

More than great

Hello Teacher! I'm Ihsan from Pakistan & this is my 1st comment. I have been watching ur videos for the last 2 years & have gained high level knowledge of Excel from ur videos. Thank you.

I get the same "name" error

Lovely video is there any way in the same Location column I can have all my three letter country codes but have it so I can have the individual states? I don't think I can, but I thought I ask.

Damn useful :-)

Hello, I keep getting #NAME? when i do the +now0+0, is there anyway to fix this?

Im very happy I found you here in youTube! I really like how clear you teach in Alison courses :))))

I just learned that the "reference a file" feature only works with business accounts. Without it, Copilot is not going to work for me, so I'll go back to GPT-4o.

@cellmatestraining if i had a list of customers, and a list of say 5 subfolders i needed for each customer, is there a simple way to do this?

You just saved my day! Thank you

THANK YOU SO MUCH FOR SUCH A USEFULL TIPS MY DAILY WORK

Is there a way to have that backwards. Example were 1 is yellow, 2 is green & 3 is red. So when you select from the drop down list it will auto change color to it specific color and number? whithout having to individualy format for it.

Is it possible to do it by the color of the text in cell?

Awesome explanation! 💚🐏🙂

How would you do this to highlight a selected row and cell in a pivot table? I have it figured out for a sheet but the same formula won't work in a pivot table.

Let's say I have Last name, first name in a cell and I want to create folders for each person. How would I get around the space problem/creating a different folder for last name and first names? I tried to use a formula to add quotes to each but then it just thinks its part of the formula

great video. I have only been hearing your voice for the past seven months on Simon Sez IT without seeing your actual face. I have learnt a lot from your videos

Awesome, thanks! :) What if there are more then one "]"? How to choose wanted text then?

Thank you for this Professional lecture . I like your way of Teaching.

Hi Debra, love this trick, absolute timesaver! Wonder if you could help with the following: I have an aged AP in excel showing the vendor (200+ vendors) code (from accounting software) and I want to link each vendor code to the month end statement for the corresponding vendor which is saved in pdf with the vendor code in the name convention. would be grateful if you could suggest any automated ways to do this. Thank you!

thank you , it was really helpful

Terrific video as always Deb. Very helpful, thank you! 😊

Very useful tips

What is the word limit it can generate? For example could you say write me a 10k dissertation about 'the use of AI in compulsory education'.