5 EXCEL FUNCTIONS ACCOUNTANT NEEDS TO KNOW:
1-AGGREGATE- Excel AGGREGATE function allows you to apply functions such AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows.
2-EOMONTH- refers to “END OF MONTH”, it calculates the last day of the month after adding a specified number of months to a date.
3- FORMULATEXT- returns a formula as a text string from a given reference.
4- N- It converts a value to a number.N function is a built-in function in Excel that is categorized as an Information Function
5- TEXTJOIN- This function combines the text from multiple ranges and/or text strings and includes a delimiter to be specified between each text value to be combined.