Excel Eternal
Cells & Ranges
Selection of range in excel. How to select a range with blank cells, row, and columns in between.
Financial Functions
Calculate EMI, Principal, Rate & Period of your loan with financial function of excel.
Principal and Interest calculation of home loan EMI using financial functions in Excel
Formula Basic
Cell reference in excel. How to use ABSOLUTE, RELATIVE and MIXED reference in excel
Iterative calculation and circular reference error in excel.
Text Functions
Text functions in excel. Usage of CONCATENATE, CONCAT, TEXTJOIN and TRIM in excel.
VBA & UDF