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

8 months ago
5

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:

• 5 Excel Functions EVERYONE Needs

★ 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

Loading comments...