5 Excel Functions EVERYONE Needs
Рет қаралды 905,420
Күн бұрынJoin 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
We're diving into the most important Excel functions introduced in recent updates for Microsoft 365 and Office 2021. Whether you're a seasoned pro or just starting, these functions are game-changers.
⬇️ DOWNLOAD the Excel Workbook from here: pages.xelplus.com/excel-funct...
✨ Key Highlights:
▪️ Dynamic Sorting with SORT Function: Learn how to dynamically sort your data sets by any column, like arranging salaries in descending order, with simple steps.
▪️ Discovering Unique Values with UNIQUE Function: Use the UNIQUE function to effortlessly pull distinct values or specific occurrences from your data.
▪️ Enhanced Lookups with XLOOKUP: Experience the power and flexibility of XLOOKUP, the advanced alternative to VLOOKUP, for your data search needs.
▪️ Dynamic Data Filtering with FILTER Function: Explore the FILTER function to create dynamically updating filtered lists based on conditions like salary ranges.
▪️ Sequencing Made Easy with SEQUENCE Function: Get to grips with the SEQUENCE function for creating ordered numerical sequences, perfect for indexing and more.
🎓 Get access to the complete course here 👉 www.xelplus.com/course/excel-...
You’ll master the new Excel functions through multiple exercises and challenges so you can use the FILTER Function instead of a complex combination of INDEX & MATCH. Not only will these save you from headaches but also from wasting time doing things the long way.
00:00 The Most Important Excel Functions
00:32 SORT Function (SORTBY)
03:16 UNIQUE Function in Excel
05:41 XLOOKUP
07:43 FILTER Function
09:29 SEQUENCE Function in Excel
LINKS to more Excel 365 tutorials: • Excel for Office 365 &...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
@LeilaGharani 6 ай бұрын
Grab the file I used in the video from here 👉 pages.xelplus.com/excel-functions-for-everyone-file
@ibrahimdumbuya7751 Ай бұрын
Excel
@mcd22630 3 жыл бұрын
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.
@bobperkins409 3 жыл бұрын
Agreed
@bossssss 3 жыл бұрын
Thats food for thoughts
@woljin 3 жыл бұрын
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.
@bk1695 3 жыл бұрын
Totally agree!
@jamesjeffley4926 3 жыл бұрын
Your content, clarity, relevance, and production values are the Platinum standard for instructional videos. You. Are. Awesome!
@Coffeedrinkerer 3 жыл бұрын
This has literally change my life this last month! I saved so much time on my reports. All accountants need to see this!
@mtbrogue88 3 жыл бұрын
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
@christiantorres3786 3 жыл бұрын
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.
@renaeseverson4180 3 жыл бұрын
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!
@enochakabobby 3 жыл бұрын
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!
@BitesizeExcel 3 жыл бұрын
Definitely a fantastic channel and an inspiration to those of us starting out on a KZfaq (or Excel) journey! :)
@fletcherenrique6136 2 жыл бұрын
instablaster...
@aldengraham 2 жыл бұрын
Aww
@millerlite196 7 ай бұрын
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.
@rozuerd2614 3 жыл бұрын
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 KZfaq!
@vida1719 3 жыл бұрын
Great overview. All these functions are my favourites, they make life just easier
@cartheym 2 жыл бұрын
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
@jillcrowe2626 2 жыл бұрын
Most of my time in Excel is making it look good. I even embed pictures like gas pumps over the expense label "gasoline."
@curiosoclassicus7315 2 жыл бұрын
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!
@coffeecuppepsi 3 жыл бұрын
Filter is always my favorite and sequence was new for me.
@lavmenace7299 3 жыл бұрын
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.
@reasonerenlightened2456 2 жыл бұрын
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.
@cristipartac7159 2 жыл бұрын
@@reasonerenlightened2456 What do you want to say???
@mialy 3 жыл бұрын
I think I can listen to you all day. I am learning all the time I come and check your channel. Thank you 🙂
@icsos 3 жыл бұрын
I loved SORT. Together with filter it helped me in creating automated Pareto charts. This was actually a problem I had today and I was happy to watch and learn about this solution in this video.
@francescox79 3 жыл бұрын
Love you Leyla! You bring my excel skills on the next level.
@AsmaaAhmed-bh5yx 3 жыл бұрын
My favourite is Unique & Filter combined, I used them in most of the reports I made in 2020.
@zubairso 3 жыл бұрын
How are you using those? Can you give some practical examples.
@LeilaGharani 3 жыл бұрын
Very powerful combo!
@altusklingenberg5561 3 жыл бұрын
Leila, you are super awesome in the manner and way you facilitate excel and other Microsoft office hints/insights/tips! Thank you VERY much. ALWAYS a pleasure to watch and learn from you!
@deeshah3076 3 жыл бұрын
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
@runwiththerunners8152 3 жыл бұрын
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.
@BitesizeExcel 3 жыл бұрын
Totally agreed - I really don't get why people give thumbs down on great videos with helpful and useful information!
@17aig 3 жыл бұрын
@@BitesizeExcel I don't understand either
@juansebastiancastillogomez7800 2 жыл бұрын
Yes my brotherrr
@wp878 2 жыл бұрын
They are Mac users XD
@cartheym 2 жыл бұрын
insignificant fools who don't need any more attention than they've already got
@TylerStanczak 3 жыл бұрын
Officially bookmarked! Awesome tutorial for excel Leila :)
@LeilaGharani 3 жыл бұрын
Awesome, thank you Tyler (I see you updated the name - nice!)
@TylerStanczak 3 жыл бұрын
@@LeilaGharani yes recently made the change to my name and will be expanding the channel beyond PowerPoint to be tech tutorials for creatives. :)
@minapeiravi1441 2 жыл бұрын
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.
@gilberttwinamasiko2475 3 жыл бұрын
Sequence is new to me! Thanks Leyla, always keeping things simple and clear!
@Muuip 3 жыл бұрын
0:35 Sort/Sortby 3:17 Unique 5:43 XLOOKUP 7:43 Filter 9:30 SEQUENCE
@ovskihouse5270 2 жыл бұрын
👍
@R808-n6k 3 жыл бұрын
Are we expecting a new class and advanced excel class with newer formulas / power query stuff in 2021
@TheNabob57 3 жыл бұрын
Leila. You are my favorite Excel person. You are smart, easy to understand, and you provide easy to understand content.
@markanthony7078 3 жыл бұрын
Thank you Leila, i love your simple and clear explanations and teaching. Stay blessed.
@MrMustafaJE 3 жыл бұрын
Lol, I didn't know any! And I thought I was an exel guru😂
@manideepak6820 3 жыл бұрын
Wish you a very happy new year from Andhra Pradesh ❤️
@LeilaGharani 3 жыл бұрын
Thank you! Happy New Year to you too!
@Pakalaakhil 3 жыл бұрын
Jai balayya, happy new year 😀
@manideepak6820 3 жыл бұрын
@@Pakalaakhil ca articleship a bro
@Pakalaakhil 3 жыл бұрын
Mail id or whatsapp no cheppu bro
@manideepak6820 3 жыл бұрын
@@Pakalaakhil enduku
@danezuzu5768 3 жыл бұрын
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
@danielrichards8596 3 жыл бұрын
The unique function will save me a lot of time. This is another great video!!! Looking forward to the next one! I have shared a few of your videos with coworkers and they were received well. I mentioned the Visio add in during a regional Lean Yellow Belt training. Nobody knew the add in was available, but I did thanks to your videos.
@mac1os191 3 жыл бұрын
XLOOKUP finally improved ! Thanks for that hint...
@woljin 3 жыл бұрын
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.
@dougmphilly 3 жыл бұрын
@@woljin anything to reduce the need for index/match is a blessing
@techdelasabana 3 жыл бұрын
XLOOKUP is my all time favorite. Is the best way to relate tables in excel.
@ScottLititz 3 жыл бұрын
Yes. I use it so much, I forget how to do VLOOKUP
@eileensaint3434 3 жыл бұрын
Sort and filter is a game changer for me.Thank you so much
@abaasanji4979 3 жыл бұрын
amazing improvements, sort function, and Xlookup are my favorite. The sequence function is also an amazing function I should start using
@tracymcbee2473 Жыл бұрын
I’ve been watching your videos on the filter function. I agree, it’s my new favorite.
@jgarces2011 2 жыл бұрын
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.
@Perfectmyself 3 жыл бұрын
Xlookup love it. Avoid the confusion of the index match match. But these are great. Thank you so much for teaching them.
@helenwelsh967 3 жыл бұрын
Thank you so much! I love the UNIQUE FUNCTION and Xlookup.. much easier than Index and Match!! Your videos are excellent, to the point, and very professional looking..
@ericdearth7268 2 жыл бұрын
My favorite is the combo of Sort/Filter. You do a great job in presenting the information.
@schwarz8737 3 жыл бұрын
Nice vid! Definitely sequence for me, in order to dynamically show a limited number of data points, say weeks, in an ever expanding data set. Love it :) Thanks!
@cleangene17 3 жыл бұрын
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!
@janetlee9040 2 жыл бұрын
Unique is great. No need to use pivot. Using unique and countif and sumif . Easy and efficient. Thank you Leila.
@IvanCortinas_ES 3 жыл бұрын
Great tutorial Leila. Thank you very much for your effort and for explaining it so clearly.
@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
@JenembaSquad 3 жыл бұрын
As always Leila great content, many thanks for your teachings we appreciate you!
@KennethBaker53 3 жыл бұрын
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.
@LeilaGharani 3 жыл бұрын
Glad it was helpful, Kenneth.
@samiijsph87 3 жыл бұрын
Sequence function.I liked the way you explained how we can use it, Its really very useful. Always a fan of your team.
@ChadRexin 2 жыл бұрын
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.
@colormile-vid8888 3 жыл бұрын
My favorite is the new Xlookup followed by filter & sort functions. Would love to know more about the Lambda function. Thanks for sharing your excel expertise to the community.
@user-xd6vm5lw1l 3 жыл бұрын
Xlookup and filter are GREAT!!!!!! Loving it!! Thank you Leila ❤️
@tatyanasvirina1948 2 жыл бұрын
Leila, thanks for inspiration! You made FILTER my favorite one too!
@ayeshashakil4897 3 жыл бұрын
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 😊❤️
@patrickclairet2345 2 жыл бұрын
My favorite one is unique because it stands like Pivot Table without refreshing when preparing lists. Sequence was unkowned for me.
@putzi9966 3 жыл бұрын
I am gonna try using unique vs delete duplicates. Love you!! Thank you for what you do🤓😘
@reng7777 3 жыл бұрын
i love the way you teach us to all of us Laila!!! Happy 2021 starting new year my friend!!!
@GreenTrogo 3 жыл бұрын
I really love your videos. Your channel is my favorite about Excel!! Thanks for share your knowledge.
@thewilfreds 3 жыл бұрын
A perfect new year gift. Thank you!
@rcbcarm987 3 жыл бұрын
FILTER. Magic. Glad to see it was yours.
@connerkoski2183 3 жыл бұрын
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
@LeilaGharani 3 жыл бұрын
Thanks for sharing!
@marcelximenes410 3 жыл бұрын
Hi Leila, I'm from Brazil and I would like thank you for your videos, it has helped me a lot :)
@Luciano_mp 3 жыл бұрын
Filter my favorite. Thanks Leila!
@cpsandeepgowda 3 жыл бұрын
My fav excel channel, thank you Leila🙏
@BamSarnett 3 жыл бұрын
Brilliant series! I've only gone through a couple, but each has something of real value I can use right NOW. I am about to apply the SUMIFS, AVERAGEIFS and COUNTIFS in a single report I am developing. Thank you Leila!
@LeilaGharani 3 жыл бұрын
Fantastic!
@YH-gp9hd 3 жыл бұрын
Sort is what I use most, thank you very much for this tips.
@nishantgupta6328 3 жыл бұрын
Leila you explain so well👍 Whatever you teach, all is my favourite
@alcoolbc Жыл бұрын
all the fill functions when using dynamic ranges - Bravo Excel 365!
@jbkatariya 2 жыл бұрын
Unique function is one I was waiting for, thank you for sharing.
@esraaramadan9579 2 жыл бұрын
Thank you! very useful examples. I liked all the dynamic ideas and implementation
@YouExcelTutorials 3 жыл бұрын
Thanks for sharing Leila! Sequence is my fav.
@mustafamalik4211 Жыл бұрын
Using the hash nested by COUNTA nested by the SEQUENCE function; absolutely amazing.
@deependragupta7679 3 жыл бұрын
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.
@emilythechef 3 жыл бұрын
Ooooh, I'm so excited, I just got O365 at one of my day jobs. Thanks for this great video!
@francois830 3 жыл бұрын
Hi Leila thanks for this tremendous video. Apart that you are my favorite now, my favorite excel formula is the Xlookup.
@chinnerATgmail 3 жыл бұрын
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 ...
@LeilaGharani 3 жыл бұрын
Thanks for sharing your tips!
@sridhardubasi5088 3 жыл бұрын
Your explanation is as beautiful as you are.. Thanks a lot..
@ahmedzeko7788 2 жыл бұрын
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 .
@jillcrowe2626 2 жыл бұрын
I just learned the SEQUENCE function. It will change a lot of my work. From Escondido, California.
@sridharanrajalakshmi1417 3 жыл бұрын
Leila Excel Tips and Tricks are a great knowledge booster!!!
@AbhishekTripathidce 3 жыл бұрын
You are truly excel expert and dedicated to learn more new and exciting things to make life easier
@happyber581 3 жыл бұрын
Thanks for the Tutor, I have been using this filter,unique and sort in my report. 🙏
@saids.9813 3 жыл бұрын
My favorite Ms Excel function is F-Leila 🙌 Happy 2021, Ms Leila ✨
@Ugomakediciples 3 жыл бұрын
Thanks so much. Very useful and easy to understand.
@m1cannas 3 жыл бұрын
I used the Filter function. Yes, very easy and professional results.
@b0rme 3 жыл бұрын
Good video and neat functions. My preference is to throw all my excel problems into power query but I can see how these allow you to carry out PQ like tasks in the standard excel workbook 👍🏻
@BlOuB52 3 жыл бұрын
Sequence function is by far my favourite!!
@elenich5159 2 жыл бұрын
Thank you!!! Filter function by far
@osasisibor2114 3 жыл бұрын
Thanks so much for this. I think my favourite is the unique function.
@markc6714 3 жыл бұрын
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.
@LeilaGharani 3 жыл бұрын
Thanks 😊
@sankimalu 3 жыл бұрын
I did not know about the Sequence Function. That made my day.
@sustianrubel1808 3 жыл бұрын
U r the best excel master I hv ever seen. Just love u
@satishk8799 3 жыл бұрын
Everything is new to me, i liked the xlookup and sequence , you are awesome
@anthonyfernandezgonzalez8262 Жыл бұрын
Excellent lesson, thanl you so much. Completed.
@zohurulislam7628 3 жыл бұрын
Xlookup & Filter functions I am regularly using. These two functions I like most. Thank you for this nice video
@LeilaGharani 3 жыл бұрын
Great 👍
@ChandreshVed 2 жыл бұрын
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 👍🏼
@juliomonteiro8601 2 жыл бұрын
Filter is my favourite function. I learn a lot in this channel, Tks for your work.
@LeilaGharani 2 жыл бұрын
Great to hear!
@indradevdubey 3 жыл бұрын
I have learnt a lot excel through your videos. Thank you for sharing the same it helps many people to acheive their goals. Best part of your videos is its super easy to understand and apply on the data. Thank you so much 💓 #Leila Gharani#
@alialbayati9368 3 жыл бұрын
Sequence function is new to me, thanks a lot Leila for this video.
@LeilaGharani 3 жыл бұрын
You're welcome, Ali 😊
Online Training for Everyone
Рет қаралды 3,1 МЛН