@LeilaGharani

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

@Codger2015

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.

@essential_luxury3356

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

@MrOPD

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.

@chinyereezeigbo5837

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

@TheWeteyezz

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

@smitajaiswal5857

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

@10x29

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

@mhknowledgeacademy6420

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.

@tahoejohnny3991

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!

@abdulhafeezbhatti1787

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

@jjey24

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

@lumai2709

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.

@karhukivi

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.

@mostafa4321

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.

@maryamerfani5249

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.

@bobwhelan5644

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.

@darlowmaxwell7346

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

@dipakchoubey

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

@mubashir38

OMG. Aggregate is so best. Today I really learnt something from this. You are best Mam.