Excel Complete Formula Tutorial தமிழில் 6 மணி நேரத்தில் கற்றுக்கொள்ளுங்கள் | Tutor Joes

[@mathumathu3586]

Excel கேட்ட மாதிரி video upload செய்ததுக்கு மிக்க நன்றி sir

[@hariraman4488]

Extraordinary explanation... Yesterday I started to watch at 6pm.. Till 12o clock i completed everything... Today I m practicing everything... Super sir... I would really appreciate ur efforts to making this video.. Content are sharp and into the point.. Highlight is Your Voice.. it's not hard .. pleasant to hear a soft voice..

[@oneminute6168]

Im srilankan.... You are my God sir..... course seithale enakku padikanum enkira thought vanthathilla sir... ugka voice rompave enna motive pannikode irukkuthu sir.... tnx sir...

[@tutorjoes]

You are welcome

[@mr.vijayakumarsathya662]

00:00 : Basic Sum formula 1:22 : 5 Different types of Sum formula. 3:20 : Running total formula (Bank balance) 6:20 : Setting Name for a range. 10:50 : SUMIF function. 12:30 : function of Statistical formula 1. Count function (remember that this is a count and not sum, i. e. It counts the nominee). 2. 15:40 : "countif" function. 3. 17:10 : "countifs" function. =SUMIFS(sum total, range, condition, range, condition). 25:30 : LEFT, MID & LEN functions. LEN : to find the no. of letters used in a cell(i.e.) "LENGTH". 27:02 Formula : =LEFT(select a cell having name with year,LEN(total length of the text)-6). e.g: LEFT(A2,LEN(A2)-6) Whereas, 6 is the integer value of the year with ( ) bracket. 1+4+1: (2021). 29:00 Mid function : =MID(select a cell having name with year),LEN(same cell to find the total length)-4,4) e.g: =MID(A2,LEN(A2)-4,4). Whereas, -4 is from the last how many letters, numbers we require. 4 is length (i.e) 1992 length of the year. If the value is 2, it results only 19. If the value is 3. It results only 199. Since the given value is 4 it displayed 1992.

[@kiritharanvinoya9388]

மிகவும் நன்றாக கற்பிதீர்கள் மிக்க நன்றி.🙏

[@tutorjoes]

Full HD Complete Excel Formulas with real time example.All of you can learn complete office automation in Excel Tamil. Please view like share and subscribe.For Better performance user laptop or desktop to view this video.

[@ahamedkabeer3985]

Happy sir you are my good teacher. God bless you

[@புன்னகைபடைப்பாளி]

மிக்க நன்றி சகோ easiya kathukuramari solli irukinga

[@HariKumar-ru9no]

Sir, I really appreciate ur hard work... Keep doing

[@meenahariharan7682]

Hai sir, I'm addicted ur teaching style...because very clear, and very neat explained... Ur videos very useful not only.... Most of the person watched and watching...... Interview LA excel question ketanga... Eanku unga videos LA Pathu practice panen... Very useful for my interview sir... Very excellent sir.. And I have one doubt sir, plz explain sir. Datedif() formulas doubt ah iruku sir... I tried that, but I haven't answer sir..

[@tutorjoes]

Thanks you can see our date time function on playlist

[@meenahariharan7682]

@@tutorjoes OK sir, thanks for reply

[@udhayasankar2459]

Sir your teaching very very very satisfied sir thanks sir

[@YuvarajAravind]

Sir I should appreciate your efforts for doing this work.. Also if you provide us time stamp for all formula in the description, that would be great. Becoz you know the entire video. Not everyone can see entire 6 hours videos.. If possible kindly share the time stamp

[@vijayanandhi5416]

Excellent tutor ,clear explanation

[@sihskokkudi1140]

Sir, this video useful to me and MS EXCEL all menu full course video podunga sir in tamil pls.

[@redhorse5721]

Romba romba useful ha irukku bro very nice....

[@tutorjoes]

Your are welcome

[@V.MaheMahendran]

வீடியோ மிகவும் பயன் உள்ளது

