https://www.youtu be.com/watch?v=m_SH0TOLsIc
Get Access to My Course “Principles of Financial Analysis” HERE: https://courses.xelplus.com/p/financial-analysis If you operate in accounting or you are a financing expert, make certain you discover these Excel solutions. They’ll make your work life a LOT much easier and they operate in all Excel variations. A few of these are fundamental Microsoft Excel solutions and functions and some are advanced Excel solutions. All are excellent for accounting professionals, auditors, information experts and anybody else who had actually like to utilize Excel more effectively. If you have a small company and you are hectic with accounting for your small company, this tutorial will assist you. If you have Workplace 365, make certain you have a look at this Excel tutorial. You’ll discover a list of simple and helpful Excel functions such as FILTER, SORT, UNIQUE and series functions: https://youtu.be/_EWcAR_Hkvg ★ My Online Excel Courses ► https://www.xelplus.com/courses/ 00:00 Crucial Excel Functions for Accounting Professionals 00:15 AGGREGATE Function 03:16 Excel ROUND Function 04:40 EOMONTH Function 05:53 Excel EDATE Function 07:05 Excel WORKDAY Function 08:43 3D Solutions 10:17 SUMIFS/ AVERAGEIFS/ COUNTIFS 12:51 Excel IF Function 14:41 VLOOKUP Function 16:50 TRIM Function _____ Comprehensive post for Excel functions for accounting: https://www.xelplus.com/excel-functions-for-accounting ✉ Uncertain which of my Excel courses fits finest for you? Take the test: https://www.xelplus.com/course-quiz/ ________ LINKS to associated videos: ► 3D Solutions: https://youtu.be/7T3i-RiuBBU ► SUMIFS/ COUNTIFS: https://youtu.be/AZuBNWMh7VM ► IF Function: https://youtu.be/KkTaQ5OjAGc ► VLOOKUP: https://youtu.be/hwL6KKJP-_I ► XLOOKUP: https://youtu.be/4c0CLUER6nw ► TRIM Function: https://youtu.be/ZKgosgTo38I More accounting & Financing videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKywV8Bk6euT02xxtv8YVDkZs For more Excel functions, have a look at this innovative Excel tutorials and functions playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz EXCEL RESOURCES I Advise: https://www.xelplus.com/resources/ Get Microsoft 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface area: https://microsoft.msafflnk.net/c/1327040/451518/7593 EQUIPMENT Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Cam: https://amzn.to/3a5ldBs Backup Cam: https://amzn.to/2FLiFho Main Lens: https://amzn.to/39apgeD Zoom Lens: https://amzn.to/3bd5pN7 Audio Recorder: https://amzn.to/2Uo5rLm Microphone: https://amzn.to/2xYy9em Lights: http://amzn.to/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s link on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani Keep in mind: This description consists of affiliate links, which indicates at no extra expense to you, we will get a little commission if you buy utilizing the links. This assists support the channel and enables us to continue to make videos like this. Thank you for your assistance! #MsExcel #excel #accounting
soubhadra619
How to practically do accounting in offices
https://youtu.be/Moas5YlqYRE
Arjun Nair
what is the purpose of using f4? im not able to use it
the_ameture_fotografer
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.
Leila Gharani
Glad you enjoyed the video!
Kumar J
Wow great video 👍
Maryam Erfani
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.
Leila Gharani
Thank you so much!
Danny Tan
any good souls out there can help the following: sum up above cells until 1st empty cell
Activecell.select ………???
Simu Islam
Wow
Minoo Karimi
Your video is amazing and functional though I started to learn excel functions recently .
Leila Gharani
Great to hear!
Abhishek Kumar
Thanks for sharing
Travis Pluff
WOW AGGREGATE is sooo slooooow. Very cool function but I need it faster.
Colleen Robinson
It looks like this has been updated, can you release an updated version of aggregate.
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! ♥
Leila Gharani
That’s great to hear. Good luck with the new job!
affandi ab majid
Awesome.. thnks Leila.
KC
Hi, I am learning MS Excel now, which exam i need to take firstly on excel to get certificate from microsoft since there are multiple excel courses with same code, could you please suggest me which exam(2013/2016/2019) I need to take firstly on excel since I am a beginner
Cuong Tran cuong
Hay quá