LIVE GST Certification Course by CA Arun Chhajer begins 3rd April. Register Now!

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

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 |   17547 Views

Adding suffix in cells in MS Excel

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 |   58980 Views

Trick to add digits in a cell in Excel

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 |   11148 Views

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

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 |   19053 Views

Tricks to Format cells in Excel: Trailing Dots

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 |   17112 Views

Tricks to Format cells in Excel: Date Format

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 |   28602 Views

Converting invalid date formats to valid ones in excel

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 |   15678 Views

Converting numbers with minus sign into negative numbers in Excel

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 |   15147 Views

Changing the data format of a column in excel

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 |   14451 Views

Splitting text of one cell in multiple columns

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 |   19155 Views




Popular Articles




Follow us Zoho Course 2023

Trending Online Classes

GST Practitioner Certificate Course 35th Batch
CA Arun Chhajer
Enroll Now

Refresher Course on Bank Branch Audit
Sachin Jain
Enroll Now

Excel Interactive Dashboards and Data Analysis Certification Course
CA Deepak Gupta
Enroll Now
view all classess


CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Stay updated with latest Posts!


Browse by Category