Certificate in Data Analytics

Processing Data from Business Transactions

Introducing Business Transactions

Cell Referencing in Excel

Defined Name

Using Formulas in Microsoft Excel

Using the DATE and Time Function

Using the DATEDIF Function

Using the VLOOKUP Function

Using the HLOOKUP Function

Using the TRANSPOSE Function

Using Logical Functions

Using the IF Function

Using the AND Function

Implementing String Manipulations

Using the CONCATENATE Function

Using the LEN Function

Using the MID Function

Statistical Calculations

Measuring Raw Data

Using the AVRAGE Function

Using the MEDIAN Function

Using the MODE.SNGL Function

Using the STDEV.S

Financial Calculations

using the PMT Function

Using the PV Function

Using the FV Function

Using the NPER Function

Using the IPMT Function