10 Key Excel Formulas Used in Accountancy | Excel Functions for Accountants | Learn Excel | Microsoft Excel: The best tips for beginners.
In this video, I'm going to show you 10 key formulas used by accountants. These formulas are essential for anyone trying to get into the accounting or accounting-related field.
If you're interested in learning Excel, or want to learn more about accountancy, then this video is for you! I'll be teaching you all about 10 key formulas used by accountants, including how to use them, how to calculate them, and some examples. By the end of this video, you'll be well on your way to becoming an accountant!
This video lecture on Microsoft Excel will provide explanation and demonstration with example of Excel Functions used by Accountants or used in accountancy and finance department in Detail. It will demonstrate how below mentioned key excel functions can be used :
1. AGGREGATE FUNCTION
2. ROUND FUNCTION
3. EOMONTH - END OF MONTH
4. EDATE
5. WORKDAY
6. 3D FORMULAS
7. SUMIFS / AVERAGEIFS / COUNTIFS
8. IF
9. VLOOKUP
10. TRIM
It will really help users to make their life easy with excel analytics.
#excel #microsoft #calculation #online #tips #tipsandtricks #microsoftexcel #education #TheIndianExcelGuru #online #onlineclasses #onlineearning #onlineclass #excelinterviewquestionsandanswers #excelshortcutkeys #excelcheckbox #excelformula #exceltutorial #exceltutoring #excelformulaforjobinterview #excelforfresher #excelworld #excelmovies #exceldataentrywork #exceltips #onlineclass #course #coursesafter12thscience #excelhackathon #excelhacks #excelhacksandtricks #excelhacercalendario #office365
00:00 Introduction
00:42 #01: Aggregate Function
05:08 #02: Round Function
06:54 #03: EOMONTH Function
08:55 #04: EDATE Function
10:35 #05: WORKDAY Function
12:56 #06: 3D FORMULAS
14:49 #07: SUMIFS / AVERAGEIFS / COUNTIFS
17:42 #08: IF Function
19:00 #09: VLOOKUP Function
20:56 #10: TRIM Function
23:25 Conclusion
The Indian Excel Guru
コメント