วีดีโอ

I would like to work remotely in data entry, but with my lack of experience, I consider it important to develop my skills at home if I want to have a chance of getting a job. So, I am learning through tutorials how to manage databases. This video was extremely useful for generating sample data. You are a very good teacher. Thank you and thanks to ChatGPT too because, yes, let's praise it too!

Hi Deb, I tried to follow your tutorial but somehow it is not working and kept getting an error I am working on this formula: =IF(ISBLANK(D9),"",FILTER(tblReport,tblReport[STATUS]=D9)*(tblReport[PO NUMBER]=D11)) D9 & d11 are both drop-downs do you have a tutorial for this? thanks

It's better to ask the chat how to prepare an Excel data generator rather than ask for data. Preparing data in the Excel generator is much faster than within the chat. ;) 😅

Great video

Elevator pitch - is a topic that you should look at before posting and boring your viewers with a video, in which you tell the viewers, that you will now go to the website and show - what you might eventually talk about.

Great video, but I still believe pivot table is easier to use.

How I can do if 8 Wan the sum and the average

Hi

This tool is similar to copilot? Good morning.

You are a great teacher

Absolutely love this ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

Great Job

Very helpful :) Thank you!

Can you please do a similar group by video using drop or choose please .

Hello Deb, Thanks for the detailed video on the filter function and also the logical operators... I do struggle with them but this video has been extremely helpful to understand... Also is quite helpful in my office tasks... Keep up the great work 😊

Accurate and exhaustive. In one word:excellent

One thing, a Pivot Table is the ONLY way to report data that has more than 1,000,000 rows of data which cannot be loaded into a table.

I thought pivot tables had refresh on open function, albeit won't refresh if your data changes while workbook is open but could have a macro that periodically refreshes pivot I think

102- MERCIBEAUCOUP

Very well explained. I really like the groupby and pivotby functions, makes a lot of interesting things in my spreadsheets. But its still true, these will most likely not be used in daily operation life. There - the pivot table still wins :). I guess, mostly - people still dont learn too much of excel.

very excellant tutorial. Thank you very much..

My TH-cam algorithm has been advanced after I discovered your channel. Best

These new features are very good. Microsoft has been implementing many features in recent years that make our day-to-day life much easier! Your work is top-notch. Thanks!

Great video!

You Make It So Easy To Understand

You make it sooooo easy to understand :) Thank you.

if you needed the AI to perform a V lookup on an existing data set, can we provide that spreadsheet of data to the AI to perform the look up? if so, how would you go about doing that?🤔

Very nice tutorial. Just now subscribed.

Good video

Very nice :). Nevertheless it is not a good practice (read: very bad) to format milion rows if you have less than 20 rows in use. Sorry for pointing this out. Also i wached your video to find out what is the last argument field_relationship about and you did not mention that :/ . Why? :D

Thanks for the excellent guide. I have really benefited. I want to apply the two way index match for a dataset with first name, Last name and position. I want to match both first name and surname for it to give the position but it's giving me a Ref error

Thank you, your guidance is very helpful

Awesome! Thank you!

Great,until I saw this video, Get pivot data is a Mirage for me.thanks

Good morning from the US you are amazing I'm an accountant and I really need that

Thank you so much! just what i need

A wonderful video, slow speech, smooth flow and precise explanation. Bless you for contributing to knowledge.

That's right, there are plenty of filter videos out there but definitely not a lot of good videos discussing all the ways to use filter. This was an amazing educational video. Thank you!

Brilliant lecture! 😊 Does this work on Excel for Mac and the online (web) version of Excel?

Superb; clear, concise, comprehensive.

Awesome!! Thank you 🙏🏽

Amazing 👍🏼

Hoping I can get rid of the tabular look with outer row parent field, repeating label items

IT WORKSS ... THANKS !!!

Nice Lecture . Thank you

Cool

Thank you - very helpfull

much appreciated

Thanks 🙏🏻

Very precise and to the point information no waste of time