Articles by CA Rishabh Pugalia (ExcelNext)
View Full Profile
5 Excel Formulas for MIS Reporting
Know five MS excel formulas that are extremely useful for MIS Reporting.
Converting numbers with minus sign into negative numbers in Excel
Lets see how to achieve this using a hidden trick of Text to Column. Converting numbers with trailing minus sign into negative numbers.
Converting invalid date formats to valid ones in excel
Unclean or Invalid Dates (DMY Format) should be converted to valid data formats.
Adding suffix in cells in MS Excel
Tricks to Format cells in Excel: Format Cells in Excel (Suffix)
Tricks to Format cells in Excel: Trailing Dots
Tricks to Format cells in Excel: Trailing Dots
Tricks to Format cells in Excel: Date Format
Tricks to Format cells in Excel: Date Format
Changing the data format of a column in excel
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 ...
Learn how to compare two columns in Excel
Learn how to compare two columns in Excel
Trick to add digits in a cell in Excel
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)
Popular Articles
- Individual Income Tax Return Filing Due Dates for FY 2025-26 (AY 2026-27)
- New Column in ITR For AY 2026-27: "Receipts Not in Nature of Income" - What Is It?
- Section 44ADA of the Income Tax Act: Latest Rules and Questions Every Professional Asks
- PNB FD Interest Rates 2026 for 444 days: Maximize Your Returns Without a Long Lock-In
- AIS Income Tax Transactions: What to Report and What to Skip in AY 2026-27?
- Income Tax Demand Notice 143(1): Know Why You Received It and What to Do Next?
- ITR Processing Time 2026: Know How Long Will It Take and What Each Status Message Means
- Income Tax Update: How to Transfer TDS From Wife to Husband's ITR?
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
