Mega Offer Avail 65% Off in CA IPCC and 50% Off in all CA CS CMA subjects.Coupon- IPCEXAM65 & EXAM50. Call: 088803-20003

CA Final Online Classes
CA Classes

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Two new Excel tricks

LinkedIn


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(s) the no. of times you specify

Case Study 2: Add Zeroes as pre-fix to raw codes of varying lengths so to make all 5-digit code

Application Areas: Data migration, Data cleaning

Techniques required for Solution:  Formula =REPT(), &, =LEN()

[Picture 1]: Input vs. Target Output

[Picture 2]: Find no. of zeroes to be added using the logic =5-LEN (length of existing codes)

[Picture 3]: Repeat zeroes the no. of times as specified by previous step and concatenate (join) using “&” to the raw codes (input)

• CA. Rishabh Pugalia’s other popular articles on Excel tricks at CAClubindia.com – Click Here

• Subscribe to his Online Training Program at CAclubindia. Click Here to watch his sample training videos on VLOOKUP(), Thermometer Charts, What IF Analysis buttons, Time-saver tricks.

• His notes on CA Final - ISCA is available at ISCANotes.com

 Request for in-house Corporate Training for staff members – Click Here


Tags :



Category Students
Other Articles by -
CA Rishabh Pugalia (ExcelNext) 

Report Abuse

LinkedIn



Comments


update