Prashant Jain
Hi, my name is Prashant Jain, and I am from India. The aim of this channel is to make viewers a super user of MS Office applications including Excel, Access and Outlook, along with Google Docs primarily Google Sheets. Not only this, the channel also aims to make viewers a super user of various other IT technologies as well which include Python, Java, C, C++, SQL, etc.
Игнорировать пустые значения поиска в Excel при использовании ВПР
Повторить определенное слово в столбце после каждой 4-й строки в Excel с помощью формулы
Выделение чувствительного к регистру слова в столбце Excel
Автоматически расширяйте список имен в Excel с помощью проверки данных
Add dash between all values of a list in a column and put it into a cell in Excel
Return a value based on the value entered in another cell in Excel
Convert Excel from English to Hindi
Найти сумму и среднее значение только отфильтрованных значений в Excel
Пропускать пустые ячейки при вставке в Excel
Получите количество дней до истечения срока действия различных продуктов в Excel
Skip blanks in Excel using formula
Extract day name, month name and year from a date in Excel
Add Mr. or Miss before names as per their genders in Excel
Show numbers in Lakhs in Excel using custom formatting
Show only last 4 digits of a mobile number in Excel using formula
Automatically insert serial numbers in Excel using formula
Insert sparkline chart within a cell in Excel
Extract employee names from a list as per different departments in Excel using formula
Change the sequence of headers in a table automatically in Excel
Sum comma separated values in a column in Excel
Convert numeric values to percentage values using custom formatting in Excel
Calculate total paid leaves of an employee in Excel
Automatically number rows even after addition or deletion of rows in a list in Excel
Create To-do list in Excel using conditional formatting
Generate random whole numbers between two values in Excel using formula
Print large amount of data on a single page in Excel
Sort birthdays by month in Excel
Create region wise map in Excel using various options in Excel
Stop typing a list again and again using custom list option in Excel
Create dynamic pictures in Excel using camera tool