Avail 20% discount on updated CA lectures for Dec 21 .Use Code RESULT20 !! Call : 088803-20003

ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Articles by CA Rishabh Pugalia (ExcelNext)

avatarView Full Profile

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

Continue Reading »
Posted in Students  10 comments |   36090 Views


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

Continue Reading »
Posted in Students  7 comments |   30924 Views


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

Continue Reading »
Posted in Students  24 comments |   59523 Views


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

Continue Reading »
Posted in Students  8 comments |   41205 Views


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.

Continue Reading »
Posted in Students  27 comments |   530208 Views


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

Continue Reading »
Posted in Students  12 comments |   21996 Views


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

Continue Reading »
Posted in Students  24 comments |   57537 Views


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+

Continue Reading »
Posted in Students  18 comments |   48936 Views


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.

Continue Reading »
Posted in Students  55 comments |   62349 Views