https://www.youtube .com/watch?v=m_SH0TOLsIc
Get Access to My Course “Fundamentals of Financial Analysis” HERE: https://courses.xelplus.com/p/financial-analysisIf you work in accounting or you are a finance professional, make sure you learn these Excel formulas. They’ll make your work life a LOT easier and they work in all Excel versions. Some of these are basic Microsoft Excel formulas and functions and some are more advanced Excel formulas. All are great for accountants, auditors, data analysts and anyone else who’d like to use Excel more efficiently. If you have a small business and you are busy with bookkeeping for your small business, this tutorial will help you.If you have Office 365, make sure you check out this Excel tutorial. You’ll find a list of easy and useful Excel functions such as FILTER, SORT, UNIQUE and SEQUENCE functions: https://youtu.be/_EWcAR_Hkvg★ My Online Excel Courses ► https://www.xelplus.com/courses/00:00 Most Important Excel Functions for Accountants 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 Formulas 10:17 SUMIFS / AVERAGEIFS / COUNTIFS 12:51 Excel IF Function 14:41 VLOOKUP Function 16:50 TRIM Function _____Detailed article for Excel functions for accounting: https://www.xelplus.com/excel-functions-for-accounting✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/________LINKS to related videos: ► 3D Formulas: 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/ZKgosgTo38IMore accounting & Finance videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKywV8Bk6euT02xxtv8YVDkZsFor more Excel functions, check out this advanced Excel tutorials and functions playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4TzEXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/Get Microsoft 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593GEAR Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Main Camera: https://amzn.to/3a5ldBs Backup Camera: 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/2eJKg1UMore resources on my Amazon page: https://www.amazon.com/shop/leilagharaniLet’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharaniNote: 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!#MsExcel #excel #accounting
❤
Thanks Sister
Even better than vlookup is Index + match combo.
I LOVE YOU Teacher
Please mam provide us practice pdf files for all daily videos🇮🇳🇮🇳
PLEASE CAN U MAKE A VIDEO ON SMALL ROW FUNCTION I THINK ITS CALLED INDEX SMALL , and explain why we Minus…please …on Youtube there are only 2 videos but they did not explain clearly..I would much appreciate
👍👍👍👍👍👍
Great Mam, thanks a lot very helpful some i already knew but some were new to me
Hi, i hope you can help. We are a school and we use excel as our database for accounts and report cards. But we need help!!! We want to send info from our excel database to parents via whatsapp, can you help us with that? I have seen other people on YouTube do it but it is not in English. Can you big please help us with this!!!!
How do you get the drop downs in the formula bar?
I learn debits and credits pretty well, for bookkeeping from one of your videos. I use the advice that you offered, “Just remember Adex LER.” Thank you for that.
DONT GO FOR SKILLNATION EXCEL COURSE NOT WORTHY
You have many Excel informative videos, and I am uncertain which apply to my dilemma. I have about 500 invoices from since year 2007 Registrar Domain purchases, renewals, and other product purchases. They ‘batch’ the individual amounts per extension if they are the same rate. Therefore, if 50 of the renewals are the same amount, they are batched into one cell and within that same row is the list of Domains to which the rate applies, and they are also within one cell separated by commas. My assumption is that splitting out these cells should be the first thing in order. I have managed splitting data within a cell making them list vertically within the same cell, but I need them split into individual columns along with appropriate Domain, date etc. which would be the same date within the existing row. I then need to merge all of the invoices together to determine what each Domain and other products cost me over the course of 22 years. I hope I have described this clearly enough to provide you an understanding of my goal and the data format. If not, please inform me. Would you steer me in the right direction please? I realize I will need to watch various of your videos and make it apply to my circumstance. And forgive this lengthy self-serving comment. In advance, my apologies. How will I know you’ve responded other than a ‘new video’ notification? i entered this issue into ‘Just Answer’ and no one there could get this accomplished
One more issue that you may have a resolution in automating: Receipt scanning line items, matching totals to statements, and splitting out the items to which ever account and class is appropriate. Do you have automated power app BI or AI solution? There are some apps API that read line items, but additional apps or integrations must be configured. I have receipts from as far back as 1998 that need to be split as this is the year our son was in an auto accident, and we need all of our funds/expenses accounted and detailed very accurately. I was using QB desktop, but perhaps I can use Excel and import to QB, I am uncertain. This needs to be so thorough that the reports are plain for anyone and even including a judge and jury to see that the entries are very credible. Again, my appreciation. We are being accused by our son of using Trust funds for our personal gain . No need be concerned here. We absolutely have not even come near a breath of this. The Trust actually owes us a considerable amount of money of which we have not claimed. No worries. We just need to document exactly what has transpired financially. Again, my sincere appreciation.
Just struck up a thought: If you do have a somewhat automated solution(s), you should publish it as a Paperless Office solution too!! Yes!! Readers would totally come onboard with this. Me too. I am a paper-mess having to document EVERYTHING! PS I thought the video whereby you answered personal questions was cute. Thank you. Have a blessed day and make it one for someone other.
There is a little confusion in 3D formula, Could you Please repeat it in more details. would be very thankful to you.
Have a look at this one: https://youtu.be/7T3i-RiuBBU