Excel for Accounting - 10 Excel Functions You NEED to KNOW!

Leila Gharani
Youtube
Related Topic
:- MS-Excel Accounting

If 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 Time Stamps: 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 My Online Excel Courses https://www.xelplus.com/courses/ 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/ZKgosgTo38I More accounting & Finance videos: https://www.youtube.com/playlist?list=PLmHVyfmcRKywV8Bk6euT02xxtv8YVDkZs For more Excel functions, check out this advanced Excel tutorials and functions playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyxvxehq3fiGjKDsEyy6d4Tz EXCEL 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/7593 GEAR 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/2eJKg1U More resources on my Amazon page: https://www.amazon.com/shop/leilagharani Let’s connect on social: Instagram: https://www.instagram.com/lgharani Twitter: https://twitter.com/leilagharani LinkedIn: https://at.linkedin.com/in/leilagharani 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! #MsExcel #excel #accounting

Comments