Avail 20% discount on updated CA lectures for Dec 21 .Use Code RESULT20 !! Call : 088803-20003

ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

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

Continue Reading »
Posted in Students  2 comments |   16146 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)

Continue Reading »
Posted in Students  2 comments |   40254 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)

Continue Reading »
Posted in Students  2 comments |   10611 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)

Continue Reading »
Posted in Students  4 comments |   17925 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

Continue Reading »
Posted in Students |   12132 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

Continue Reading »
Posted in Students  4 comments |   24006 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.

Continue Reading »
Posted in Info Technology  3 comments |   11427 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.

Continue Reading »
Posted in Info Technology  2 comments |   14709 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 ..

Continue Reading »
Posted in Students  6 comments |   14166 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)

Continue Reading »
Posted in Students  5 comments |   18837 Views