Grab the file I used in the video from here 👉 pages.xelplus.com/excel-functions-for-everyone-file
@ibrahimdumbuya77514 ай бұрын
Excel
@gloriarufus803329 күн бұрын
Thank you
@mcd226303 жыл бұрын
I don't have a favorite function. This channel is now my favorite source on how to use Excel functions. My hope for the new year is Microsoft will abandon their poorly written help section and it with links to Ms Gharani's video.
@bobperkins4093 жыл бұрын
Agreed
@bossssss3 жыл бұрын
Thats food for thoughts
@woljin3 жыл бұрын
Totally agree. This channel is awesome to highlight things you weren't aware of. Some are useful and others are interesting but not useful based on your use case.
@bk16953 жыл бұрын
Totally agree!
@enochakabobby3 жыл бұрын
I’ve started following this channel just a few weeks ago. Before that, my whole excel world was vlookup and subtotal. Now it’s become much more diverse! It’s really tough to pick my favorite! All thanks to this fantastic channel!
@BitesizeExcel3 жыл бұрын
Definitely a fantastic channel and an inspiration to those of us starting out on a KZbin (or Excel) journey! :)
@fletcherenrique61363 жыл бұрын
instablaster...
@aldengraham2 жыл бұрын
Aww
@Coffeedrinkerer3 жыл бұрын
This has literally change my life this last month! I saved so much time on my reports. All accountants need to see this!
@millerlite19610 ай бұрын
I have been following this channel for about 2yrs now. I have learned so much in that time frame and have become one of the top 3 users of excel in my office. I work in the finance department of a casino, and have been redoing all the workbooks to up date them. The filter function has become my #1 function to use. When i started my position 2 1/2 yrs ago i couldn't even use a sumifs. So Leilia, thank you so much for making these videos, you do a wonderful job explaining how the functions work.
@jamesjeffley49263 жыл бұрын
Your content, clarity, relevance, and production values are the Platinum standard for instructional videos. You. Are. Awesome!
@minapeiravi14413 жыл бұрын
I'm about to start a new job in a consultancy company after working 15 years in the construction contractors, and I need to develop my Excel knowledge, I'm very grateful for the videos, you walked me through a new word and I wanted just to leave a comment and thank you for the extremely informative channel. Thanks again and wish you the best in your personal and work life.
@mtbrogue883 жыл бұрын
Fast enough for those familiar, slow enough for the learner. Detailed enough to be practical, summarized enough not to bore! Excellent tutorials as always! Thank you Leila! "Filter" is my favourite function
@ahmedzeko77882 жыл бұрын
I understanding a lot of function in your channel , but i just set with a friend and he started showing me the magic of those functions and i subscribed in office 365 and i found in your video exactly the same as my friend show me in excel , tomorrow i can go to the work and start include this functions in my reports . Thank you very much .
@christiantorres37863 жыл бұрын
I love the fact that these are mostly dynamic ranges. Solves the issue of having to drag down formulas or use a pivot table to automatically update results when new data is introduced. My favorite function would have to be the "Unique" function because it helps isolate unique combinations so much better than manual filtering or using "remove duplicates" which requires modifying original table or copying and pasting a new range that can then be trimmed down.
@rozuerd26143 жыл бұрын
Where do I start. They are all very useful, and you have a special way of delivering them to us. One of the best tutors on KZbin!
@curiosoclassicus73152 жыл бұрын
Leila ...you're a God send. You really are here on this earth to help people. I'm so grateful for you. You have NO idea how much I learn from you. Thank you so much!
@lavmenace72993 жыл бұрын
I combined Sort and Unique and it's made my report live so much easier, homg. I think that might be my new favorite. Filter, though, is the most used.
@reasonerenlightened24563 жыл бұрын
99% of the people who died from cancer in the last 20 years know about Microsoft products. Be careful what you learn or else you might get cancer too.
@cristipartac71593 жыл бұрын
@@reasonerenlightened2456 What do you want to say???
@mialy3 жыл бұрын
I think I can listen to you all day. I am learning all the time I come and check your channel. Thank you 🙂
@runwiththerunners81523 жыл бұрын
Who are these people that give a thumbs down - what sad people they must be? This is an amazing channel and Leila is the best ever and my go to person on excel who has saved me so many times. She is amazing, I love her.
@BitesizeExcel3 жыл бұрын
Totally agreed - I really don't get why people give thumbs down on great videos with helpful and useful information!
@17aig3 жыл бұрын
@@BitesizeExcel I don't understand either
@juansebastiancastillogomez78003 жыл бұрын
Yes my brotherrr
@wp8783 жыл бұрын
They are Mac users XD
@cartheym3 жыл бұрын
insignificant fools who don't need any more attention than they've already got
@amoorinet.. Жыл бұрын
Really I searching and searching through many others channels. In the last I getting what ever I need in this channel Thanks a lots
@renaeseverson41803 жыл бұрын
The XLookup is going to be my new favorite! I'm excited to try that, and the new Filter function! Thank you so much! I'm looking forward to more of your demos!
@janetlee90402 жыл бұрын
Unique is great. No need to use pivot. Using unique and countif and sumif . Easy and efficient. Thank you Leila.
@AsmaaAhmed-bh5yx3 жыл бұрын
My favourite is Unique & Filter combined, I used them in most of the reports I made in 2020.
@zubairso3 жыл бұрын
How are you using those? Can you give some practical examples.
@LeilaGharani3 жыл бұрын
Very powerful combo!
@markc67143 жыл бұрын
Yes not an Excel comment but it comes to mind every time I watch one of your videos....i've watched a tonne of your videos going way back and you never seem to age a day. Stunning.
UNIQUE is a life changer for me. I have been copy/paste and REMOVE(ing) duplicates for years to make summary tables. Now, I can do it with one function.
@LeilaGharani3 жыл бұрын
Glad it was helpful, Kenneth.
@TylerStanczak3 жыл бұрын
Officially bookmarked! Awesome tutorial for excel Leila :)
@LeilaGharani3 жыл бұрын
Awesome, thank you Tyler (I see you updated the name - nice!)
@TylerStanczak3 жыл бұрын
@@LeilaGharani yes recently made the change to my name and will be expanding the channel beyond PowerPoint to be tech tutorials for creatives. :)
@TheNabob573 жыл бұрын
Leila. You are my favorite Excel person. You are smart, easy to understand, and you provide easy to understand content.
@vida17193 жыл бұрын
Great overview. All these functions are my favourites, they make life just easier
@chinnerATgmail3 жыл бұрын
I am an old timer with more than 50 yrs as a developer beginning with 360 Assembler and Excel v4. One of the most useful features that is never discussed is the value of defining a 'thisCell' variable equal to the current active cell: i.e. if the current active cell is B3 in the current sheet, define 'thisC' equals '!B3'. [Note that this is a relocatable definition.] Now, whenever you change the current active cell, the definition for thisC will be revised accordingly/respectively. Now, you can compose other formulae using the OFFSET or INDEX functions to reference relative cells/ranges. This is often a lifesaver when you need to use excessively long or recursive constructs which EXCEL won't accept. For what it's worth ...
@LeilaGharani3 жыл бұрын
Thanks for sharing your tips!
@coffeecuppepsi3 жыл бұрын
Filter is always my favorite and sequence was new for me.
@deeshah30763 жыл бұрын
My favourite is the x lookup. Love you can pick from the left and from different tables. This is the first clip I have watched from this channel, I cannot wait to watch and learn more
@francescox793 жыл бұрын
Love you Leyla! You bring my excel skills on the next level.
@cartheym3 жыл бұрын
This video is the gift that keeps on giving ❤ Thx Leila & team!!! I've used it several times already as a reference for practical use of the new formulas, and did so again today. This time helping out a friend turning what would be a manual process taking hours manually filtering, sorting and adding values from a csv dump containing over 20K rows of billing data, to a simple selection via drop-down. Took just 10mins to do the formulas using an embedded FILTER inside SORT twice, also wrapped FILTER with SUM using the values from an adjacent UNIQUE array to provide totals on the fly - so easy! In the past this would be a much longer process, maybe with some macros or VBA, but no need for that any more and so much quicker to produce - the guy thinks I'm a genius haha. Although I will admit it did take me another hour to make it look good lol
@jillcrowe26262 жыл бұрын
Most of my time in Excel is making it look good. I even embed pictures like gas pumps over the expense label "gasoline."
@manideepak68203 жыл бұрын
Wish you a very happy new year from Andhra Pradesh ❤️
@LeilaGharani3 жыл бұрын
Thank you! Happy New Year to you too!
@Pakalaakhil3 жыл бұрын
Jai balayya, happy new year 😀
@manideepak68203 жыл бұрын
@@Pakalaakhil ca articleship a bro
@Pakalaakhil3 жыл бұрын
Mail id or whatsapp no cheppu bro
@manideepak68203 жыл бұрын
@@Pakalaakhil enduku
@danezuzu57683 жыл бұрын
All great functions. My favourite is the FILTER Function but i was more thrilled by the SEQUENCE function. this is a great new year gift. Thank you
@remars-xcel3 жыл бұрын
Are we expecting a new class and advanced excel class with newer formulas / power query stuff in 2021
@AbhishekTripathidce3 жыл бұрын
You are truly excel expert and dedicated to learn more new and exciting things to make life easier
@mac1os1913 жыл бұрын
XLOOKUP finally improved ! Thanks for that hint...
@woljin3 жыл бұрын
Xlookup is awesome. It removes the need for a concatenate and the limit of the return value being to the right of the lookup. You just have to make sure that your audience also has office 365. This can sometimes be an issue.
@dougmphilly3 жыл бұрын
@@woljin anything to reduce the need for index/match is a blessing
@eileensaint34343 жыл бұрын
Sort and filter is a game changer for me.Thank you so much
@MrMustafaJE3 жыл бұрын
Lol, I didn't know any! And I thought I was an exel guru😂
@tracymcbee2473 Жыл бұрын
I’ve been watching your videos on the filter function. I agree, it’s my new favorite.
@techdelasabana3 жыл бұрын
XLOOKUP is my all time favorite. Is the best way to relate tables in excel.
@ScottLititz3 жыл бұрын
Yes. I use it so much, I forget how to do VLOOKUP
@chh88603 жыл бұрын
In the "Sort" function you stated at the 1:35 mark " … you can drag your range to a few cells below …". In the Sequence" function you stated at the 10:45 mark, " … I want it to spill so I'm going to go with hash …" Question: can the 'hash' feature also be used in the "Sort" function to make the "Sort" function truly dynamic? Not sure which is my favorite yet … Unique and Sequence are new to me but not quite sure of their usefulness just yet (possibly) … but Filter is a strong favorite because it is so powerful. Once again … thank you for your work … always well done.
@jgarces20113 жыл бұрын
I have learned so much from these videos. I knew of none of the new functions such as XLookup, XMatch, etc...Awesome and thank you.
@sridhardubasi50883 жыл бұрын
Your explanation is as beautiful as you are.. Thanks a lot..
@alfredfularon40993 жыл бұрын
i am a beginner. i subscribed to this channel because the tutorial is easy to follow. i am learning a lot.
@LeilaGharani3 жыл бұрын
Awesome, thank you!
@jillcrowe26262 жыл бұрын
I just learned the SEQUENCE function. It will change a lot of my work. From Escondido, California.
@patrickclairet23452 жыл бұрын
My favorite one is unique because it stands like Pivot Table without refreshing when preparing lists. Sequence was unkowned for me.
@juliomonteiro86012 жыл бұрын
Filter is my favourite function. I learn a lot in this channel, Tks for your work.
@LeilaGharani2 жыл бұрын
Great to hear!
@tatyanasvirina19482 жыл бұрын
Leila, thanks for inspiration! You made FILTER my favorite one too!
@nishantgupta63283 жыл бұрын
Leila you explain so well👍 Whatever you teach, all is my favourite
@sridharanrajalakshmi14173 жыл бұрын
Leila Excel Tips and Tricks are a great knowledge booster!!!
@shashaip39773 жыл бұрын
I bought Office 365 last week ,just in time for your lesson 。Thanks!
@LeilaGharani3 жыл бұрын
Have fun!
@Perfectmyself3 жыл бұрын
Xlookup love it. Avoid the confusion of the index match match. But these are great. Thank you so much for teaching them.
@33hobbycat3 жыл бұрын
The combination of these new arrays functions is actually what amazes me : Sorting a filtered unique list is now so easy. ! I would appreciate microsoft to extend the spill concept to conditionnal (or non conditionnal as well) formatting : actually these functions provides dynamic range updates as far as values are concerned, but this not (yet ?) the case for the format... Thank you Leila, I really appreciate your videos & the way you teach. Happy new year.
@LeilaGharani3 жыл бұрын
Happy New Year to you too, Antoine!
@m1cannas3 жыл бұрын
I used the Filter function. Yes, very easy and professional results.
@dovids.greenberger4353 жыл бұрын
Thanks to Leila I already learned each of these functions in 2020. Looking forward to 2021 functions and Leilas explanations!
@LeilaGharani3 жыл бұрын
👍
@connerkoski21833 жыл бұрын
My favorite is using sort, unique, and filter all in one function. I use this formula a lot for work and it is has been really helpful for reports that are constantly updated. Great video
@LeilaGharani3 жыл бұрын
Thanks for sharing!
@cpsandeepgowda3 жыл бұрын
My fav excel channel, thank you Leila🙏
@hussainakhtar10943 жыл бұрын
What a fantastic presentation. I actually tried and tested every function with my data. Thanks Leila, you're reallying doing an amazing work.
@hussainakhtar10943 жыл бұрын
Filter is amazing so as Xlookup and Sequence... my favourite is Filter too.. :)
@LeilaGharani3 жыл бұрын
Glad you liked it!
@bazoo5133 жыл бұрын
Time to switch to 365, methinks... It is amazing that MS saw fit to wait several decades to expose some of functions that obviously existed internally. Thanks!
@alcoolbc Жыл бұрын
all the fill functions when using dynamic ranges - Bravo Excel 365!
@ChandreshVed3 жыл бұрын
I’m wondering, if you have a Million+ subscribers, you ( of course along with MS) must have saved how many man-hours collectively - mind boggling 👍🏼
@zohurulislam76283 жыл бұрын
Xlookup & Filter functions I am regularly using. These two functions I like most. Thank you for this nice video
@LeilaGharani3 жыл бұрын
Great 👍
@mustafamalik42112 жыл бұрын
Using the hash nested by COUNTA nested by the SEQUENCE function; absolutely amazing.
@ayeshashakil48973 жыл бұрын
Hi Leila, I like the way you explain. It make things easier to understand. I have learnt many functions from your video and looking more in future. Thank you 😊❤️
@aziquaderi3 жыл бұрын
HNY Leila, These are my favorites: 1. Definitely Filtering with the sort function. 2. Sortby & Sequencing functions. 3. XLookup, btw can you please show this function grabbing data from multiple sheets? 4. Unique function.
@sustianrubel18083 жыл бұрын
U r the best excel master I hv ever seen. Just love u
@rubensuarez77403 жыл бұрын
XLookup, now you don't need to select everything. Excellent Job. Thank you Leila
@LeilaGharani3 жыл бұрын
You're most welcome, Ruben 😊
@themateteco2 жыл бұрын
Well, I came across most of the newest functions from your videos. But now, I have SEQUENCE. Although, I thought I saw it somewhere and never looked it up. Thanks!
@alialbayati93683 жыл бұрын
Sequence function is new to me, thanks a lot Leila for this video.
@LeilaGharani3 жыл бұрын
You're welcome, Ali 😊
@iv13893 жыл бұрын
I already use the xlookup function daily, the next on my list is filter function; I saw the clip with sequence function but I didn't know exactly when or for what situation I can use it. Now I know 😉. Txs👍
@kelleybryant93513 жыл бұрын
Xlookup is my goto. Our company has for years used Vlookup as the universal hammer for every screw, lol. Getting a lookup that fixed all the old problems is great. Sequence was new to me, though. Thanks!
@ericdearth72682 жыл бұрын
My favorite is the combo of Sort/Filter. You do a great job in presenting the information.
@chanmengc3 жыл бұрын
Unique! Used to create a pivot table just to get the unique list of rows, now I have Unique. Thanks Leila!
@LeilaGharani3 жыл бұрын
That's great!
@simon_mera3 жыл бұрын
Love them all (especialy filter within filter) but the if_not_found in the xlookup you told us is brilliant! Now I can stop putting the xlookup within an iferror() formula. As always, you are the best! Thanks.
@LeilaGharani3 жыл бұрын
Happy to help, Simon!
@TheDaievans13 жыл бұрын
I really love your approach to Excel and its latest functions, you're the best 👍
@LeilaGharani3 жыл бұрын
Glad you think so!
@cleangene173 жыл бұрын
Xlookup is my favorite because I use it constantly. Runner up is Sequence. I wasn't aware of all except Xlookup which I recently discovered. Thanks for the video and keep up the great work!
@ChadRexin2 жыл бұрын
Xlookup is great for matching up data from two systems and quickly figuring out what the missing records are. Great tool to use in conjunction with Microsoft Dynamics 365 organizations.
@esraaramadan95792 жыл бұрын
Thank you! very useful examples. I liked all the dynamic ideas and implementation
@sng3233 жыл бұрын
I like the Xlookup function. Thank you for the tutorial.
@RA-rh5lb Жыл бұрын
My favorite function is Xlookup and a combination of a sort with a filter. thanks
@小鱼儿和大黄妹3 жыл бұрын
Xlookup and filter are GREAT!!!!!! Loving it!! Thank you Leila ❤️
@HachiAdachi3 жыл бұрын
So we'll all need to master 'Dynamic Array' functions in 2021. Got it! 😁 Out of these 5, I think FILTER is my favorite although ALL of them will now be pretty essential in common data aggregation. Happy New Year, Leila!
@LeilaGharani3 жыл бұрын
Happy New Year to you too!
3 жыл бұрын
“La mejor de lo mejor” Simplemente me encantan tus videos Me encanta tu dicción, la velocidad y articulación justa al hablar para que se te entienda perfectamente. La forma como simplificas lo complejo de explicar. Tu profundo conocimiento de cada uno de los temas que tratas. Un fuerte abrazo y bendiciones. - "The best of the best" I just love your videos. I love your diction, speed and correct articulation when speaking so that you can be understood perfectly. The way you simplify the complexity of explaining. Your deep knowledge of each of the topics you present. A big hug and blessings.
@LeilaGharani3 жыл бұрын
Wow, thank you very much for the kind feedback, José!
@surajnirankari76233 жыл бұрын
Great to see you in 2021... Wish you a very Happy New Year
@LeilaGharani3 жыл бұрын
Thank you so much 😀 Same to you!
@alexcorona41993 жыл бұрын
I'm not even done with this video, and I foresee tons of hours saved in my job. Thank you for the videos!
@LeilaGharani3 жыл бұрын
You're very welcome, Alex!
@jbkatariya2 жыл бұрын
Unique function is one I was waiting for, thank you for sharing.
@mattschoular88443 жыл бұрын
These functions are fantastic. I have been using all of them for months. So much so that I almost forget how to use vlookup (almost). The only issue occurs when I need to provide an Excel file to a non MS 365 user. I learned a few tricks. Thanks for the video Leila.
@LeilaGharani3 жыл бұрын
That's true, Matt!
@Ohgrowup13 жыл бұрын
I’m a data analyst and use functions regularly. I love the new/revised functions! I will use them to effectively summarize my tasks. Thank you!
@linkpl823 жыл бұрын
Most of this functions are in google sheets ... from many many years ... not from 2018th ... Friend of mine, works in exel from years, and I just start lerning sheets from maybe 6 months but not all the time, and We discus about array functions ... excel is very poor looking ...
@shakthiatukorala5953 жыл бұрын
Really useful tutorials..I think FILTER is the best function.. And nice start for 2021...!
@LeilaGharani3 жыл бұрын
Glad you think so!
@markanthony70783 жыл бұрын
Thank you Leila, i love your simple and clear explanations and teaching. Stay blessed.
@silverlicious20863 жыл бұрын
I don't have 365, but I still enjoy your vids to keep up on the latest. Appreciate your efforts.
@LeilaGharani3 жыл бұрын
Cool, thanks
@TongkiNgaceng3 жыл бұрын
sequence saved my life from typing =if(B1"";"1";"") to every cell at A:A !!!
@rameshgohil19843 жыл бұрын
I have passed microsoft excel expert exam after watching all your videos. Thank You 😊🙏
@benjivandordt19743 жыл бұрын
Just discovered your Chanel and it makes me so happy I could hug you. Unfortunatly there is some kind of desease so I won't come over to where ever you live. But hey, thanks for these easy to understand videos👍😄
@LeilaGharani3 жыл бұрын
Welcome aboard 😁
@deependragupta76793 жыл бұрын
Favourite fn is xlookup, sort n filter and yes i know all of them coz i watch every video of yours as soon as i get time to watch and practice accordingly.
@PawanKumar-yu1wm Жыл бұрын
I always admire her teaching from India
@ranjeevpauluzzi9597 Жыл бұрын
You are saving me so much time in my every day job, THANK YOU SO MUCH!!! There are some merchindising that you put your autograph on?
@abdullaalturabi65263 жыл бұрын
always learning something new in this channel. great work leila
@LeilaGharani3 жыл бұрын
Thank you!
@hemanthnani50523 жыл бұрын
Very much useful.... Thanks again Leila for this informative video!!!!
@LeilaGharani3 жыл бұрын
My pleasure!
@Ugomakediciples3 жыл бұрын
Thanks so much. Very useful and easy to understand.
@francois8303 жыл бұрын
Hi Leila thanks for this tremendous video. Apart that you are my favorite now, my favorite excel formula is the Xlookup.