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

Range referencing in VBA in Excel.