15 Best Excel Formulas | Punjab & Haryana Steno CPT Exam | Excel Spreadsheet Test Practice

[@OfficeGuruji]

*Please Watch Full Video*

[@vplable]

The way you are working hard for us i really appreciate your efforts sir thanks a lot🙏❤

[@OfficeGuruji]

Thank you for appreciating

[@stenographersuraj8043]

Thanks Sir .... You are the best....& Your way of explaining is very nice..

[@OfficeGuruji]

Thank You

[@shikhajain5536]

Supurb sir. M 2500 ke class lgae 15days. Bs wastage of time totally. But ur class is really supurb 👌👌

[@shiviiisolanki]

This vedio is very helpful for me 👍👍

[@abhineetshrivastava5356]

Thank you so much sir...

[@virpalkaur2920]

Splendid session sir

[@gorikathakur7969]

Thankyou sir, 🙏

[@growknowledge3156]

Thanks again guruji 🙏🙏

[@SunitaSingh-ue5zi]

U r great sir

[@OfficeGuruji]

Thank You

[@artistneha04]

Thank you so much great information

[@dhiraj9997]

very fabulous sir .. !

[@nehakudiya10]

Thank you so much... tomorrow is my CPT exam..wish me luck 🙏

[@parisingroha9935]

Hey neha...kya m jan dkyi hun ki exam kaisa hota h cpt vala i mean spreadsheet m qstn kaise yhe and typing test m paragraph kaisa tha please reply...it will be beneficial for me to know

[@nehakudiya10]

Hi Pari, CPT exam bohot easy aata hai ek table di hui hoti hai or data given hota hai hume Percentage, Minimum, maximum ya mean find karna hota hai ya bold or highlight karne ko kaha jata hai..or typing me bhi simple paragraph hota h agar typing ki speed aapki thik hai toh koi problem nhi aayegi..or agar speed Kam h toh bhi aap kam time me practice karke typing test clear kar sakte ho..All the very best dear 👍

[@parisingroha9935]

@@nehakudiya10 thanku so much neha...meri speed abhi bhut km h..kya keyboard ko dekh kr typing krna shi h i mean aap try kr chuke ho so aapko experience h..please reply if you have time ..otherwise am grateful to you...

[@nehakudiya10]

@@parisingroha9935 dear agar aapka exam bohot pass hai toh aap daily 4-5 hrs typing ki practice karo..aap kisi bhi eng book ya magazine se practice kar sakte ho..just focus on accuracy..book/magazine se words dekho or screen par dekho... keyboard par mat dekho..jitna jyada practice karoge aapka confidence raise hoga..exam me koi problem nhi aayegi..

[@parisingroha9935]

@@nehakudiya10 thanku so much for your guidance neha i think you have qualified the CPT...vese abhi date to nhi aayi h ..phir bhi I'll try..to increase my typing speed

[@rajsharma-vd8ff]

Thank u so much sir.....for this vedeo

[@sbarjinder651]

Thanku sir 😊💯❤️

[@shikhajain5536]

Sir mera ek question hai plzz reply 👏👏 Sir percentage increase or decrease. Ek coloum m aapne increase Kiya or ek m decrease. Aisa kyu.?? Drag ni krna tha??

[@jyotithareja2404]

Thnku so much sir for this wonderful video....sir vlookup b aa skta h exam m

[@kunalsingh-uw2rn]

Sir thnk u Sir ek vedio different formating in execl ki ek vedio provide kijeye punjab and haryan high court k lea formula bata dea apne ap formating aor ek print option bhi batana pora confidence aa jae ga papaer mae pls provide kr de jea

[@sunitajain2530]

Sir increase or decrease m first ek column increase or dusra decrease ka formula lgana h??

[@PASCIHC]

Thank you sir..

[@pritisingh1535]

Sir, I have qualified my punjab and haryana high court clerk written exam recently, plz give some guidance how can I crack my computer proficiency test plz reply sir.

[@yogikumar6773]

Sir spreadsheet exam me backspace kaam karega

[@RohitGupta_0]

Sir plz date setting ki video bna dijiye

[@devsindhu2688]

Thanx sir

[@OfficeGuruji]

Welcome

[@PASCIHC]

Sir aaj or kch important cheze kra dijiye... Agr bchte h to

[@drishtika__238]

Sir absolute increase/decrease vaale column mei percentage to nhi pucha hua.... percentage format mei hi likhna ???

[@kalamkirukhse]

How to add percentage sign, if there is a heading to find percentile in a coloumn.

[@OfficeGuruji]

Click on percentage icon

[@sharifsallu2507]

Sir yadi 2013 and 2014 ka difference diya hua ho to % Inc/dec aese hi nikale ya difference se nikale...??? Plzz🙏 sir reply quickly

[@OfficeGuruji]

Percentage to aise hi niklega

[@arshdeepkaur3886]

Sir.....for calculating the age....do we need to write DOB as Month first....

[@saurabhsinghnegi6779]

yes

[@TheIndianWay_]

Sir ye sum substraction multiplication division wala smjh nhi aa rha

[@divyamehta7489]

Nyc

[@OfficeGuruji]

Thank You

[@amitkumar-bu3jb]

Sir absolute increase/ decrease me only increase/ decrease btana h %age nhi

[@kalamkirukhse]

I have another doubt how to solve < > (less than or greater than) by any formula.

[@shipraparihar4384]

Iske next year vacancy me written exam hoga haryana Punjab ka uska bhatao

[@soniasharma7519]

Sir agr ek column m kg m value di hui h...to gms m krne k lie separate column bnana padega?

[@OfficeGuruji]

Agar question paper me bola jaye draw a column to banana padega nahi to kisi blank column me bana ke Paste as Values kar sakte hain

[@saurabhsinghnegi6779]

@@OfficeGuruji Sir mere pc me convert ke formulae nhi show hore kya problem hai? pls give any solution.

[@sonusainsonusain3626]

Sir age vala formula lag hi ni rha what to do plsss reply sir

[@OfficeGuruji]

Check date format and enter Y within double quotes

[@Dilipkumar-dz9nt]

Sar mera exam tha sb kr dia bs ek line bold nhi kiya to ky pure 2 marks kategne sar reply

[@OfficeGuruji]

May be

[@pritihanot7970]

Sir haryana high court ka result kab tk ayga any idea? Thanks in advance

[@user-tk5yc1gk5k]

Technical guriji ki trh bol rha h ye

[@sonusainsonusain3626]

Tnx sir its really very helpful

[@drishtika__238]

Thanku sir 💫💫

[@prabharneja0597]

thankuu sir

[@OfficeGuruji]

Welcome

[@Amanpreet_singh92]

Thankyou sir.