Showing posts with the label ExcelShow All
Blog Formula for Find out Last Value in an Excel Column

Formula for Find out Last Value in an Excel Column

JAFAR P P 19:54

This formula will help you in finding out the value in the last cell of a column.  =LO…

Blog How to extract number only from a text in Excel

How to extract number only from a text in Excel

JAFAR P P 22:57

The following long formula can help you to extract only the numbers from the text stri…

Blog Search function in Excel

Search function in Excel

JAFAR P P 20:32

You can check the template for how INDEX formula enables the search function within th…

BASIC List of Unicode Symbols and Codes for Excel

List of Unicode Symbols and Codes for Excel

JAFAR P P 03:47

Blog Create a slicer in an existing PivotTable

Create a slicer in an existing PivotTable

JAFAR P P 01:38

Click anywhere in the  PivotTable   for which you want to create a slicer. On the  Ana…

Articles Auto Save Excel File After Cell Value Change

Auto Save Excel File After Cell Value Change

JAFAR P P 01:13

A macro-enabled excel file can save automatically when changing any cell value. See th…

Blog BMI Calculator

BMI Calculator

JAFAR P P 18:55

Calculate Your Body Mass Index . Body mass  index ( BMI ) is a measure of body fat b…

Blog Suicide of An Excel File!

Suicide of An Excel File!

JAFAR P P 07:32

This is not a story, an amazing VBA code to protect your highly confidential excel fil…