GST Plus - Get Daily updates,support, whatsapp Group & reply to GST Notices etc.!! Call : 011-411-70713 !!

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 |   16197 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 |   40518 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 |   10632 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 |   17976 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 |   12282 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 |   24225 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 |   11484 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 |   14727 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 |   14184 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 |   18849 Views