Grab the file I used in the video from here 👉 pages.xelplus.com/functions-accountants-file

@phandongexcel

4 ай бұрын

I like this video and comment, I’m from Vietnam and you ❤

Watching your Excel tutorial has became an essential , forsure you are helping millions of people out there not only polishing their skill but also helping them in landing on opportunities, appreciate mate for your support

Not only are you good at Excel you also are good at explaining and making your material easily digested for putting into practice. I have been an Excel user for about 30 years but do not have near the knowledge of use that you do. I use Excel mainly during the last 5 1/2 years only for finances and accounting for home use. Prior to July 2015, I used it during my 21-year employment while working in an Architect firm mainly keeping track of capital improvements, costs of hardware/software, budget planning for capital improvements, and a slew of other uses I encountered. This helped considerably for that period of employment but now makes life so much easier for simple home accounting purposes, not to mention using it for a slew of other reasons besides accounting. Thank you for your awesome videos, they are so helpful and keeps me sharp at 71 years old. And on top of that, you are so pleasant to watch and listen to with a voice that keeps it interesting.

@LeilaGharani

3 жыл бұрын

Thank you for the kind feedback!

@Thukai-Operater

Жыл бұрын

Sir what type of work you do in Excel please guide me or share your story.

Wow, the trim function and the 3D formula was a WINNER for me! Thanks a million

I would simply say that you are amazing. The way you explain is very easy to understand. I have been watching your tutorials and it's really good to advance in excel.

Great video. I recently learned how to use the timeline function with pivot tables and I found it very useful when analyzing data for certain periods.

I have a huge documentation project, designing and documenting the entire accounting system, and was browsing your videos for inspiration. The aggregate function is going to be so much faster than combining subtotal & iferror! And i was trying to figure an efficient way to calculate due dates on month close components but couldnt figure how to account for holidays and weekends without some elaborate references to some hidden tab! haha you rock

Amazing video - found my new favourite formula - aggregate!! Thanks Leila for a great and thorough video as always.

Without a doubt one of the best accounting videos I have seen. You get to the point, but doesn't move too quickly. Awesome tutorial. Thank you!

@LeilaGharani

2 жыл бұрын

Glad you enjoyed it!

this is amazing. i'm prepping for my new job and am feeling anxious about it. all of your content has not only helped me brush up on the basics, but has also taught me some excellent secret tricks that will surely impress my new employer. ♥ many many many thanks for putting the effort in producing the content for this channel! ♥

@LeilaGharani

2 жыл бұрын

That's great to hear. Good luck with the new job!

I am looking to start my career in accounts and ur videos r really helpful .I am a nearly 40 yr old lady and really like ur personality n presentation too .Hope I can adapt someful qualities from u .Thnx Leila gharani

@computernerd3922

Жыл бұрын

I am a math major and I do a data analyst job, recently my boss asked me to do accounting for his company I guess he assumes I am a nerd and knows everything 😂 here I am learning accounting

@WISEMARTIAL

Жыл бұрын

How's it going for you? Have to used any of these formulaes ?

@Thukai-Operater

Жыл бұрын

U got any job in this field ?

@Akpihs23

Жыл бұрын

​@@computernerd3922 Your name itself has a nerd in it though 😂

@FriendTrue2008

9 ай бұрын

Interestingly, I am 33 and changed my career too

Your tutorials are effective and efficient. Thank you.

Leila you're a star! You are keeping us busy with a steady stream of new discoveries. I passed this one onto my brother-in-law who is an accountant and he was astonished - didn't really know what Excel could do,, so many thanks from him too and greetings from Ireland! Stay safe.

@LeilaGharani

3 жыл бұрын

Awesome, George! Hope the tips will be useful for him.

@AndreaUK1973

3 жыл бұрын

Yeah! She is a gem!!

I've been teaching Excel for quite some time now and nested IF functions have always been the biggest brain twister for basically every pupil. Never heard of the IFS function before but holy molly does that take all the complexity out of multiple nested IF functions, it's insane - I'm smiling like a little kid on Christmas eve because this is gonna make understanding Excel so much easier for so many people.

@LeilaGharani

3 жыл бұрын

Great to hear, Peter! Hope it will be helpful for your students.

@nokpiadariusconstantino1333

2 жыл бұрын

@@LeilaGharani улиоыбьяд ч ч в твэцжхцхы🤵👰🌷❤️

A new thing I learn from this video is the AGGREGATE function. Thanks, Leila Excellent work.

Brilliant Leila, thank you so much for all your explanations! 💫

Thank you so much, please keep going, fast, precise and easy to understand. Awesome.

Aggregate & EDATE function is a game changer for me!!

@LeilaGharani

3 жыл бұрын

Glad to hear it!

Monumental help.so lucid&simplified to the core. best wishes&many thanks

The way you explain is amazing Leila.

Hey Leila, this is a very helpful content!

The Excel goddess delivering the goods as always!!

