Previous Lecture
Complete and continue
Certificate in Data Analytics
Processing Data from Business Transactions
Processing Data from Business Transactions
Introducing Business Transactions
Cell Referencing in Excel
Working with Custom columns and Basic functions
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
Working with Logical Functions
Using Logical Functions
Using the IF Function
Using the AND Function
Implementing String Manipulations
Implementing String Manipulations
Using the CONCATENATE Function
Using the LEN Function
Using the MID Function
Performing Statistical Calculations
Statistical Calculations
Measuring Raw Data
Using the AVRAGE Function
Using the MEDIAN Function
Using the MODE.SNGL Function
Using the STDEV.S
Performing Financial Calculations
Financial Calculations
using the PMT Function
Using the PV Function
Using the FV Function
Using the NPER Function
Using the IPMT Function
Using Formulas in Microsoft Excel
Lecture content locked
If you're already enrolled,
you'll need to login.
Enroll in Course to Unlock
Log In
×
E-Mail Address
Password
Remember Me
Login
Forgot Your Password?