[@maisulhana4558]

is this video enough to master excel and also please upload wordpress website design course complete tutorial .your tutorial is very nice.I am watching and learning from london .Thank you very much for your clear videos and explanations.

[@sakthivel588]

Super sir...very useful in excel user..and thank u sir

[@tutorjoes]

You are welcome

[@sathikali4923]

Tnx for ur tutorial videos

[@suriyaprakashs21]

Sir, this video useful to me and VBA full course video podunga sir pls.

[@karthikraja_b]

Video Liked, Saved.

[@kaviarasu6793]

Super sir very useful 👍👌

[@udhayasankar2459]

Google sheet ley than Nan work pannithu irukiren Google sheet complete teaching Pannuinga sir enekum en business kum romba romba usefulla irukum sir please help me sir 🙏🙏🙏🙏

[@liakathalia8314]

Very good teaching sir

[@prasannavenkadesh6045]

Thanks anna..... c# language and php language complete video upload pannuga anna pls

[@yuvaraju4266]

Sir, please make videos on Financial functions in excel

[@bharathm1901]

this video required alot of hard work, thankyou soooo much for that bro

[@suganyas4452]

Please upload Video MS - Excel use payroll Sir. Thank you Sir🙏

[@liakathalia8314]

Good teaching sir

[@ImranImran-nf7nd]

Sir.. thank you uploading this video

[@tutorjoes]

You are welcome

[@vaishuvenkats9959]

Wait for other excel tab menu by menu like home tab excel fulla complete tutorial podunga sir.. Please

[@sihskokkudi1140]

Sir, MS EXCEL all tools full course video podunga sir in tamil pls.

[@amir8140]

Sir unga voice 😍

[@bhaskaransundaram3287]

Thanks for your effort, god bless you, are from salem?

[@GopalKrishnan-wz2mw]

Very useful

[@karthicksj1936]

Which is best jQuery or javascript

[@selvakalai1234]

சூப்பர் bro

[@bahurudeenneerai6871]

நன்றி

[@gioonlineshopping7564]

Thank you sir... 🙏🙏🙏👏👏👏

[@ddr8774]

Super sir.

[@kowsikasengottuvel3345]

Sir one request...I am computer science student..But enaku oru clarifications ehh ila sir..I need to become a computer professor..coming to my point i just only know the language basics and liitle knowledge of msoffice...but na kekarathu enana..what are the basic and essential software and too essential programming languages...enaku unga channel teaching romba easy ahh iruku..i need to clear about basic softwares based on my career..sir plz kindly reply to me..i follow ur guidance sir plzzz..try to reply sir

[@kowsikasengottuvel3345]

Plz reply sir...ms office,OS,c,c++,java,html,tally,vb,os installation,web tech,Computer network...like this i ask u sir..plz guide me for my question

[@ajithkumar2868]

Text me

[@avinesh1664]

thank you so much for this video

[@aandrewsraj]

great work joe

[@ammaiappans883]

sir sum formula running totala fixed vaiga solranga atha yappadi vaigirathu

[@Karthikeyan-qy8ql]

Iam Waiting Complete Ms power point tutorial sir

[@subramaniyamnithusan9330]

Sir C socket programming tutorial சொல்லிதாங்க.sir

[@avinesh1664]

thanks alot sir

[@nagarajan3451]

Excel with VBA ... 1, Purpose of usage 2, How to use.. Explain pannuga bro... I really happy to this video...

[@tutorjoes]

I will do separate video for that soon

[@nagarajan3451]

@@tutorjoes Tq... We are waiting...

[@ahamedkabeer3985]

Super sir

[@manoharanpjs3905]

continue the power point video

[@nvigneshnvignesh8755]

Running total la value epdi sir fixed reference ahh charge pandrathu athuku enna short cut solluga sir waiting...........

[@babugrlygovindan9752]

Thanks you sir

[@arisharif3780]

Sir enakku gst file panna excel automatics formet poduga sir

[@ezhumalai4151]

