You are incredible! Thank You So Much!

They need to include on event/ sheet triggers from VBA to typescript. Google sheet offers better script triggers compared with MS.

I tried 2 of the 3 excel charts and they came out so beautiful. Thanks Leila.

As you asked for an Idea: 1. asset request form: I have a MS-Form having field EmpID, RequestType, and Item list and now As user clicks on Submit button it should check first that entered email id in form is exist in masterdata set placed in somewhere in excelTable with column EmpID listed. and it it matches than send email to manager1 to approve and if this is approve than it should send email to Manager2 and IF in first step Email ID does not exist in dataset it should send an email or notify on form.

This is definitely advanced. I thought I was an advanced user, but I did not know Excel could do this.

sister you're so excellent In excel and then dynamic

No and thank you

i CANT FIND THE CHECKBOX IN INSERT!

Wow! Leila, you are the best

If only it was available to use ... in Beta Channel and still no access!!! MS have completely botched this release.

"First I'm taking a sip of coffee" ...dayam the arrogance....I love it!

Help! Surely one can use Lambda and it's recursive nature to create a Goal-Seek function. All searches fall short.

How would you get round when the last day of the month is the last Monday of the the month. In this case, the WeekNo should return 1, but it returns 5, meaning there is no week 1 in October 2024. Happens every time there is this condition.

Dear Leila, I learnt Power Query through your videos and have basic BI skills, but now thanks to your videos I will expand my skills further. You are brilliant, truly grateful

Is it possible to print all (from drop down list) to a single pdf file ?

You just gave me what I needed, been trying to figure how to use the criteria

Brilliant as usual

You explain things well. Thank you.

Awesome video🎉

This is a powerful addition, nice to see Excel continue evolving

Not an experienced user, doesn't NOW formula just keep advancing, or does it only account for the instance of time when an action occurs? Is it something new that has to do with the iterative option? I remember once using a worksheet that used to do this with scripts but it was nightmare when someone messed it up. Plus the constructed checkboxes really didn't look as clean, it's awesome that Excel is finally adding it.

Hi I need to export data from word files in to excel how we gonna do that

Great speech by our future President Donald Trump

The most important setting about Windows 10 or 11 is not to install them

Hi. I have a problem. My sheet have too many lines. like, 100.000 lines. ImportRange do not like. I use something like this so solve it: ={IMPORTRANGE(URL; DATA!A2:M30000); IMPORTRANGE(URL; PLANILHAS!DATA!A30001:M60000), IMPORTRANGE(URL; PLANILHAS!DATA!A60001:M90000)} There are many other sheets to add. Each one grows for it self. I want to create a function to automatic add all the URLs and data string. The data string is ok. If the sheet have 50.000 lines, a calculate a range like DATA!A2:M30000 and DATA!A30001:M50000. Easy. Here where I stop... I want something like this: The data strings are in C2:F2 ={MAP(C2:F2; LAMBDA(LINHAS;IMPORTRANGE(URL; LINHAS)))} Any ideas?

You can 'access teams'

Isn't this available in office 2021? I can not find the checkbox icon in the ribbon. Can i add it somehow?

Thank you so much <3

Can gmail be used instead of outlook?

Great stuff. How do you do this when there isn't a next page button and the other items in the list appear after scrolling down the page? So you aren't clicking next page but scrolling down to view the rest of the list. For example, It does this on KZfaq when going onto someone's channel and scrolling the list of videos. If I want to scrape the data of the video titles, it only picks the titles up to the point where you need to scroll down to view the rest of the page. Saying if there are 200 videos, it only picks up 30 even though you've recorded the whole page

Wow just wow❤

Thanks a lot, always your videos are useful to my work. greetings from Chile.

Thank you very much, if you please can you make this by xlookup function instead of Offset function or what to put in this formula XLOOKUP(F3;Sheet2!$A$2:$H$2;Sheet2!$A$3:$H$8) to prevent empty rows showing. Is there a way to remove the blank rows in the data validation?

Thanks Leila for those tips!

How can we create drill through for individual data points of Matrix visual in power BI?

This proudly sponsered by Oros, pineapple flavour 😋

Helpful video ❤

Pov : you done a project but you forgot save project Shutdown : HAHA I'll close program any thing and don't save your project Hibernate : I'll save your task after hibernate

whats about version of Excel?

Love this! thanks Struggling to get the Bar chart part working. I've tried every combo of emoji boxes. Is it a spacing thing?

onedriver shared excel files multiple Users can edit select sheets User 1 (Sheet1): Set permissions to Can View & Edit for Sheet1 and user 2 only view seam think Sheet2 permissions to Can View & Edit User 2 (Sheet2): User 1 Can View only for Sheet2 and Canot Edit for Sheet2. Please have any solution this topic

Amazing !!

make a video on how to automate like MS software request form and send approval request to manager automatically.

How to solve this in table. I have used filter and now I want to use that data in table but I can't because I get spill error.

gotta love the creativity of how to make even a tutorial fun to watch and learn!

thanks dok, kau memang terbaik

Holy sheet! That's great.

Be careful. Data from China is not reliable.

IHi, Leila! I am having an issue with this function displaying #value when all entry are marked received (=CHOOSECOLS(FILTER(Orders[[Date]:[Amount]],(Orders[Date]>=G14)*(Orders[Date]<=H14)*(Orders[Company]=B5)*(Orders[Payment]=H13),"All paid"),1,6,8,12,13,15,16)) the text "all paid" never shows up. Can you please help me find where the fault is? Thanks in advance

Do you use a Surface Laptop to work swiftly on MS 365 essential apps like Word, Excel, PowerPoint, OneNote, etc.? If not, which one would you recommend?