Always great information! Thank you!

I’m glad I found your channel. It’s very helpful.

This was great and not only for accountants 😃

Hi Leila, this is my first comment on KZread channels and believe me I don't have words to appreciate the way you explain!!! Loads and loads of respect from India and thanks again for spreading the knowledge 🙏🙏

Thank you so much for your kind sharing. This has upgraded my knowledge regarding with excel usage for accounting. May you have a smart brain in every lives, at every age.

I have been using excel and all it’s predecessors DOR over 40 years and you taught me many new commands with this video. Amazing! Thanks

You are the queen of excel! 😍

3D Formulas... 🤯 I have needed this for so long!

@leoleon38

3 жыл бұрын

Exactly!!! I feel i wasted so much of my time before this

@majd8138

3 жыл бұрын

I've used it only once before. But does save time most people don't know about it.

Hey there Leila It was of great help indeed. It made my concept and logic very clear. Moreover the best part is, thet it halped me experiment various subfunctions with confidence and it worked as i want it to work. Bundle of thanks. Keep sharing more....

So helpful. Thank you for sharing.

I'm not an accountant, but need to measure P&L for the services we deliver and charge for. I have a task to create a spreadsheet to manage this. The content (and timing) in this video could not be better (or have come at a better time😁 ). So many great tips in once place, thank you Leila.

@LeilaGharani

3 жыл бұрын

I'm happy it's helpful for you, Bob!

Thank you, Leila, Also, Sumproduct is so interesting and useful function and it consists of filtering, sumif, and/or/True/False statement in one function. I learned all those very effective functions thanks to you. 👍 I want you kindly to publish a tutorial about Date/Time calculation methods in excel as well. Thank you again

Excellent insight! Thanks!

Thank you so much for such a great video. I've been a CPA for over 11 years and some of these functions I never knew existed. Keep up the good work.

@LeilaGharani

2 жыл бұрын

Glad you enjoyed the video!

Thanks for the refresher, Leila. Would like to add that adding Tables (ctrl+t) to flat files are pretty useful too 👍

@LeilaGharani

3 жыл бұрын

👍

Very useful tricks! Was super excited about the AGGREGATE function until I realized it ignores only SUBTOTAL but not SUM. Is there a way to make it ignore also the SUM function?

Thank you so much dear Leila. You explain beautifully and your voice has a soft and melodic tone. It is such a delight listening to you.

@LeilaGharani

2 жыл бұрын

Thank you so much!

Super big thanks! Have a wonderful day

Leila, thanks for your tutorials, because of your videos Excel looks so much easier :), please don't stop, keep informing us with great and unfamiliar functions (for beginners like me at least)

Leila The day I think I knew everything about Excell, I watch one of your Videos and finds that there is one more thing I do not Know. You are awesome Thank you for all the great content you provide us every day.

@LeilaGharani

3 жыл бұрын

Thank you! It's my pleasure.

@katestan7002

3 жыл бұрын

Same :))))

Thank you. Well summarised and well explained.

Excellent tips. Thanks!

im still here for u. continue your journey . thanks a lot . go for it.

For the last 5 years I've been struggling to do v lookup as the data was not trimmed. Now with the "trim" I can solve almost all the issues. Aggregate is another best thing. And the 3D was amazing. Most importantly leila tells us the dynamic use techniques of the functions or formulas. Thanks so much leila

@nokpiadariusconstantino1333

2 жыл бұрын

Оушщоущлущбуьюююьвщьуз бэ. Лутщут лут у у ивьвьдтужьщцбджьутщьущужжцэцэцж уул у лллуж. Огузту от. Иоыдтцдьвзудзуххузуз и ин от ви в ин оутзулузхухузул зы тузцз

Your manner of teaching is just amazing and out of this world

Thanks a lot , great video 👍👍

This is very helpful! I learned new excel functions! Thank you very much!!

@LeilaGharani

3 жыл бұрын

You're very welcome, Katherine!

i remember requesting you to make this video, so thank you. 👍 i would like to see a video on financial modeling functions for financial analysts for projections and asset valuation. that would be great! thanks again for making this video 😊

Really brilliant enough!!

You are a saviour. Thank you so much. I learn so many new things about excel from your videos. I have not had any formal training on excel but i am using it and even preparing complicated excel calculation sheets for my office use. It makes life much easier and all thanks to you. Thanks once again.

I was clicked clicked on random website I saw Leila Gharani excel course I was surprised that my favorite mentor has made great course. Udemy Course

Wow! How did I miss that Aggregate replaced Subtotal?! 🤔 And it is more powerful, particularly given that it can ignore errors, etc. Good examples for the three date functions too. Your 'Excel Functions 2021' video referenced at the end also has some good gems! That's what I love about your videos Leila, you ensure that any knowledge gaps are plugged, and you do so in a very approachable and effective manner. 👍 Thank you!

@LeilaGharani

3 жыл бұрын

Thank you very much!

