Відео

Hi Leila, thank you for a clear & useful video! could you please make a tutorial on how to edit the text on the image please? for example when ai generated an incorrect spelling, how can we edit it on photopea? thanksss

Thank you Leila, great topic as always

wow thank you for the informative video

Thank you for this great video. Made a big difference for me. The only problem I am having is when it sends the pdf and I open the pdf in email, I get it blank. Please help!!

You have no idea how refreshing this is to grasp this kind of information. This video saves a lot of time learning the necessary information compared to some college courses.

It's amazing. Best wishes for you.

super helpful

I using outlook 2013, i can't found data tabs there got Microsoft Exchange. Kindly advise. Thank you

I do not why but I can not use the keyboard shortcuts for headers and tags. What can I do to solve this issue?

Can this method be used if you want to direct certain people to different email addresses ie you have one group of people that need to contact one person and another group that should contact a different person. I need to do this for multiple groups.

this video was sooooo helpful and inspiring!!!

I have 365 but I can’t work out how to add the insert checkbox function to my ribbon. I can’t see it in excel options customise ribbon. Can you help?

Question!! Is there a way to have the TEXTSPLIT formula on the same cell as the text I want to start? Or is it the formula can't be in A2 and have my text to format also in A2?

The right instructors are the key to learning. I learned more out of this video than an 8 hour class. Clear, simple, clean and with the right amount of content for a beginner to get started. I had to subscribe.

I can't seem to share my excel file to other people. They only need to refresh the excel, but I can't enable them that.

i cant find microsoft exchange option after going to get data , other sources then there are bunch of options except microsoft exchange please guide .

the best excel tutor love all your vidoes

so beautiful and smart thank you for the content cant wait to join

Great Stuff! THANKS!!

Thank you for this. I've been searching the comments, but how can I replace the decimal showing as 67/100, for example and make it say 67 cents?

But extra -- credit = Saudi & Egypt -- modern money laundry -- in US(hamserica!) Marines -- 100% Saudi intel -- life

You can start -- bin and - variable it - for end! Python u Excel -- Stachon! And in -- cell fuse -- moles <<< 2''kf ~tmp arch U email Vd LN'' <TD(x2''frq chn)>!

/Z(p''t2'x |prnt||rRvk4'') <thrm eml td(X'zpn)> < wn crtz/ /<~tmp + k frch paavlow xy''X'(p''Z abv TJZ')+ K' wn crtz/ /intrprtv 70s by P'WVfjz' fraud US brth crtx wth NAVAJTX' ZP' cntnt/

Hi Leila, I use excel 365 Mac, updated yesterday and I do not have any of these new features. Any suggestions on how to add them?

Thank you so much... With due respect, I love you❤and your work

And this is just using MS Teams. If like most organisations your web traffic traverses a proxy to access the internet, they can see every website visited, the category of those sites, etc

Nice video, thank you. The FATAL flaw of Google Sheet is that it doesn't have Data Table like excel, unfortunaly that's too big of a problem to just overlook and it undermines everything else that google sheets can do... The day they'll put data table in google sheets... that will be a memorable day

From Where is the small window “import data” opened up?

Leila thankyou so much for all your videos. You are my goto.. Thank you for making me smarter.

I've multiple sheet having same format except some sheets hv extra columns. Can i merge all the data into a single sheet??

There's also, confusingly, a different version of OneNote with 64 bit Office and 32 bit Office. Oddly, the 32 bit version looks more modern.

good video

Does anyone know if 3d formulas works for Openoffice Calc? Alguien sabe si 3d formulas funciona para Calc de Openoffice?

How do I sign up for “Between the Sheets”? 😍📊

I have an issue and want a solution. I have a chart like waves for prices of one company stock and I want to show on the chart only values of top unique value and down unique value for each wave I made a helper column and used the formula>> IF(AND(F4>F3,F4>C5),C4,"") but the problem there is a similar number at the top and down wave

I have quite a complicated if formula to do and would really appreciate the help with it. Would you mind if I email you the scenario's please...

Hi Leila, I do not see the option Import Data from Web. I am using version 16.77 of MS Excel 365 subscription. Help please. Thanks

great feature, but I guess it only works on text? Because I want to split date information that is now in one cell (date and time in date formatting) to seperate date and time columns. Like to hear if you can make that work!

You're a great teacher and I will follow up with you all the way an again thank you

Many thanks

This makes life easy.

Thanks, That helped a lot! One more thing I noticed is that this works when the range to be locked is only at the beginning of my data set, like column A:A or A:B, if it is located somewhere in the middle of my data range, the lock did not work with me. For ref.: I used that in MS Excel 365 on the cloud.

This is really helpful! Thanks. I have a question for you, is there a way to utilize the TextSplit function and identify the delimiter as a character following another character? Here is my challenge: I am trying to utilize receipt data from Walmart, but the format isn't easy to work with it is just 1 long string with spaces and commas. I would like to split this data into rows, the area to split is the next SPACE following the $.Data example is below: (I am trying to make 3 rows, starting with the item descriptions and ending with the cost.) Fresh Whole Red Onion, Each Weight-adjusted Qty 1 $0.91 Fresh Strawberries, 1 lb Container Weight-adjusted Qty 1 $2.98 Fresh Gala Apples, 3 lb Bag Weight-adjusted Qty 1 $3.87 Thanks in advance for the help!

Thank you so much medam

Thank you !!! 😘

In the video, the 2nd drop down seems to update automatically. On my own sheet, the drop down options DO change, but I still have to go in and reselect. You know why that would be?

Why not use XLOOKUP instead?

was trying to follow along, but couldn't import the weather page in print format to power query. Not sure what I did wrong

Leila, I can’t stand that people say awful things to you! Oz, thank you for sharing the painful years of your life story, even though I cried. When things turned around for you, it was inspiring.

@leilaGharani thank you for such a great video. It was just the right amount of information for anyone. I especially liked the section on what is NOT for. This was the most important part of the video for me as this is exactly I spend a lot of time trying to figure out.