Articles by CA Rishabh Pugalia (ExcelNext)

Technologies for new age CAs & MBAs

Posted by CA Rishabh Pugalia (ExcelNext) 08 November 2014 36372 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 31363 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

Excel - MIS Reporting

Posted by CA Rishabh Pugalia (ExcelNext) 06 February 2014 64359 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

Two new Excel tricks

Posted by CA Rishabh Pugalia (ExcelNext) 18 June 2013 41701 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

5 Excel Formulas for MIS Reporting

Posted by CA Rishabh Pugalia (ExcelNext) 15 May 2013 602600 Views

Know five MS excel formulas that are extremely useful for MIS Reporting.

Counting instances of Duplicate Invoice Nos. in Excel

Posted by CA Rishabh Pugalia (ExcelNext) 23 April 2013 27077 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

Excel Trick for Budget vs. Actual Comparison

Posted by CA Rishabh Pugalia (ExcelNext) 06 April 2013 60226 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

Some Excel Formulas - Part 2

Posted by CA Rishabh Pugalia (ExcelNext) 23 March 2013 49402 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 64512 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.