akshatratanpal
akshatratanpal 04 Dec 2021
1

Up next

Excel DGET Function Solves 2 of Your VLOOKUP Problems
04 Dec 2021
Excel DGET Function Solves 2 of Your VLOOKUP Problems
akshatratanpal · 12 Views

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

3 Views

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

★ 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-accoun

✉ 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/playli....st?list=PLmHVyfmcRKy

For more Excel functions, check out this advanced Excel tutorials and functions playlist: https://www.youtube.com/playli....st?list=PLmHVyfmcRKy

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/75

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

Show more
0 Comments sort Sort By

Up next

Excel DGET Function Solves 2 of Your VLOOKUP Problems
04 Dec 2021
Excel DGET Function Solves 2 of Your VLOOKUP Problems
akshatratanpal · 12 Views