馃攳
How to maintain monthly personal budget in Excel in just 15 minutes #21days21video - YouTube
Channel: Learn with LOKESH LALWANI
[0]
Guys I hope ke aap ghar pe honge aur safe
honge aap dekh rahe honge ke kuch deno se
[5]
maire channel pe jo videos aarahe hai wo corona
virus related aarahe hai kyuke mai chata tha
[10]
ke iske baare mai ek sach convey ho ek proper
information convey ho kue maine dekha bahut
[16]
sare media me aise hai jinese wo sach convey
nahi ho pa raha tha to har ek video ke liye
[21]
bahut jayada research jarure hote hai taake
sach ka pata chale aur accurate chege convey
[27]
ho payee to bahut saare videos 3-4 videos
maine uske upar baneye to har day i was doing
[32]
research on that topic to karte karte mind
bahut jayada populate ho jaya aur recently
[37]
maine ek video dekha youtube ke uppar jo ke
seekan ek channel hai jaha par wo aap dekh
[42]
sakte hai video ye ek book ke uppar hai jise
mai bataya hai pahele bhe aise crises phele
[46]
ho chuke hai usmai se ek learning mujhe ye
mile ke ye jo crises abhe chal rahe hai uske
[53]
liye aware hona jarure hai alert hona bilkul
jarure hai aur but at the same time calm rahene
[60]
bhe bahut jayada jarure hai kyuke kya hota
hai jitna jayada ham apne mind mai ye cheege
[66]
daalte jayege corona corona se kya hota hai
mind stress out bahut jayada hota hai aur
[71]
jayada stress laine se kya hota hai aapke
immunity decrease hote hai aur usse kya hota
[75]
hai jo corona virus type hai ye innumity ke
upar based hai agar aap ke immunity kam hai
[80]
to wo aapke liye problem creat kar sakta hai
to isliye koshish kareye aapna mind thoda
[86]
sa divert bhe kareye updated raheye bilkul
jarure hai saath me diverted bhe raheye to
[92]
dosto maine ye video banaya hai eske andar
ham baat karne waale hai ke excel ke andar
[96]
aap apne gahr ke roge marra ke kharche kaise
maintain kar sakte hai kaise apne finances
[102]
ko planne kar sakte hai excel ke andar bahut
he simple bahut he aache tareke sai maine
[108]
samjahaya hai aap ko aur iske andar best part
kya hai aapko eske andar pure file ko creat
[114]
nahi karna hai iske andar ham excel ka ek
tamplet use karne waale hai tabhe maine eska
[119]
title rakha ke aap 15min me samajhsakte hai
aur ye mai aapko detai me karke batane waala
[125]
hu ek ek cheege mai aap ko baareke sai samjahuga
ke kaise aapko tamplete milega kaise aap ko
[129]
usme values dalne hai aur ultimately aap ko
pata chelega ke kitna aapne project kiya tha
[134]
expence hone chayee aur kitne huye hai aur
aab aap ke pass kitna pais bacha hai to bahut
[139]
usefull hai aap is video ko jarure end tak
dekheye aap ko bahut iformation milege aur
[143]
agar aapko ye excel ta tempelate nahi bhe
milta koi problem nahi hai maine description
[147]
mai daal diya hai aap waha se download kar
le geye aur saath saath samaj kar esko use
[151]
karte raheye aur agar is video ko aacha lage
to jarure like kareye mujhe bahut motivation
[156]
milega aur maire channel ko jarure subscribe
kareye ga mai hu lokesh lalwani microsoft
[162]
certified corporate trainer aur aap ka tahye
dil se swagat karta hu apne es channel mai
[166]
learn with lokesh lalwani
ok friend to sabse phele mai excel open kane
[175]
ke liye yaha search me jata hu type karta
hu excel aur aap dekhte hai ke excel aajata
[179]
hai mai ispe click karta hu to ye jo enstent
hai xcel ka open ho raha hai aur sabse phele
[185]
es thare se ek look aata hai mai aapko le
chalta hu sabse phele ek option ke taraf jo
[190]
mai aapko batana chata hu ke ye kon sa excel
mai use kar raha hu to aap dekhe to mai jata
[194]
hu account ke taraf aap ka view ho thod adifderent
ho depending on the excel of the version that
[199]
are you using to mai account mai jaake aapko
dekha deta hu ke mai excel 2019 use kar raha
[204]
hu agar aap phele ka bhe version use kar rahae
hai to jayada fark nahi padega mai phelal
[208]
jata hu new ke andar kyuke mujhe ek nai file
open karne hai to mai jata hu new mai aap
[217]
dekhte hai generaly ham kya karte hai ke bkank
excel ko open kar lete hai lakin mai yaha
[223]
per ye nahi karuga hame blank nahi chaye hai
ham ek excel ka predefined tempelet use karne
[230]
waale hai to yahe eske interseting baat hai
ke ham esko kaise quickly use kare waale hai
[235]
to aap dekh rahe hai maire pass already kuch
suggestion dekh rahe hai kyuke mai recently
[239]
cheek kar raha tha ke koon se badeya budget
aur templetes hai jo aap ko dekha sakta hu
[244]
jo ke aap directly use kar paye to maine kuch
try kare thye but personaly speeking mujhe
[248]
ye thoda better laga philal jo ke mai aap
ke saath share kar sakta hu jo ke kafhi common
[252]
cheege hai personal monthly budget to aap
dekhte hai ke neeche kuch templete hai ab
[259]
aap kya kar sakte hai aap koi bhe use kar
sakte hai mai simply jaata hu aap dekh rahe
[263]
hai ye categorised hai mai jata hu budjet
ke andar to jo abhe kaam ka yai es video se
[270]
relate wo hai personal budget insab mai se
mujhe ye wala better laga to isliye maine
[274]
use kiya mai philal jata hu back aur agar
aap ko apne pasand ka koi templete nahi dekhta
[280]
to koi problem nahi hai ye jo saare templete
hai online templete hai yaha par mai search
[285]
kar sakta hu wo templete to aap dekh sakte
hai ke mai connected hu internet se jo ke
[292]
bahut jayada jarure hai to isliye aap connected
raheye aur budget pai gakar ya online cheek
[296]
kar sakte hai aur mai aap ko dekhata hu maine
website open bhe kare hue hai ye microsoft
[301]
web site hai dekhte hai ke kai saare templetes
available hai jarure nahi hai ke wo excel
[306]
kai he ho power point aur word ke bhe available
hai to aap yaha par search kar sakte hai jaise
[312]
bhe maine search kiya hai personal monthly
budget jo ke waha pal available hai to filhal
[316]
mai gata hu excel ke andar jaise ke mai gaya
tha budget mai aur budget ke andar jo phela
[324]
templete hai personal monthly budget mai esko
use karne waala hu to maine ispe click kiya
[329]
to wo bolega creat karne ke liye to mai creat
pe click karta hu to ye open ho jata hai jo
[335]
aap ye sabse phele sheet dekh rahe hai wo
instruction sheet hai aap padh sakte hai esko
[339]
baad me bahut basic information hai philal
mai jata hu personal monthly budget mai aap
[347]
dekhte hai mai esko thoda zoom out kardeta
hu to ye wo sheet hai jo mai explain karna
[353]
chata hu batana chata hu ke aap ko kaise use
karsakte hai to dosto esthare sai ye es mai
[359]
sab given hai to ham loge samajte hai kya
hai cheege hai kaise use karte hai dekheye
[364]
es pure sheet mai hame pure do cheege put
karne hai phela hai projected values dusra
[369]
hai actualy monthly income to projected matlab
jaisa ke ho sakta tha to projected income
[377]
kya hone waale hai to aap niche dekh sakte
hai projected cost ke kya baat hone walie
[383]
hai to aap ko projected bhe batne hai expected
kya hai aur dusra hai actual, actual value
[388]
bhe daalege jo ho chuke hai to aap dekhere
to ye isme bahut detail mai hai mota mota
[395]
values hai jo ham put karne waale hai income
ke baad me aap dekhege expenses hai detai
[400]
mai bahut aache jaise aap dekhege houses se
related gas electricity ye go kharche hote
[407]
hai wo saab entertainment related ho gaye
kuch loan pay kar rahe hai wo aap put kar
[411]
sakte hai ,transportation mai fuel put kar
rahe hai metrose jarahe hai wo aap put kar
[417]
sakte hai to kya aap experence mai value put
kar sakte hai ,texes,food items me jitna aap
[425]
ne kharcah kiya hai saving kar rahe hai ya
investment hai wo aap dekh sakte hai pet reated
[431]
kharcha bhe hai phir jo gift aapne diya hai
wo bhe aap dekh sakte hai personal care aur
[437]
legal related cost hai aur yaha par total
cost nikal aate hai to ham use karne waale
[442]
hai isme jo ke aap figar dekh rahe hai saare
doler mai hai to video ke end mai aap ko batata
[448]
hu kaise ham esko ek baar me rupees mai convert
kar sakte hai.for the time being ham phele
[452]
baat karte hai projected income ke to abhe
mai easy banane ke liye jo abhe value hai
[458]
wo delete kar deta hu sirf itne hai to isme
time nahi lage ga to focus karte hai jo hamare
[464]
projected value hai uske uppar to suppose
maire income hai wo 50000 hai abhe aap dolar
[473]
ko ignore kareye ham ise rupees mai samajte
hai extra income mai manta hu ke 5000 ke extra
[480]
income hai jo mai online classes dedeta hu
ya manlo koi property hai jaha se rent aagata
[486]
hai xyz jo bhe aapke income hoge wo aapne
projected likh de ke aap ko itne income hone
[490]
waale hai to ab baat aate hai projected cost
ke to sabse phele mai housing related baat
[495]
karta hu jo hamare ghar mai kharche ho rahe
hai kya mai rent pay karta hu ya koi mortgage
[501]
hai to mai wo likh sakta hu maan legeye mai
rent pay karta hu kareban 10000Rs similarly
[506]
phone pe kitna expence aata hai 200Rs aata
hai mai kuch randam value yaha par bhar raha
[511]
hu aap dekh sakte hai electricity 500, gas
200rs,water and sewer 150rs,cable 500Rs,water
[522]
removal 50Rs,Maintainence&repair 200Rs ye
major column hai isliye mai aap ko bhar ke
[526]
dekha raha hu supply 15 aap laga lo aur other
mai mai 0 kar deta hu to aap dekhege jo projected
[534]
kharcha jo aaraha hai yo 11950Rs aaraha hai
to uske baad entertainment related mai abhe
[538]
kuch nahi fill karraha wo aap bhar sakte hai
luxury item hai phir aap dekh sakte hai transport
[542]
ke to maan legeye mai yaha pe fule put kardeta
hu ya aap koi bhe expence put kar sakte hai
[548]
maanlegeye mera mahine ka 3000Rs ka kharcah
ho jata hai aur maan legeye maintainence jo
[554]
kareban kareban ho jate hai wo hai 500Rs ke
to 3500Rs iska kharcha aagaya to koi loan
[560]
maine liya hua hai wo mai yaha put kar sakta
hu ya credit cadr jaise credit card mai generaly
[564]
bahut use karta hu to maan legeye 3500 ke
aas pass ka projected hai ke ye mera kharcha
[570]
aane wala hai ye projected hai actual nahi
hai hame ye samajhna bahut jarure hai expected
[574]
hai ke itna aayega. insurance maan legeye
1000Rs per month ke hisab se lagat hai mera
[582]
aur life insurance bhe 1000Rs/month ke hisab
se lagta hai mera ab baat aate hai texes ke
[588]
to jo yaha par federal hai mai usko simply
kar deta hu income tax hamare saral bhasha
[595]
mai aur hamare projected cost jo taxes hunge
hamare wo mai 1000Rs mai dal deta hu matlab
[602]
ke 12000Rs per year ke hisab se. food expences
mai maanlegeye jo mai khane peene ka samaan
[609]
leta ho wo hai 10000Rs baake mai isme aur
kuch put nahe kar raha investment maanlegeye
[617]
mai investment karta hu 1000Rs ke aur cherety
pet mai fihala mai esko nahe dalta aur personal
[627]
care ke mai baat karu wo kareban kareban 500RRs
per month average mera aagata hai related
[635]
to hair nail wagara 500 maanleta hu other
mai mai daaldeta hu 1000Rs legay anyway mai
[649]
abhe insab ke requirement abhe samajta nahi
hu to kareban kareban jo total cost projectred
[653]
cost mai wo aarahe hai 34,950 mai esko thoda
sa bada deta hu 50Rs bada deta hu taake ye
[660]
round off ho gaye 35000 to 35000Rs maire projected
cost hai aur mai maanta hu ke 55000Rs maire
[667]
pass aayege aur 35000 mera kharcah hoga dekh
sakte hai 20000Rs ka balance bachta hai lekin
[673]
ab baat karte hai actual ke to actual income
aaye 48000Rs ke ,maine kuch leaves wagra le
[680]
waha se to ye 5000Rs waha se aya waha se 53000Rs
hue hai ab jo mortgare or rent pay karta hu
[691]
wo same rahe ga to mai use kar raha hu shortcut
Ctrl+R jo left side mai given hai wo yaha
[697]
pe paste ho gaya similarly phone ka same hai
electricity ka badta chadta rehta hai to 600Rs
[710]
mai eska maan leta hu, gas ka 250Rs,waste
removal same,maintainence 150,suplier 200Rs
[717]
to ye kuch random figure kuch maire aaye hai
us month ke complete month ke ab mai neehe
[723]
badta hu aur kya hai maire pass mai fuel jo
mera laga hai wo thoda jayada laga hai maanlete
[730]
hai 3500Rs ka aur maintenaus jo aaye hai wo
thode kam hai 300Rs credit card expences thy
[742]
wo thy 3500 par aaye 3000Rs,500Rs kam he aaye
hai aur texes 1000Rs wo mai 1000Rs he leta
[747]
hu ctrl+r maine use kiya ,health insurance
same hai ctrl+r,life ctrl+r,savings ctrl+r
[757]
,groceries es baar thode varry kargai 11000Rs
aur koi expences isme nahe huye hai baake
[766]
mai seedha chalta hu hamarae personal care
ke uppar to medical exp huye hai 600Rs ,hair
[773]
relatred huye hai 400Rs aur other expences
jo huye hai wo hai 1100Rs to aap dekhte hai
[780]
kareban kareban projecte kharcah tha 35000
lekin jo actual cost aayee hai wo hai 35950Rs
[788]
aaye hai mai esko bhe thoda round off kardeta
hu 1150 mai kardeta hu taake 36000 ho jaye
[794]
kahe na kahe hamare jo cost hai wo jayada
aaye hai socha tha 35000 lekin 36000 aaye
[800]
aur doosre tarak aap dekhte hai income 55
expected thy hue 53 to actual mai jo mere
[810]
taath mai bacha hai wo ye hai.isko mai bold
kar deta hu 17000Rs ab maine boola tha ke
[820]
ham kaise pure figure ko Rs mai convert kat
sakte hai to uske liye mai karna chayuga ek
[827]
kaam chota sa yaha par phele cheege aap ne
dekha hai do thare ke value hai ek ahi numbers
[835]
aur ek hai formulas ye aap dekhege ke saare
formula lage hue hai to mai ek ek karke nahi
[842]
jaauga mai simply press karta hu Ctrl+G matalab
go to special ab special mai gaye ham loge
[848]
aur yaha par mai sabse phele jaauga constants
mai ,contant ke andar text bhe aata hai mai
[853]
usko ignore jar raha hu sirf constant no waala
jo cell hai mujhe uspe jana hai to aap dekhte
[860]
hai shhet mai jitne bhe constant no hai wo
select jo gaye jitne bhe hamne likhe thye
[867]
type kare thye wo select hoo gaye ab simply
mai kya karta hu shortcut ctrl+1 aur yaha
[875]
par mai jayuga currency aur symbol mai mai
search karuga Rs symbol jo maire pass uper
[882]
aaraha hai aur maine press kiya ok to aap
dekhte hai saare Rs me convert ho gaye.lekin
[887]
en ka kya ke ye formula based hai mai dubara
se press karuga ctrl+g special ,formulas formulas
[896]
ke andar mai baake sab to ignore kar sakta
hu hala ke koi fark nahi padega mai simply
[904]
press karta hu ok to aap dekhte hai jitne
bhe formula containing cells hai wo select
[909]
ho chuke hai mai simply kya press karuga ctrl+1
formate cells mai gane ke liye uske baad currency
[917]
symbol rupee ok aur ye bhe convert ho gaye
to abhe maine bataya ke ye wala part chota
[927]
sa arrow bhe daal deta hu aapke liye taake
aapko ye clear rahe ke this is actually ehat
[934]
we are looking for ye jo hamara part hai actual
hai ke hamare pass bache hai 17000 rupee isme
[941]
personaly mera ek input ye rahega ke ye monthly
hai to aap kya karsakte hai jab aap ke pass
[947]
actual hoge to actual to hamne monthly daal
deye lekin aap ko likhne padege jo kahi na
[951]
kahi aapke daily ke expences hoge ke aap ko
yaad rahega ke actual itna bana hai yaha par
[955]
sheet aap apne hisab se add kar sakte hai
jo ke aap kare daily expensis waha par aap
[961]
ne kya likh diya fuel aap ne likh deya to
fuel ke expensis ho gaye food ke expensis
[969]
ho gaye and xyz jaise ke aapne fule kiya 1500rupee
ka aur kahi beach me kiya 500Rs ka phir 1000Rs
[977]
ka to isko aap sum kar legeye aur uske baad
isko waha se link bhee kar sakte hai jo fule
[984]
wala coloum hai jaise ke aap ise copy past
kar legeye ya mai baat karu fuel ke yerza
[990]
to mai press karu equal to aur mai daily expence
me jaa ke ese link kar deta hu enter yaha
[999]
par mere pass ye 300 aagaya to isthare se
bhe aapp ese costomize kar sakte hai aur isthare
[1005]
se ham apne pure month ka budget maintain
kar sakte hai aap ko koi problem nahi aaye
[1011]
ge bahut saaf suthte sheet banke aate hai
dosto i hope ye video aapko pasand aaya aap
[1016]
ko clarity ke jo templete maine deya hai description
mai usko use karke aap es video ko jarure
[1028]
share kaeye ,like kareye aur comment mai lekh
kar bataye aur kon se topic pe chate hai mai
[1041]
video banau agar aap ne mera channel abhi
tak subsribe nahi kiya hai to turant subscribe
[1045]
kareye take care dosto bye bye.
Most Recent Videos:
You can go back to the homepage right here: Homepage