banner_ad

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

Posted by CA Rishabh Pugalia (ExcelNext) 17 March 2017 18965 Views

Learn how to compare two columns in Excel


Adding suffix in cells in MS Excel

Adding suffix in cells in MS Excel

Posted by CA Rishabh Pugalia (ExcelNext) 23 February 2017 79391 Views

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


Trick to add digits in a cell in Excel

Trick to add digits in a cell in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 21 February 2017 11956 Views

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


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

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

Posted by CA Rishabh Pugalia (ExcelNext) 15 February 2017 24183 Views

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


Tricks to Format cells in Excel: Trailing Dots

Tricks to Format cells in Excel: Trailing Dots

Posted by CA Rishabh Pugalia (ExcelNext) 10 February 2017 26133 Views

Tricks to Format cells in Excel: Trailing Dots


Tricks to Format cells in Excel: Date Format

Tricks to Format cells in Excel: Date Format

Posted by CA Rishabh Pugalia (ExcelNext) 08 February 2017 35798 Views

Tricks to Format cells in Excel: Date Format


Converting invalid date formats to valid ones in excel

Converting invalid date formats to valid ones in excel

Posted by CA Rishabh Pugalia (ExcelNext) 10 January 2017 23435 Views

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


Converting numbers with minus sign into negative numbers in Excel

Converting numbers with minus sign into negative numbers in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 09 January 2017 15943 Views

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


Changing the data format of a column in excel

Changing the data format of a column in excel

Posted by CA Rishabh Pugalia (ExcelNext) 07 January 2017 14927 Views

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 ...


Splitting text of one cell in multiple columns

Splitting text of one cell in multiple columns

Posted by CA Rishabh Pugalia (ExcelNext) 06 January 2017 19850 Views

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



Popular Articles




banner

Trending Online Classes

view all classess

CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Follow us
add to google news

CCI Articles

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

submit article

Browse by Category




Latest Job Openings

View all
Company
14 May 2026
Financial Analyst - Remote Finance Expert

HiringBridge

Ahmedabad

CA

View Details
Company
ARTICLESHIP 31 May 2026
Article Assistant

KPRS And Associates

New Delhi

CA Inter

View Details
Company
07 June 2026
Tax Associate

Rajkumar Jain & Co.

Ahmedabad

Graduate (Any)

View Details
Company
26 May 2026
Education Content Creator

Adyayam Education LLP

Bengaluru

CA Foundation

View Details
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
ARTICLESHIP 15 May 2026
ARTICLE ASSISTANT, TRAINEE AND PAID ASSISTANT

YOGESH KAPOOR AND ASSOCIATES

New Delhi

B.Com

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details