Extract EmailID from list in Excel
Ajay
00:33
Most of the time it happens to extract email ids from the list in excel, we have large size of list and that becomes difficult task to...
20171226
20171211
Dynamic Named Range using VBA in Excel
Ajay
02:20
In previous article Create Dynamic Named Range in Excel we learn't multiple methods to create Named Range in Excel and use them d...
20171209
Create Named Range in Excel
Ajay
12:00
Create Dynamic named ranges in Excel and use them in formulas, data validations dynamically. There are multiples ways to create the name...
20171204
Caculate GPA-CGPA in Excel
Ajay
00:20
GPA and CGPA concept is used to evaluate the performance of students in many institution across globe. Every country has is own methodolog...
20171203
Calculate Percentile in Excel
Ajay
19:23
Percentile in Statistics is method of evaluation individuals performance in a group or set of people. Percentile is not the ranking positi...
