5 Excel Functions EVERYONE Needs

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.

✨ 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.

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

🚩Let’s connect on social:

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

[mcd]

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.

[jamesjeffley]

Your content, clarity, relevance, and production values are the Platinum standard for instructional videos. You. Are. Awesome!

[renaeseverson]

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!

[Coffeedrinkerer]

This has literally change my life this last month! I saved so much time on my reports. All accountants need to see this!

[mtbrogue]

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

[christiantorres]

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.

[vida]

Great overview. All these functions are my favourites, they make life just easier

[runwiththerunners]

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.

[enochakabobby]

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!

[rozuerd]

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 Youtube!

[icsos]

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.

[mialy]

I think I can listen to you all day. I am learning all the time I come and check your channel. Thank you 🙂

[coffeecuppepsi]

Filter is always my favorite and sequence was new for me.

[lavmenace]

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.

[altusklingenberg]

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!

[danielrichards]

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.

[francescox]

Love you Leyla! You bring my excel skills on the next level.

[Muuip]

0:35 Sort/Sortby

3:17 Unique

5:43 XLOOKUP

7:43 Filter

9:30 SEQUENCE

[millerlite]

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.

[curiosoclassicus]

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!