5,376 views
In this video, we will learn about important Excel equations for every accountant - the financial functions in Excel, which will save you time and effort and make you a professional accountant. We will discuss a group of functions and equations that are widely used in daily calculations, and will help you improve your accuracy and speed at work. We discussed the following topics: 00:00 Introduction 00:15 The aggregate function Performs calculations while ignoring errors, hidden cells, and some equations 03:27 The sumproduct function Multiplies the corresponding values in the specified ranges and then sums the results 04:56 The round function Rounding function 06:52 The datedif function calculates the difference between two dates in time units such as days, months, or years 11:15 Cumulative balance equation: The balance that is updated after each transaction by adding the incoming amounts and subtracting the outgoing amounts. 12:26 The if function checks a condition and returns a value if the condition is true, and another if it is false 13:27 Percentage equations (for salaries, for prices.. for tax, for service) 15:55 The vlookup function searches for a value in a column and returns a value from the column 18:16 The sumifs function sums values in a specific range based on the conditions of the work file: https://www.mediafire.com/file/iyxmof... Excel equations you should know The most important, most used and most common Excel equations. • Excel equations you should know The most important... Excel_for_accountants #Excel_functions #Professional_accounting #Accounting_equations #Accounting_education #Distinguished_accountant #excel #excelformulas