{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Config","SHORTCUT KEYS","FORMATTING","SORT & FILTER","VALIDATION","Vlookup","IF FUNCTION","SUMIF","COUNTIF","LARGE & TEXT FUNCTIONS","SUB-TOTAL"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":13,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Config","index":0,"n_rows":622,"n_cols":3,"rows_kept":622,"cut":false,"hidden":false,"merged":[]}
["UserName",null,"INFO@EXCELPRINCE.COM"]
["info@excelprince.com"]
["aanchal.kapil23@gmail.com"]
["aayush.bindlish@gmail.com "]
["sharma.abhay298@gmail.com"]
["abhinav.garg579@gmail.com "]
["abhinav.garg005@gmail.com "]
["abhi_katiyar123@yahoo.co.in"]
["abhishekbagh04@gmail.com"]
["abhishek.chaturvedi430@gmail.com"]
["01abhi01@gmail.com"]
["abhishek.srivastavax@gmail.com "]
["abhi.gulati88@gmail.com "]
["adarsh.bhatnagar@gmail.com"]
["anand.aditya100@gmail.com"]
["Aditya.Bhaskar786@gmail.com"]
["adi7289@yahoo.com"]
["afzalansari.ru@gmail.com "]
["ajaycse.semwal@gmail.com"]
["ajay97tyag@gmail.com"]
["ajaythakur4841@gmail.com"]
["ajay.krpjp@gmail.com"]
["anejaa.ajay@gmail.com"]
["rathoreajay177@gmail.com "]
["akashdedha43@yahoo.in"]
["akashrana08@gmail.com"]
["akhil.40602@gmail.com"]
["akhileshkumar.vish@gmail.com"]
["alizaidi282@gmail.com "]
["alokj5@yahoo.co.in"]
["aloksharma_8484@yahoo.com"]
["alok6380@gmail.com "]
["sharmaamit139@gmail.com"]
["amitsharma04@hotmail.com"]
["karansb800@gmail.com"]
["amit.panchalccna@gmail.com"]
["amitnagar1984@gmail.com"]
["singhamy1984@gmail.com "]
["karansb800@gmail.com "]
["amitkumar12109@gmail.com "]
["amitkumar1192@gmail.com "]
["amitnagar1984@gmail.com "]
["amol.kaushik19@gmail.com"]
["lalaankur.iise04@gmail.com "]
["anandy075@gmail.com "]
["rawatani1985@gmail.com"]
["tanianurag1991@gmail.com"]
["akg00786@gmail.com"]
["sharma.anil304@gmail.com"]
["jainanjli508@gmail.com"]
["anjali.goorha@gmail.com "]
["ankitkumar22021984@gmail.com"]
["ak259369@gmail.com"]
["ankitjaindelhi2012@gmail.com "]
["ankur.khanna2184@gmail.com"]
["ank_mittal81@rediffmail.com"]
["ankur.agarwal100@gmail.com"]
["anugupta26sept1990@gmail.com"]
["anugupta26sept1990@gmail.com "]
["rustagi257anubhav@gmail.com"]
["rupeng.singh@gmail.com"]
["anujmalik642@gmail.com "]
["saxena.950@gmail.com"]
["apoorvmudgil91@gmail.com"]
["atriapoorv@gmail.com"]
["aqiqraza24@gmail.com"]
["architmehrotra07@gmail.com"]
["architmehrotra07@gmail.com "]
["kapil.arnika@yahoo.in"]
["arun_tyagi4u@yahoo.com"]
["arun33815@gmail.com"]
["marsexcel@outlook.com "]
["chauhan.arvind1985@gmail.com"]
["arvindrawat1980kv@gmail.com"]
["akdedha123@gmail.com "]
["aktiwary20@gmail.com "]
["ashimnath20@gmail.com"]
["ashishwarikoo@gmail.com"]
["ashishmehra2010@yahoo.com"]
["ashishdixitg@gmail.com"]
["ashish.rawat64@gmail.com"]
["ashishk733@gmail.com"]
["poonia.ashish@yahoo.com"]
["kheti.ashish1984@gmail.com"]
["rawat_ashish05@yahoo.com"]
["ashishtripathi2381@gmail.com"]
["ashishmehra2020@gmail.com "]
["Ashishgupta07051990@gmail.com "]
["asrivastava14oct@gmail.com"]
["atul.kuamr@gmail.com "]
["atulesh.kushwaha@gmail.com "]
["tomar.avinash@ymail.com"]
["avinash.madaeshiya@yahoo.com"]
["avinashsingh.9871@gmail.com"]
["kumaravinash1947@gmail.com"]
["avinashpratapsingh07@gmail.com "]
["avinash.madaeshiya@yahoo.com "]
["avneesh207@gmail.com"]
["Avneesh207@gmail.com "]
["mailforbyas@gmail.com"]
["shabd.niit@gmail.com "]
["bks825@gmail.com"]
["shabd.niit@gmail.com"]
["bhola.thakur1975@gmail.com "]
["bkumarsingh200@gmail.com "]
["bnegi1982@gmail.com"]
["bhupender.aswal333@gmail.com"]
["isshu1989@gmail.com"]
["binoymohanty@gmail.com"]
["binoymohanty@gmail.com "]
["aipbipin@gmail.com "]
["biresh.kumar1991@gmail.com"]
["maddy2689@gmail.com"]
["chandan.2a2@gmail.com"]
["chandan_1june@yahoo.co.in"]
["chandan.bora111@gmail.com"]
["chandankhatri1978@gmail.com"]
["chandan_negi2003@yahoo.com"]
["in.chandankumar@gmail.com"]
["chandan.kumar551@gmail.com"]
["chandan.bora111@gmail.com "]
["singh.chandra439@gmail.com "]
["chandrajeetthakur@gmail.com"]
["arvindchan86@gmail.com"]
["charankrpsprdd@gmail.com "]
["cheitali.aher@gmail.com"]
["chitra.9855@gmail.com"]
["daman.bhatia08@yahoo.com "]
["darshanrajcoolboy@gmail.com"]
["sixerking.singh@gmail.com"]
["debottamroy56@gmail.com"]
["deepak.578@gmail.com"]
["deepaksingh800@gmail.com"]
["deepaktiwari.iba@gmail.com"]
["ranadeepak1978@gmail.com"]
["deepakchandrabhatt08@gmail.com"]
["deepakkr557@gmail.com"]
["deepaksuryan.suryan@gmail.com"]
["deepakbhatt2015@gmail.com"]
["acdeepu@outlook.com "]
["dk91841@gmail.com "]
["tanward14@gmail.com"]
["deepesh.jain@outlook.com"]
["chauhandevender14@gmail.com"]
["devenderk199@gmail.com"]
["devenderk199@gmail.com "]
["arya.satya2008@gmail.com"]
["upadhyaydharmendra8@gmail.com"]
["dharmendra.singh311@gmail.com "]
["dheer4u786@gmail.com"]
["dheerajsharma1993@outlook.com "]
["negidheerendra@gmail.com"]
["chauhan.dhiraj01@gmail.com"]
["chauhan.dhiraj01@gmail.com "]
["digvijay.maurya15@gmail.com"]
["enroy.0072000@gmail.com"]
["dilip2127@gmail.com "]
["cooldskanwal@gmail.com"]
["arya.diensh2001@gmail.com "]
["arya.dinesh2001@gmail.com "]
["cooldskanwal@gmail.com "]
["sdkmdkdtk@gmail.com "]
["ditesh.agarwal@gmail.com"]
["dk@gmail.com "]
["foamshah@hotmail.com "]
["va@ggg.com "]
["gagang741@gmail.com"]
["kumgaurab@gmail.com "]
["gauravmatpal@gmail.com"]
["vatsgaurav1988@gmail.com"]
["gauravsharma1947.gs@gmail.com"]
["gauravkumar4777@gmail.com"]
["gauravakon2@gmail.com"]
["gauravsharma1947.gs@gmail.com "]
["gauravsharma1947@gmail.com "]
["gb171989@rediffmail.com "]
["gaurav.sharma91@outlook.com "]
["vatsgaurav1988@gmail.com "]
["gauravkumar159@gmail.com"]
["pgoyal315@gmail.com "]
["ghannu100@gmail.com"]
["ramayankaram@gmail.com "]
["girja668@gmail.com"]
["gladys.acpmex@gmail.com "]
["sharmag4ever1983@gmail.com"]
["gopalakrishnarao1@gmail.com "]
["mbagurjeet@gmail.com "]
["turabhaider2@gmail.com "]
["om.hari139@gmail.com"]
["dhadra.harish@gmail.com "]
["harmeet244@gmail.com"]
["harry.agr20@gmail.com"]
["himanshujoshi1489@gmail.com"]
["him83.arora@gmail.com "]
["harshharha@gmail.com "]
["hiteshiluthra1@gmail.com"]
["ik88175@gmail.com"]
["imran@khan "]
["arahan2664@gmail.com "]
["inderpalsingh.kalra@yahoo.in"]
["ishantsingh1989@gmail.com"]
["ishu_devesh47@rediffmail.com"]
["jacekkowalski80@o2.pl "]
["singhjai89@gmail.com"]
["jazpaul@yahoo.com"]
["harjeet1.kaur@yahoo.com"]
["jbisht149@gmail.com"]
["jit1983@gmail.com "]
["jitendrakmr289@gmail.com "]
["jbhoj792@gmail.com"]
["jhh@nn.com "]
["john277812002@gmail.com "]
["j.lbs@live.com.mx "]
["jyo_bagga@yahoo.co.in "]
["jyotikarnhr@gmail.com"]
["jyotsnasharma.hsr@gmail.com"]
["jyotsnasharma168@gmail.com "]
["klsh.rawat@gmail.com"]
["kamalraghav289@gmail.com"]
["kamalkumarkhurana@gmail.com"]
["rana.kamal5@gmail.com"]
["kamalnim@rediff.com"]
["kamalnim@rediff.com "]
["kamleshbhardwaj73@gmail.com"]
["kdkapildhaka58@gmail.com"]
["kapiljain1985@gmail.com"]
["iamkaran237@gmail.com"]
["kartikkumar2507@gmail.com"]
["kavya.aadya@gmail.com"]
["khairati@gmail.com"]
["Khushboo.chitra05@gmail.com"]
["jaiswalk_7@rediffmail.com"]
["kishormamgai@gmail.com"]
["kishormamgai@gmail.com "]
["krishankumars5@gmail.com"]
["kd8196@gmail.com "]
["ksr.rawats@gmail.com"]
["ksr.rawats@googlemail.com "]
["lalit.singh@denave.com"]
["lg70030@gmail.com"]
["vijaylalitkumar@gmail.com"]
["lg70030@gmail.com "]
["negi.lalita71@gmail.com"]
["lalitasan1989@gmail.com"]
["surender_s_suri@hotmail.com"]
["lin.li.9299@gmail.com "]
["lokeshkumar100@outlook.com "]
["maheshjsh9@gmail.com "]
["kummah07@gmail.com "]
["maheshswami.13@gmail.com "]
["write2mahip@gmail.com"]
["mananjay.singh1005@gmail.com "]
["manishraturi.86@gmail.com"]
["manishprimenet@gmail.com"]
["manju.rautela91@gmail.com"]
["manoj.singh528@gmail.com"]
["manojgupta.y@gmail.com"]
["manojgupta.y@gmail.com "]
["mayankchauhanmbd@gmail.com"]
["rawat.bisht27@gmail.com"]
["mehzabeenaazmi@yahoo.com"]
["tazz_ans@yahoo.co.in"]
["adnan.friend2014@gmail.com "]
["mohan.spgm@gmail.com "]
["kumar.mohan1993@yahoo.in "]
["nadeem.w2c@gmail.com"]
["khan.mohdzahid@gmail.com"]
["mohitbhalla1988@gmail.com "]
["mohitmittal9918@gmail.com"]
["mohit_m@hotmail.com "]
["mohd4ali1986@gmail.com"]
["mohnish.srivastava@yahoo.com"]
["mokshda1991@gmail.com"]
["monasingh.priya@gmail.com"]
["Monika.rajora.7@gmail.com"]
["monika.rajora.7@gmail.com "]
["Mritunjay.gkp123@gmail.com"]
["mritunjay.gkp123@gmail,com "]
["Mritunjay.gkp123@gmail.com "]
["mugdhakaul@gmail.com"]
["mukeshrana.1214@Gmail.com "]
["mpsarthi@gmail.com"]
["mm_eqbal@yahoo.co.in "]
["mushir222@gmail.com"]
["mushir222@gmail.com "]
["nagendrakarakoti@yahoo.in"]
["nakuldeep08@gmail.com "]
["nand_kishor@hcl.com"]
["n_s_bisht@yahoo.com"]
["bishtn80@gmail.com"]
["jaiswithu@gmail.com"]
["n_s_bisht@yahoo.com "]
["ng.gosain@gmail.com "]
["bishtn80@gmailcom "]
["bishtn80@gmail.com "]
["naresh_sharma2008@yahoo.com"]
["naseem786haider@gmail.com"]
["snav1983@gmail.com"]
["sharmn20@gmail.com"]
["naveenyadav1903@yahoo.co.in"]
["naveen.srivastava@bt.com "]
["naveensrv.2011@gmail.com "]
["navneet.sehrawat91@gmail.com"]
["navneet.sehrawat91@gmail.com "]
["neema9555@gmail.com"]
["neeraj.dhewal@gmail.com"]
["nkumar.saraswat1986@gmail.com"]
["neerajmarut@yahoo.com"]
["NSBHANDARI56@GMAIL.COM "]
["neeteshrajwar@yahoo.com"]
["neha.cool993@gmail.com"]
["nehamalhotrar1@gmail.com"]
["Nehakalra24@yahoo.com "]
["nidhisharma2381@gmail.com"]
["nidhisharma2381@gmail.com "]
["nikhil.npkinfosystems@gmail.com"]
["novemberboyniks89@gmail.com"]
["nimishversatile@gmail.com"]
["nir9650293661@gmail.com"]
["nisar4711@gmail.com "]
["nish7843@gmail.com "]
["nitaichand.biswal@gmail.com"]
["nitinsharma6659@gmail.com"]
["nitinanandworld@gmail.com"]
["yadav.nitin1@gamil.com "]
["nitin_234125@yahoo.com "]
["nizam.husain@gmail.com"]
["onkaripd777@gmail.com "]
["pabitrabelel1995@gmail.com"]
["padamsahoo@yahoo.com"]
["chauhanpk2@gmail.com"]
["pankajgupta89@ymail.com"]
["pchauhan944@yahoo.com"]
["pankajkmrk@gmail.com"]
["pankajnegi261988@gmail.com"]
["pchauhan944@yahoo.com "]
["1pankajsharma1@gmail.com "]
["chauhan.pankaj@indiamart.com "]
["paramdeepsingh13@gmail.com"]
["parth.hbk@gmail.com"]
["parulkumar002@gmail.com"]
["parveenk497@gmail.com"]
["parveshparihar8@gmail.com"]
["pawan092123@gmail.com"]
["pawansaini225@gmail.com "]
["mishramonu81@gmail.com"]
["peeyushduklan@gmail.com"]
["piyush9217@gmail.com"]
["arya121085@gmail.com"]
["polytamuli@gmail.com"]
["pooja.poo28@gmail.com"]
["innovation2319@yahoo.com"]
["ps.deeps0910@gmail.com"]
["singhal.pradeep2007@rediffmail.com"]
["mishra.pradeep.hcl@gmail.com"]
["pradeepconsult9@gmail.com"]
["singhal.pradeep2007@rediffmail.com "]
["pradeep.chauhan15@gmail.com "]
["mishra.pradeep.hcl@gmail.com "]
["linktoprahlad@rediffmail.com"]
["prakashkmr290@gmail.com"]
["prakashkmr290@gmail.com "]
["Guddusanwal@gmail.com "]
["pramod.raghav25@gmail.com"]
["pramod_juyal@ymail.com"]
["pramod_juyal@ymail.com "]
["prashant_jain2005@rediffmail.com"]
["prasantha0906@gmail.com"]
["prashant_jain2005@rediffmail.com "]
["ramola.praveen1@gmail.com"]
["praveenkdhiman@gmail.com"]
["PRAVEENKDHIMAN@GMAIL.COM "]
["jais.preeti@gmail.com"]
["dkbosh82@gmail.com"]
["premnegi@gmail.com"]
["chauhan.prem@gmail.com"]
["prince.sethi09@gmail.com"]
["pkm_madan@yahoo.co.in "]
["ajitabh.mishra86@gmail.com"]
["shuklapriyanka1987@gmail.com"]
["puja.bisht27@gmail.com "]
["wwpunitsharma@gmail.com"]
["pushpraj57@yahoo.com"]
["raghavdevsingh@gmail.com "]
["raghavdevsingh@gmail.com"]
["rkashyap89b@gmail.com"]
["ece08138.sbit@gmail.com"]
["rahul.80s@gmail.com"]
["rahul_grover20@yahoo.com"]
["ece08138.sbit@gmail.com "]
["sainis2012@gmail.com "]
["rajchauhanraj2003@gmail.com"]
["rjkumar335@gmail.com"]
["raushan.raushan123@gmail.com"]
["rkrana122@gmail.com "]
["raj.ilfsnoida@gmail.com "]
["rajan.aggarwal09@gmail.com"]
["rajan.bat@gmail.com"]
["pb_rajeevrana@yahoo.co.in"]
["krishna.ranjan353@gmail.com"]
["rajender_pundir@hotmail.com"]
["raj.sagi33@gmail.com"]
["rajenderk994@gmail.com"]
["raj.sagi33@gmail.com "]
["rajender_pundir@hotmail.com "]
["rajendrsingh023@gmail.com "]
["rajeshkumarkushwah1@gmail.com"]
["rajeshpoddar_2007@yahoo.co.in"]
["rajeshsharma.ggdsd@gmail.com"]
["rajeshranjan86@gmail.com"]
["Rajeshyadav252@gmail.com"]
["rajeshyadav252@gmail.com "]
["sharmaexl@gmail.com "]
["rajeshsharma.ggdsd@gmail.com "]
["raj.bhutna@gmail.com "]
["rajivr9989@yahoo.com"]
["rajiv.375@gmail.com"]
["rajni_dhingra@ymail.com"]
["rajni_dhingra@ymail.com "]
["ram.avatar22@yahoo.com"]
["aavatar22@yahoo.co.in "]
["ramjikumar22@gmail.com "]
["rpm678@gmail.com "]
["r.chandel999@gmail.com"]
["deo.veep@gmail.com "]
["ramjan0203@yahoo.com"]
["ramjan0203@yahoo.com "]
["ramjikumar22@gmail.com"]
["niwasr71@gmail.com"]
["razisartaj@gmail.com"]
["rashmi.yadav1707@gmail.com"]
["rawat.rashmi1987@gmail.com"]
["ratanbhushan.2910@gmail.com "]
["ratnakar7690@gmail.com"]
["ratnesh3132@gmail.com"]
["ratnesh3132@gmail.com "]
["ravi078152@gmail.com"]
["supercoolravi143@gmail.com"]
["Ravisharma0386@hotmail.com "]
["ravindra.kumar432@gmail.com"]
["ravindra.gusain@yahoo.com"]
["makhloga.rina@gmail.com"]
["makhloga.rina@gmail.com "]
["reetizashastri@gmail.com"]
["renubist@yahoo.com"]
["renu.sammi@gmail.com"]
["rishabhagnihotri991@gmail.com"]
["rishioimt@gmail.com"]
["ritssweet16@gmail.com"]
["rohitvishal88@gmail.com"]
["rohit_pandey4@hotmail.com"]
["rohit.citi007@gmail.com"]
["Rohit.ranjansingh1987@gmail.com"]
["rohitdutt11@gmail.com"]
["kumarrohit151094@gmail.com"]
["rohitveryani@gmail.com"]
["rohitkathpalia@yahoo.com"]
["rohit1578@gmail.com"]
["badola.rohit02@gmail.com "]
["writetorohit@hotmail.com "]
["rohithb2b@gmail.com "]
["roshan_ipgcl@rediffmail.com"]
["rupalisajwan@gmail.com"]
["rupeshkmr619@gmail.com"]
["sachine981878@gmail.com "]
["sacchirai98@gmail.com "]
["sacchirai99@outlook.com "]
["kumarsachinsingh1988@gmail.com "]
["sachinkrsharma1986@gmail.com"]
["sachingupta3636@gmail.com"]
["gsachin078@gmail.com"]
["sachin27479@gmail.com"]
["sachink467@gmail.com"]
["sachin.astral@gmail.com"]
["gsachin078@gmail.com "]
["sachin.astral@gmail.com "]
["mk.askari786@gmail.com"]
["samrat "]
["sandeep_saraf8@yahoo.com"]
["sandeepmalik198627@gmail.com "]
["sanjukash605@gmail.com"]
["sanjaybhatt945@gmail.com"]
["sanjay23rawat@gmail.com"]
["skrbokaro.roy@gmail.com"]
["naugai@yahoo.co.in"]
["sanjai.singh896988@gmail.com"]
["sanjaybhatt945@gmail.com "]
["skrbokaro.roy@gmail.com "]
["sanjeev.paliwal@ymail.com"]
["santosh.kumar338@gmail.com"]
["santosh.kumar338@gmail.com "]
["sapna.bhargav9@gmail.com "]
["sapna.bhargav9@gmail.co "]
["sarojkumar092@gmail.com"]
["satyavishwas@gmail.com"]
["kumarsatyndar@gmail.com"]
["saurabhshukla343@gmail.com "]
["saurabh.singh77926@gmail.com "]
["seema2808@yahoo.com "]
["saif.khan191@gmail.com"]
["shailendrakumar.sharma@hcl.com"]
["dubeys5@rediffmail.com"]
["ssind1990@gmail.com "]
["qumarshamsh@gmail.com "]
["shashi.ksingh2013@gmail.com"]
["shashisharma307@gmail.com "]
["mr.shatrunjay@rediffmail.com"]
["mr.shatrunjay@rediffmail.com "]
["shishir.singh@tr.com"]
["vashistha.rma@gmail.com"]
["skumar301@metlife.com "]
["shivam12priyadarshi@gmail.com"]
["shivamsadana@gmail.com"]
["shivani.nanda@yahoo.co.in"]
["shobhit.awasthi3112@gmail.com"]
["shrutijain0490@gmail.com"]
["0490shrutijain@gmail.com "]
["shruti.t.jain@gsk.com "]
["kaushik.shbhm@gmail.com "]
["shwetastar32@gmail.com"]
["sohitsharma@hotmail.com"]
["sourav.singh43@gmail.com"]
["sourabhsh84@gmail.com "]
["sourabhmaindolia@gmail.com"]
["sahusourav@yahoo.com"]
["subhash300790@gmail.com"]
["subodh.kumar999@gmail.com"]
["suchit.kumar02@gmail.com"]
["sudhir.nawani@gmail.com"]
["sudhir.nawani@gmail.com "]
["sumanbhadra40@gmail.com"]
["sumanbhadra40@gmail.com "]
["sumantanwar08@gmail.com "]
["sumittrivedi29@gmail.com"]
["sumitkujur87@gmail.com"]
["sumit.dhaliwal@rediffmail.com"]
["sumitsharmashandilya@gmail.com"]
["sunilsingh6600@gmail.com"]
["sunilbhushan1989@gmail.com"]
["sunilmishra888@gmail.com"]
["sunil.epandey@gmail.com"]
["sunilkumar04051989@gmail.com "]
["sunilbhushan1989@gmail.com "]
["surenderkusharma@gmail.com"]
["surender.bangari144@gmail.com"]
["sushilkumar.insan@yahoo.com"]
["sushil.joshi6k@gmail.com "]
["swatipai480@gamil.com"]
["swatipai480@gmail.com "]
["shusain73@yahoo.com"]
["tanseer1986@gmail.com"]
["tanya.harnal@gmail.com"]
["tapeshgupta57@gmail.com "]
["trinomoy89@gmail.com"]
["uday84dharmna@gmail.com"]
["udishatripathi@gmail.com"]
["mailz2umang@gmail.com"]
["umeshuk1089@gmail.com"]
["upanshusharma@yahoo.com"]
["upendrakumar01@gmail.com"]
["upendrakumar01@gmail.com "]
["uttamsaha9990@gmail.com"]
["satieshvsubramanian@gmail.com"]
["vaishali_gupta1991@yahoo.in"]
["vakil.2011@rediffmail.com"]
["vakil.2011@rediffmail.com "]
["varundubey35@gmail.com"]
["varun.pathak.india@gmail.com"]
["varunsharma786om@gmail.com"]
["varunsingh_786@yahoo.com"]
["taneejja4u@gmail.com"]
["j.venkat.rao2009@gmail.com"]
["j.venkat.rao2009@gmail.com "]
["vibhutibhusanbhatt@gmail.com"]
["vijaykumar1123@yahoo.com"]
["vcvikas5@gmail.com"]
["vdwivedi321@gmail.com "]
["vkmishra1@yahoo.co.in"]
["mivi.vikram@gmail.com"]
["mivi.vikram@gmail.com "]
["vnegi2016@gmail.com "]
["vimalsemwal@gmail.com"]
["Vinaaygarg.4@gmail.com"]
["vineettripathi7868@gmail.com"]
["vineetmalik007@yahoo.com"]
["vineetaverma1805@gmail.com"]
["myselfvipin@yahoo.co.in"]
["vipinchchaudhary1@gmail.com"]
["vickychoudhary578"]
["samuelvipin7@gmail.com "]
["viplab_sinha@rediffmail.com"]
["Vashishtha.idea@gmail.com"]
["viresh.gupta81@gmail.com"]
["vishaal.kohli@gmail.com"]
["vishal_theboy@yahoo.com "]
["vivekthakur419@gmail.com "]
["vivekumarhcl@gmail.com "]
["maiforvyas@gmail.com "]
["mailforvyas@gmail.com "]
["inboxshine9@gmail.com"]
["yogeshsinghnegi1986@gmail.com"]
["yogi4tini@gmail.com"]
["yogeshmehta000@gmail.com "]
["yogesh.mehta000@gmail.com "]
["yogeshsinghnegi1986@gmail.com "]
["yuvastanza@gmail.com "]
["er.zishan21@gmail.com"]
["pandey.pradeep007@gmail.com"]
["rajnesh0001@gmail.com"]
["hiatulraj@gmail.com"]
["00sbhupender7@gmail.com"]
["bisht.lakshya22@gmail.com"]
["rajputvivek64@gmail.com"]
["kuldeeprawat451@gmail.com"]
["sushildobriyal30@gmail.com"]
["shiv34465@gmail.com"]
["jitinchawla@gmail.com"]
["dk1491993@gmail.com"]
["risingstar1947@gmail.com"]
["sumeet1990ster@gmail.com"]
["gaurp.exl@gmail.com"]
["mpuri90@yahoo.com"]

{"sheet":"SHORTCUT KEYS","index":1,"n_rows":35,"n_cols":1,"rows_kept":35,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["Navigation"]
["Move to the next sheet"]
["Move to the previous sheet"]
["Move Right"]
["Move Left"]
["Top of the data in a sheet"]
["Bottom of the data in a sheet"]
[]
["Selecting Cells"]
["Select the whole sheet"]
["Select cells to the right"]
["Select cells to the Left"]
["Select a row"]
["Select a Column"]
[]
["Editing Cells"]
["Insert line within a cell"]
["Insert a Row"]
["Insert a Column"]
["Delete a row"]
["Delete a Column"]
["Format a cell"]
["Cut a cell"]
["Copy a cell"]
["Paste a cell"]
["Paste Special"]
[]
["Formatting Cells"]
["Bold Text"]
["Italic Text"]
["Underline Text"]
["Adjust Row width"]

{"sheet":"FORMATTING","index":2,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
["1. Conditional Format",null,"2. Highlight Duplicates",null,"3. Highlight Using %",null,null,"5. Format Percentile",null,"6. Format Using Icon"]
[">90 G, 55-90 Y,<55 R",null,"Same Values",null,"Values above Average",null,null,"Top 10% & Bottom 10%",null,">90 G, 55-90 Y,<55 R"]
[]
["Column",null,"Column",null,"Column",null,null,"Column",null,"Column"]
[0.23,null,123,null,123,null,null,0.9,null,0.95,null,0.23]
[0.76,null,234,null,234,null,null,0.85,null,0.85,null,0.12]
[0.13,null,456,null,456,null,null,0.6,null,0.6,null,0.13]
[7,null,123,null,890,null,null,0.2,null,0.2,null,7]
[0,null,566,null,566,null,null,0.1,null,0.1]
[0.98,null,123,null,789,null,null,0.11,null,0.11]
[0,null,454,null,454,null,null,0.12,null,0.12]
[0,null,232,null,232,null,null,0.99,null,0.99]
[null,null,454,null,90,null,null,1,null,1]
[0.66,null,112,null,112,null,null,0.21,null,0.21]
[0.7,null,122,null,122,null,null,0.34,null,0.34]
[0.85,null,909,null,909,null,null,0.78,null,0.78]
[null,null,123,null,687,null,null,0.85,null,0.85]
[0.95,null,732,null,732,null,null,0.89,null,0.89]
[0.1,null,123,null,187,null,null,0.11,null,0.11]
[0.15,null,365,null,365,null,null,0.67,null,0.67]

{"sheet":"SORT & FILTER","index":3,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["1. Sort by Values",null,"2. Sort by Format",null,null,"3. Filter by Criteria",null,"4. Reapply Filter",null,"4. Filter More than a column using Criteria",null,null,null,"5. Filter Icon Sets"]
["Number & Text",null,"Color",null,null,">250 & <750",null,">250 & <750",null,"Col 1: Text","Col 2: >90%","Col 3: <300",null,">90 G, 55-90 Y,<55 R"]
[]
["Column",null,"Column",null,null,"Column",null,"Column",null,"Column 1","Column 2","Column 3",null,"Column",null,"Column"]
["PQR",null,0.9,null,null,123,null,123,null,123,0.9,123,null,12,null,12]
["MNO",null,0.85,null,null,234,null,234,null,134,0.85,234,null,98,null,98]
["JKL",null,0.99,null,null,456,null,456,null,145,0.6,456,null,45,null,45]
["GHI",null,1,null,null,890,null,90,null,167,0.2,890,null,87,null,87]
["DEF",null,0.85,null,null,566,null,90,null,12,0.1,566,null,95,null,95]
["ABC",null,0.89,null,null,789,null,90,null,"ABC",0.11,789,null,78,null,78]
[677,null,0.11,null,null,454,null,90,null,12,0.12,454,null,45,null,45]
[167,null,0.6,null,null,232,null,90,null,23,0.99,232,null,23,null,23]
[145,null,0.2,null,null,90,null,90,null,"DEF",1,90,null,99,null,99]
[134,null,0.1,null,null,112,null,112,null,"GHI",0.21,112,null,11,null,11]
[123,null,0.11,null,null,122,null,122,null,"JKL",0.34,122,null,12,null,12]
["JKL",null,0.12,null,null,909,null,909,null,21,0.78,909,null,90,null,90]
["GHI",null,0.21,null,null,687,null,687,null,32,0.85,687,null,68,null,68]
["DEF",null,0.34,null,null,732,null,732,null,"MNO",0.89,732,null,73,null,73]
[12,null,0.78,null,null,187,null,187,null,"PQR",0.11,187,null,18,null,18]
[12,null,0.67,null,null,365,null,365,null,677,0.67,365,null,36,null,36]

{"sheet":"VALIDATION","index":4,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":true,"merged":[[8,0,8,1],[9,4,9,6],[31,10,34,12]]}
["VALIDATION"]
["Data validation is a tool that helps you control the kind of information that is entered in your worksheet. With data validation, you can:"]
["          *  \u0097Provide users with a list of choices"]
[]
[]
[]
[]
[]
["Table",null,null,null,"Data Validation using Conditions"]
["Units","Products",null,null,"Question 2"]
["Assets","Personal Finance",null,null,"No.","Units","Products"]
[null,"Auto Finance",null,null,1]
[null,"Mortgage",null,null,2]
["Liabilities","Current Account",null,null,3]
[null,"Savings Account",null,null,4]
["Fixed","Term Deposit",null,null,5]
[null,"Wakala",null,null,6]
[null,"Takaful",null,null,7]
["Corporate","Trade Finance"]
[null,"Contracting Finance"]
[null,"SME Corporates"]
[null,"Transaction Banking"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"Question : Only Numeric Value should be entered no text value allowed highlighted Range",null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[]
[null,null,null,null,null,null,null,null,null,"d"]
[null,null,null,null,null,null,null,null,null,1,"d"]

{"sheet":"Vlookup","index":5,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":true,"merged":[[13,0,13,1],[16,0,16,1]]}
[null,null,null,null,null,null,null,null,null,null,"TABLE 2",null,"QUESTION 1","QUESTION 2"]
["S. No.","Customer Name","TD Account","TD Amount","Months","Interest Rate","Maturity Date",null,"RM Code",null,"S. No.","TD Account","TD Amount","Avoid \"#N/A\"","USED VLOOKUP","USED INDEX MATCH"]
[1,"E",567,70000,24,4.2500000000000003E-2,"2009-06-01",null,"RM00012",null,1,123]
[2,"D",234,65000,12,3.7499999999999999E-2,"2009-07-03",null,"RM00013",null,2,731]
[3,"C",789,35000,6,4.7500000000000001E-2,"2009-09-12",null,"RM00014",null,3,789]
[4,40519.042361111111,123,20000,3,5.0500000000000003E-2,"2010-04-30",null,"RM00015",null,4,333]
[5,"2010-12-02T13:10:00",123,50000,1,5.7500000000000002E-2,"2011-02-21",null,"RM00016",null,5,987]
[null,null,null,null,null,null,null,null,null,null,6,456]
[null,null,null,null,null,null,null,null,null,null,7,234]
[null,null,null,null,null,null,null,null,null,null,8,211]
[null,null,null,null,null,null,null,null,null,null,9,567]
[null,null,null,null,null,null,null,null,null,null,10,130]
[]
["Question 1"]
["How to retrieve TD Amount for the TD Accounts from a database?"]
[]
["Question 2"]
["How to have the Result without error message?"]

{"sheet":"IF FUNCTION","index":6,"n_rows":62,"n_cols":7,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["Question 1"]
["How to define the below criteria using IF Function?"]
[]
["AGEING CATEGORY"]
["1 - 3 Days",null,null,"CRITERIA"]
["4 - 6 Days",null,null,1,2.75]
["> 6 Days",null,null,2,7.9]
[null,null,null,3]
[]
["CUST NAME","PRODUCT","LEVEL","TAT","AGEING","AGEING"]
["A","CASA",1,1.25,null,"1 - 3 Days"," =IF(D18<=2.75,$A$12,IF(D18<=7.9,$A$13,$A$14))"]
["B","PF",1,2.75,null,"1 - 3 Days"]
["C","MF",1,3.19,null,"4 - 6 Days"]
["D","TD",3,0.31,null,"1 - 3 Days"]
["E","WAK",2,5.62,null,"4 - 6 Days"]
["F","CC",3,7.91,null,"> 6 Days"]
["G","CASA",3,12.39,null,"> 6 Days"]
["H","CASA",1,15.61,null,"> 6 Days"]
["I","CC",2,0.98,null,"1 - 3 Days"]
[]
[]
[]
["NESTED \"IF\" USING \"AND\" FUNCTION"]
[]
["Question 2"]
[]
["IF A40+B40 <= 4, THEN \"Low\""]
["IF A40+B40 > 4 but <= 9, \"Medium\""]
["IF A40+B40 > 9 but <= 14, \"High\""]
["IF A40+B40 > 15, THEN \"Very High\""]
[]
["A","B","RESULT"]
[1,3,null," =IF(A40+B40<=4,\"Low\",IF(AND(A40+B40>4,A40+B40<=9),\"Medium\",IF(AND(A40+B40>9,A40+B40<=14),\"High\",\"Very High\")))"]
[3,6]
[2,7]
[5,9]
[12,4]
[]
[]
[]
[]
["NESTED \"IF\" USING \"OR\" FUNCTION"]
[]
["Question 3"]
[]
["IF \"EXP\" < 1 (or) \"ERRORS\" < 5 then return value is \"Low Impact\""]
["IF \"EXP\" > 1 (or) \"ERRORS\" > 5 then return value is \"High Impact\""]
[]
[]
["NAME","EXP","ERRORS","RESULT"]
["A",0.75,3]
["B",1.35,6]
["C",4.5199999999999996,7]
["D",2.54,9]
["E",0.51,4]

{"sheet":"SUMIF","index":7,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":true,"merged":[[18,0,18,2],[21,0,21,2],[24,0,24,2],[27,0,27,2]]}
["Month","Week","Appl Received","Appl Rejected","Appl Processed"]
["Jan","WK 01",23,5,18]
["Jan","WK 02",13,3,10]
["Jan","WK 03",15,1,14]
["Jan","WK 04",34,14,20]
["Feb","WK 01",23,16,7]
["Feb","WK 02",14,2,12]
["Feb","WK 03",45,7,38]
["Feb","WK 04",21,13,8]
["Mar","WK 01",14,6,8]
["Mar","WK 02",13,19,-6]
["Mar","WK 03",23,10,13]
["Mar","WK 04",26,12,14]
["Apr","WK 01",13,8,5]
["Apr","WK 02",25,4,21]
["Apr","WK 03",27,12,15]
["Apr","WK 04",24,23,1]
[]
["Question 1"]
["How to know total \"Appl Received\" for the month of Jan?"]
[]
["Question 2"]
["How to know total \"Appl Rejected\" for Jan month alone?"]
[]
["Question 3"]
["How to know total \"Appl Processed\" for Jan alone? (Appl Processed = Appl Received - Appl Rejected)"]
[]
["Question 4"]
["How to know total \"Appl Processed\" for all months excluding \"Jan\"? (Appl Processed = Appl Received - Appl Rejected)"]

{"sheet":"COUNTIF","index":8,"n_rows":34,"n_cols":32,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
["ATTENDANCE SHEET",null,null,null,"P - Present",null,null,"A - Absent"]
[]
["NAME",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
["A","P","A","P","P","P","P","P","P","P",null,null,null,"A",null,"A","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P"]
["B","A","P","P","P","P","P","P",null,null,"P","P","P","P","P","P","P","P","A","A","A","A","A","P","P","P","P","P","P","P","P","P"]
["C","A",null,"A",null,null,"A","A","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P","P",null,"A","A","P"]
["D","A","A","A","A","A","A","A","A","P","P","P","P","P","P","P","P","P","P","P","P","P","A","A",null,null,null,null,null,"A","A","P"]
[]
["Question 1"]
["How to find out the number of days \"Present\"?"]
[]
["NAME","DAYS PRESENT","Output required"]
["A",null,24]
["B",null,23]
["C",null,21]
["D",null,14]
[]
["Question 2"]
["How to find out the count of \"Blanks\" against all the names?"]
[]
["NAME","COUNT BLANKS","COUNT BLANKS"]
["A",null,4]
["B",null,2]
["C",null,4]
["D",null,5]
[]
["Question 3"]
["How to find out the count of \"Non-Blanks\" against all the names?"]
[]
["NAME","COUNT NON-BLANKS"]
["A"]
["B"]
["C"]
["D"]

{"sheet":"LARGE & TEXT FUNCTIONS","index":9,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["CUSTOMER NAME","WAKALA DEPOSIT","QUESTION 3 (SMALL LETTERS)","QUESTION 4 (NORMAL LETTERS)","QUESTION 7 (LEFT)","QUESTION 8 (RIGHT)","QUESTION 9 (LENGTH)","QUESTION 10 (MID)","QUESTION 11 (TRIM)","QUESTION 12 (CONCATENATE)"]
["ELIA    ISLAND REAL ESTATE LLC",2500000]
["SMART 3 FZ LLC",3500000]
["OGLE MIDDLE EAST LLC",2100000]
["EGHBAL GENERAL TRADING FZC",108000000]
["EVOLUTION TRADE FZE",567000]
["SPAN IMAGE (FZC)",6127609]
["TECHNO ENGINEERING SERVICES PVT LTD",187876876]
[]
[]
["Question 1",null,null,"Answers"]
["How to find out the fifth largest Deposit amount from the above list?"]
[]
["Question 2"]
["How to find out the least Deposit amount from the above list?"]
[]
["Question 3"]
["How to convert the \"CUSTOMER NAME\" in to small letters?"]
[]
["Question 4"]
["How to convert the \"customer name\" in to normal letters?"]
[]
[]
["Question 7"]
["How to extract a first 5 characters to the Left from a text?"]
[]
["Question 8"]
["How to extract the last 5 charatcers to the right from a text?"]
[]
["Question 9"]
["How to calculate the length of a word?"]
[]
["Question 10"]
["How to extract 10 characters starting from the 5th character of a text?"]
[]
["Question 11"]
["How to remove unwanted spaces between words/characters mentioned below?"]
[]
["Unwanted                      Space"]
[]
[]
["Question 12"]
["How to join the below two words in to one with space in between?",null,null,"Output should be like below"]
[]
["Training"]
["Session"]

{"sheet":"SUB-TOTAL","index":10,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
[]
["Case ID","Product","Complaint Types","Count","TAT (Days)","Ageing Category"]
[2323,"CASA","Maintenance Fee",60,8.7100000000000009,"> 6 Days"]
[4303,"CASA","Salary not Cr.",8,7.01,"> 6 Days"]
[2070,"CASA","Cash dep not Cr.",10,4.57,"4 - 6 Days"]
[3747,"CASA","Chq dep not Cr.",11,2.13,"1 - 3 Days"]
[1652,"CASA","SMS not recd",12,1.87,"1 - 3 Days"]
[3217,"CASA","Txn decl cash not disp",4,2.75,"1 - 3 Days"]
[2133,"Credit Card","Late Fee Charges",12,1.22,"1 - 3 Days"]
[7673,"Credit Card","Monthly Fee",34,1.75,"1 - 3 Days"]
[4566,"Credit Card","Annual Fee",9,3.21,"1 - 3 Days"]
[3245,"Credit Card","Profit Charge",20,5.1100000000000003,"4 - 6 Days"]
[8769,"Credit Card","Overlimit Fee",34,2.87,"1 - 3 Days"]
[8732,"Credit Card","Cash dep not Cr.",5,3.31,"1 - 3 Days"]
[6534,"Credit Card","Stmnt not recd",10,4.45,"4 - 6 Days"]
[9878,"Credit Card","CC not recd",22,7.21,"> 6 Days"]
[7656,"Credit Card","Stmnt chgs",13,6.54,"> 6 Days"]
[3245,"Credit Card","Wr SI option",5,1.03,"1 - 3 Days"]
[8767,"Credit Card","Txn rejected",17,0.83,"1 - 3 Days"]
[]
["Question 1"]
["How to find \"Average TAT\" for different Products?"]
[]
["Question 2"]
["How to group data based on \"Product\"?"]
["????"]