Easy Office
LCI Learning

Articles by CA Rishabh Pugalia (ExcelNext)

avatarView Full Profile

Learn how to compare two columns in Excel

  CA Rishabh Pugalia (ExcelNext)    17 March 2017 at 11:06

Learn how to compare two columns in Excel

Posted in Students  2 comments |   18751 Views


Adding suffix in cells in MS Excel

  CA Rishabh Pugalia (ExcelNext)    23 February 2017 at 10:57

Tricks to Format cells in Excel: Format Cells in Excel (Suffix)

Posted in Students  2 comments |   75661 Views


Trick to add digits in a cell in Excel

  CA Rishabh Pugalia (ExcelNext)    21 February 2017 at 11:17

Tricks to Format cells in Excel: Format Cells in Excel (Prefix)

Posted in Students  2 comments |   11807 Views


Tricks to Format cells in Excel: Currency Format (Prefix)

  CA Rishabh Pugalia (ExcelNext)    15 February 2017 at 11:28

Tricks to Format cells in Excel: Currency Format (Prefix)

Posted in Students  4 comments |   23472 Views


Tricks to Format cells in Excel: Trailing Dots

  CA Rishabh Pugalia (ExcelNext)    10 February 2017 at 10:47

Tricks to Format cells in Excel: Trailing Dots

Posted in Students |   24619 Views


Tricks to Format cells in Excel: Date Format

  CA Rishabh Pugalia (ExcelNext)    08 February 2017 at 10:52

Tricks to Format cells in Excel: Date Format

Posted in Students  4 comments |   35370 Views


Converting invalid date formats to valid ones in excel

  CA Rishabh Pugalia (ExcelNext)    10 January 2017 at 10:43

Unclean or Invalid Dates (DMY Format) should be converted to valid data formats.

Posted in Info Technology  3 comments |   23034 Views


Converting numbers with minus sign into negative numbers in Excel

  CA Rishabh Pugalia (ExcelNext)    09 January 2017 at 11:10

Lets see how to achieve this using a hidden trick of Text to Column. Converting numbers with trailing minus sign into negative numbers.

Posted in Info Technology  2 comments |   15784 Views


Changing the data format of a column in excel

  CA Rishabh Pugalia (ExcelNext)    07 January 2017 at 12:59

Transfer Single Columnar Data into Multiple Columns, and customizing the output cell format. (Example: Nos. with zero prefixes such as 000123 must be stored as ..

Posted in Students  6 comments |   14849 Views


Splitting text of one cell in multiple columns

  CA Rishabh Pugalia (ExcelNext)    06 January 2017 at 11:05

Split a name into two columns as last name and first name (Example: AbduSalaam, Ismael)

Posted in Students  5 comments |   19729 Views