Understand how to use MS Excel features and formulas to perform a forensic audit.
Recent Excel Tips
Introducing the TEXTJOIN function in EXCEL 2016 We are familiar with CONCATENATE function that we have been using for a long time to perform concatenation or to join different strings or numbers. This function has been preceded by introduction of a new function in Excel 2016 –the TEXTJOIN function (and also CONCAT function). The CONCATENATE […]
Introduction to SUMPRODUCT: In today’s post we will review some of the use of SUMPRODUCT function. The SUMPRODUCT function is amongst one of the favorites functions for Data Analysis – Particularly when you want to answer exploratory question like “how many”, “how frequent”, finding sum and averages against criteria’s. So we will start with a […]