@Nicole-fp6gh

2 жыл бұрын

I missed that one too. I've used Excel so long that I have ways to get to the needed end result, but I've missed Excel updates that make these tasks much easier.

@rameezmuhammed9356

Жыл бұрын

How to get the working tables or the data

@seanbhaney

Жыл бұрын

Ditto! I've been using Excel since the cows came home, and I've NEVER used the aggregate function! Today will be the first day!

So easy to follow and direct to the point, so grateful😍. The comes a time when auditing a client with a lot of data becomes tedious. Especially when it involves data that needs a lot of attention to the date of transactions resulting into data sampling to a human actionable pace but now I am confident with this insight i will be 100 times more efficient and provide quality audit reports with ease. posted 2 years ago but still relevant/ useful. Thank you so much

Great video!! Thank you!

Good stuff. Thanks for putting this out there. Maybe you have covered this in another video, but we also use the nested index/match formula frequently.

@LeilaGharani

3 жыл бұрын

Thanks for the tip, Daniel!

great tutorial, clearly presented ! thank you so much !

Excellent video!! Thank you🙏🏽❤

11:57 thank you! I was trying to do this the other day, with the "month" function to get the value, but it wasn't working 😅 I think I was missing the " " & 🤦🏻‍♀️ But this way is much better! I'm gonna use it 😁

@LeilaGharani

3 жыл бұрын

Hope it will work out for you.

iserror function is very helpful when nested in an if function using a vlookup function.

YOUR videos helps a lot "love you 3000"

Tip number 9 saved my life! Thank you very much!!!!

This lady is an excel guru. And the way she knows the new excel versions shows she invests time in it. Amazing, I just love it. 👏😊

@nokpiadariusconstantino1333

2 жыл бұрын

Ултпьт

I used to hate spreadsheets, and how much copying and pasting I was doing to manipulate even fairly small worksheets. Now, thanks largely to your videos and courses, I’m enjoying Excel and showing some tips to colleagues, who are really grateful.

Great job.... very easy to understand...u made my life easy 😃

y're such a GENIUS.....thanks for the insight

Great stuff as always. One of the powerful features of the EDATE function is that if the date you are seeking does not exist, it will give you the last day of the month. For instance, a U.S. estate tax return is due 9 months after death. If death occurs on 5/31/X1, the 9 month date can’t be 2/31/X2 so it becomes the last day of February, which is the value EDATE returns. If you try to do something equivalent with just the DATE function it would push you into March, which in this case would be wrong. Also, the WORKDAY function looks at how many workdays from the starting point you want to go. U.S. tax returns are only due on workdays. So, if you want to test whether that 9 month date is a workday you need to subtract 1 from the start date when you use the WORKDAY function. Assume the 9 month date is 2/28/X2, you subtract 1 day and then use the WORKDAY function to find the first workday from that date which could very well be 2/28/X2. If it isn’t, the WORKDAY will find the first workday after that date and that would be the due date of the return.

I like to use the clean function in conjunction with the trim function. The clean function gets rid of non-printable characters that appear to be spaces to the naked eye, but aren't really spaces.

@LeilaGharani

3 жыл бұрын

👍

Thanks so much! Save tons of time!!

my fav learning channel for excel.. thank you so much ..

love this... just minor suggestion, please use accounting format when using amounts values.

0.15 I was bit shocked. Elon Musk has stolen her logo 😅

@Merrymaking-xl3mo

20 күн бұрын

Power of Money

Many many thanks Leila for all what you share 👍👍👍👍

@LeilaGharani

3 жыл бұрын

My pleasure 😊

I am always learning from you thank you so much

#3 EOMONTH, #4 EDATE. put double negative -- before start date, if you need to utilise dynamic arrays functionalities for "dates array". eg. =EOMONTH(--A1:A20,0), =EDATE(--A1:A20,14),

How did you know i needed this for my exam haha, Thank you!! Love this series

@LeilaGharani

3 жыл бұрын

😁 Good luck with the exam!

this is an awesome video! I love how it is accounting focused!

loved it, Miss Leila

I learned, again, new stuff from Leila - that I can use tomorrow! Thanks so much!

@LeilaGharani

3 жыл бұрын

Wonderful!

Very Informative...

That's cool stuff,liked it so much

Always nice explain as usual

I learned so much! Thanks!

A wonderful lesson well delivered

very meaningful, useful and practical features, thank you so much for your always helpful videos

Very informative. Thank you so much

Thank you Leila, you are just wonderful

amazing!!! thank you for sharing!

Very informative, Thank you Leila!

OMG I am in love with ExceLeila.God Bless.😊😊😊

Thank you for sharing, its useful for help me.👍

Excellent video! Thank you very much for your hard work.

Many thanks, very useful video!

It's great & so useful 😊

Bravo! Many thanks!

Such a fascinating Lecture.

Thank you once again Leila!

mind blowing. Thank you!

Very informative!!thanks so much..