HAI SIR i have seen your all excel videos and its very useful for me and i have one doubt in excel. how to create the multi words in one cell with different color's. for ex. three different words(go,stop,ready). if i select go word color should be green, if i select ready means should be yellow color.

[@saranyakumar5237]

2019 word complete pannunga please sir...iam learning

[@vigneshv146]

Bro plz continue tally playlist Plzz upload more advance tally classes like gst+.... Etc

[@YASININFOTECH]

நண்பர்களே எனது சேனலில் GST, Tax payments, online Registration, banking , eFilling, Act & Laws தொடர்பான காணொளிக்கு எனது சேனலை ஆதரியுங்கள் ( Yasin Info tech)

[@TSH762]

@@YASININFOTECH Please provide your contact no sir

[@devadarshinipakkiyaraj9871]

Sir, I need addition, subtraction in excel sheet with conditional basis to find requirement quantity. Can you guide me sir if you don't mind.

[@afsalmohamedkani.m9693]

Practice ku sheet podunga

[@viayvijayraj8374]

Good

[@nanbantec]

Thank You Sir..

[@tutorjoes]

Most welcome

[@balakumarcbe1984]

thanks

[@banuprakash4557]

Sir python full course podunga sir matha chennal check panni pathathula onnu onnu puriya matenthu neenga solrathu easy ha understand Panna mudiuthu wait for python course sir

[@tutorjoes]

Python preparation going on within this month I will sure upload complete core

[@banuprakash4557]

@@tutorjoes thank you sir

[@findthings]

Graphics design videoa poduvingala bro

[@deepasriworld6362]

Very useful sir thank you

[@tutorjoes]

You are welcome

[@felisafelixraj4569]

luv it

[@mujiprahuman6713]

I dex &Match kkum Data Validation kkum Enna sambandham

[@mrkkeyan2335]

Great job sir 💐💐☺️

[@tutorjoes]

Your are welcome

[@avanthyanu1618]

Sir kindly upload gst course

[@tutorjoes]

Not now we will do soon

[@mujiprahuman6713]

Brother Indha " " Symbol Excel Formula La Confirm Apply Pannanumaa . Pls Tell me

[@sureshe2345]

Sir practise document eppadi sir edukarathu

[@chilly4464]

Sir fixed reference na enna key press pannanum

[@vikrampandian5296]

Anna flutter la authentication method use pannama firebase db vachu login screen apdi pannurathu nu soilli kudunga anna

[@tutorjoes]

Sure I will do soon

[@vikrampandian5296]

Anna enoda clg ku app ready pannetu eruken ui full ah muduchuten anna ..backend mattum soille kudunga username and password vachu soille kudunga anna plz

[@vaseekaranvijaysurya9768]

Thanks a lot sir....

[@tutorjoes]

You are welcome

[@vaseekaranvijaysurya9768]

Sir please upload python full course , and numpy and Django frameworks .... Many python tutorial was available but I'm waiting for you sir , because your teaching skills very easy to understanding .. Eagerly waiting sir🔥

[@vaseekaranvijaysurya9768]

@@tutorjoes Sir I had one doubt .. Sir my MS WORD & MS EXCEL 2013 VERSION How to update latest version

[@vaishuvenkats9959]

Excel menu by menu complete tutorial podunga sir only home tab mattum than iruku innum data formula page Layout insert review view ellom podunga sir please kindly arrange...

[@tutorjoes]

Ya it's make some time to complete the whole video due to covid 19 sure I will do soon

[@vaishuvenkats9959]

@@tutorjoes thank you so much sir i wait for u......

[@prema5075]

Great content 👌

[@tutorjoes]

Thanks for your support ❤️

[@shivaprasanna4679]

Hey Sir! Your video and your teaching is great Was this video covered the #ADVANCED_EXCEL level? Hope I get the reply soon. Thanks for your valuable time

[@gowsia2202]

Bro thank you. Excel video potathuku but menus video already potu erukinga ethaum potringa atha follow panrathu please tell me I am confused but menu by menu ninga potathu than fulla cover paninga antha video kum entha video kum aana differents sa video starting la solunga bro

