Articles by CA Rishabh Pugalia (ExcelNext)

View Full Profile

Splitting text of one cell in multiple columns

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

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

Excel - MIS Reporting

Posted by CA Rishabh Pugalia (ExcelNext) 05 July 2016 64437 Views

Objective: To insert blank row after every line item in Excel (MIS Reporting) Excel Technique used: Dummy Serial Number and SORTStep 1: Create a new column (refer Yellow cell in Column G) and write 1 and 2 Step 2: Select both 1 and 2 an

Excel Trick for Budget vs. Actual Comparison

Posted by CA Rishabh Pugalia (ExcelNext) 05 July 2016 60244 Views

Case Study: Indicate Automatic Status based on whether Actual Production exceeds/equals/trails the Budgeted Production. Sample provided in Picture 1. Application Areas: Budget vs. Actual Comparison, Variance Analysis Techniques req

Technologies for new age CAs & MBAs

Posted by CA Rishabh Pugalia (ExcelNext) 08 November 2014 36379 Views

I am an entrepreneur with work experience in Big Four Audit, Investment Banking and Fixed Income Trading. Being a CA, and having worked in coveted niche spaces, I am often asked by peers and juniors, how to create more career and business opportuniti

Trick - Creating "Addressee Labels" in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 18 February 2014 31374 Views

Step 1 Concatenate (join) the cell contents using & and use CHAR(10) wherever you want the item to shift to the next line. CHAR(10) will help synthetically create the effect of ALT+ENTER or line break Step 2 S

Two new Excel tricks

Posted by CA Rishabh Pugalia (ExcelNext) 18 June 2013 41705 Views

ARTICLE HEADING: 2 EXCEL TRICKS TO IMPRESS Case Study 1: Visualize ratings of employees Application Areas: Feedback/Performance Ratings Techniques required for Solution: Formula =REPT() [Picture 1]: =REPT() formula repeats specified character

Counting instances of Duplicate Invoice Nos. in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 23 April 2013 27100 Views

CASE STUDY: Counting instances of Duplicate Invoice Nos. APPLICATION AREAS: Vendor Payment, Account Credits SOLUTION: =COUNTIFS() EXAMPLE: Step 1: Write =COUNTIFS( Step 2: Choose range of list. E.g. A4:A13 Step 3: Press a

Some Excel Formulas - Part 2

Posted by CA Rishabh Pugalia (ExcelNext) 23 March 2013 49405 Views

Case Study: Cleaning database Deleting the errors Application area: Final Documentation & Reporting Solution: Go To (Special) Formulas with errors Example: Step 1: Select entire data set using Ctrl+A --> Press Ctrl+

Some excel formulas

Posted by CA Rishabh Pugalia (ExcelNext) 19 March 2013 64530 Views

Case Study 1: Compute 7th of next month Application area: Computing due dates of statutory payments based on invoice dates. Used to check whether payment has been made on or before due date.