Articles by CA Rishabh Pugalia (ExcelNext)

Technologies for new age CAs & MBAs

CA Rishabh Pugalia (ExcelNext) 08 November 2014 at 11:27

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

CA Rishabh Pugalia (ExcelNext) 18 February 2014 at 11:20

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

CA Rishabh Pugalia (ExcelNext) 06 February 2014 at 12:09

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

CA Rishabh Pugalia (ExcelNext) 18 June 2013 at 12:05

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

CA Rishabh Pugalia (ExcelNext) 15 May 2013 at 12:23

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

Counting instances of Duplicate Invoice Nos. in Excel

CA Rishabh Pugalia (ExcelNext) 23 April 2013 at 13:49

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

CA Rishabh Pugalia (ExcelNext) 06 April 2013 at 12:07

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

CA Rishabh Pugalia (ExcelNext) 23 March 2013 at 15:51

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

CA Rishabh Pugalia (ExcelNext) 19 March 2013 at 11:11

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.