[@tutorjoes]

This is formula only video.menu by menu is different serious

[@subramaniyamnithusan9330]

Sir C socket programming என்றால் என்ன C networking programming என்றால் என்ன C socket programming tutorials கொஞ்சம் சொல்லிதாங்க.please sir

[@gokulrajganesan221]

Can i use this defined name in macro?

[@ddr8774]

Countif formula one doubt sir... How to count how many unique class (I, II..) and how many students...( I - 2 1st standard 2 students)

[@boopathykumar5736]

Super anna

[@tutorjoes]

Thank you

[@thiyagarajan1989]

Can you please Upload, LiberOffice - which is Open Source.... So most of the people, Learn licence free..software.. So, most organisations implement in their Org.

[@tutorjoes]

Sure I will do open office and libre office soon

[@thiyagarajan1989]

@@tutorjoes, Complete videos like, Calc, Math, Writer, Presentation.... In that, Pivot table, Formula, etc Like what you uploaded in Ms office and its categories Same like LiberOffice....

[@perarasan9025]

Bro xlookup correct ah formula poten bro #name nu varudhu bro

[@umeihash4761]

How can I get the practice files ?!?!

[@ashwin9577]

Next fluttter video epo release panuvenga????

[@vigneshs8183]

Sir please java full video course upload panuka

[@tutorjoes]

Sure this python after completing sure I do java

[@vigneshs8183]

@@tutorjoes thank you

[@sathesh7459]

sir unga teachingah vachi than na excel,vba skills develope panen itha vachi na jib search pana kidaikumah? apram home based job search panren sir any tips??

[@tutorjoes]

Sure I will make a video for home based jobs soon

[@sathesh7459]

@@tutorjoes vba macro ku full complete video upload panunga sir

[@rajeevchandran540]

Sir HTML CSS php JavaScript Theriyum next JavaScript framework or php framework Ethu nallath

[@mohammedgajini6020]

Bro epdi Ellathaiyum kathukutinga... Na Ippo thaan html aarambuchuruken

[@rajeevchandran540]

@@mohammedgajini6020 6mnth aach

[@gioonlineshopping7564]

நீடுழி வாழ்க 🙏

[@KarthiKeyan-im2ms]

Ms access video please

[@aswiniwilson2264]

Sir where is the invoice file? Photoshop ?

[@logeshavinash4151]

sir ninga maruba diu yapo pala ya mari varuvinga we will waiting...

[@tutorjoes]

Sure ma sorry for inconvenience.due to covid 19 lockdown we can't do latest videos.sure I will back soon.👍

[@logeshavinash4151]

@@tutorjoes ok sir we will wait to learn something new for you ..thank you sir

[@SunilKumar-lx7gq]

Sir please excel la graph yppadi use panrathunu sollunga

[@tutorjoes]

Sure I will do in menu by menu video

[@p.sundarmoorthy6054]

Fixed reference எப்படி செலக்ட் செய்வது. எக்ஸ்பிளநேஷன் நன்றாக உள்ளது, ஆனால் மவுஸ் மூவ்மெண்ட் தெரியாததநாள் என்ன செலக்ட் செய்கிறீர்கள் என்பது புரியவில்லை.

[@buvaneswaris1469]

En vaazhvil kanda perumai

[@rabinrava3943]

30:31... Shall I use "Right (A2,6)" to get year.

[@IASPRO]

Bro flutter videoum podunga please

[@tutorjoes]

Sure pls wait I will continue

[@IASPRO]

Hm

[@umeimahashan]

It's annoyingly zoomed in sir!!! please try to fix it

[@sgleo4934]

Sir flutter apps create panna solli thaga sir

[@tutorjoes]

Due to covid 19 some delay in creating new videos sure I will do

[@sgleo4934]

@@tutorjoes ok sir thanks for your reply🥰🥰

[@mdyakoob4560]

Power Point update pannunga bro

[@tutorjoes]

Sure soon