10 Advanced excel functions and tricks in Tamil | Ms excel 2007 TO 2016 and 2019
HTML-код
- Опубликовано: 13 май 2021
- Advanced Transpose
Quick analysis to make analysis easier
Goal seek to achieve the goal
Slicer to make the filter work smarter
Advanced select make the selection quicker
Advanced filter filter the data separately
Freeze panes to look through the data without any difficulty
Embedding connect the excel with the word
Text to image convert the text data to image format
People graph gives you new experience of inserting graphs for data analysis
12 Most Important Excel Formula Can Make YOU Excel expert in Tamil
• 12 Most Important Exce...
25 Very important formulas in excel in Tamil
• 25 Most Useful excel f...
One shortcut key for all shortcuts in excel : • Alt shortcut key for a...
All important excel shortcut keys in MS excel in Tamil: • All important excel sh...
Most used excel basic functions and formula in Tamil
• Excel Basic Formulas a...
VLOOKUP DETAILED EXPLANATION IN EXCEL WITH SOLUTION FOR ERRORS IN TAMIL
• VLOOKUP DETAILED EXPLA...
Increase the speed of all types of computers and laptops
• How to increase speed ...
How to do data entry work in excel in Tamil
• DATA ENTRY WORK IN EXC...
For inquiries: shinuboss1@gmail.com
#excel #excelfunctions #excelformula #exceltipsandtricks #advancedexcel
great bro.easy to understand your videos
Please upload a video how to use sumproduct, mod,column together in a formula with a big file data
Sir superb, thanks a lot
great teaching sir
Spr tally pathy next word pathy next gst filling um upload panuga 👌👌👌
Very useful video... I want one question... I need to paste people graph to powerpoint... It's possible
Excellent
very useful tips. Thanks Sir.
Always welcome
Super Learning Sir 🙌
Keep watching. Thank you.
Thank you
Sir quick analysis la antha sum, average chart lam na try panen but varala sir
Super master
Vanakam bro..
Very very very
super sir
Thank you nanba ❤️😁👍
Thank you sir
Welcome
Superrrrrrrr sir👍👍👍🙏🏻🙏🏻🙏🏻👌
👍❤️
Amazing
Thank you! Cheers!
In the data list there is no Rs2000 price given. But how come it shows Rs2000, under price on slicing the data?
Super
Thank you so much.
👌
Thank you fathima
Bro msword breifly all tools and functions tutorial podunga bro
Will upload soon
Java pathi videos podunga sir
ok. Thank you for watching.
Kindly share practice file also
Check description.
Thanks ..all in one lesson..
welcome
Hai ,Nan unga ellaam video parthuruken. Unga video parthi excel parthi learn paniruken
nan excel la oru project panikithu eruken athula konjam doubt eruku please help panunga. Example kuduthuruken serial number 15 varaikum rows erukum A Rows la empty field lam sila time varum. some time number varum starting 1 erunthu start agum Nan kekura condition B Rows example kuduthuruken athu matri values varanum. B Rows la A rows greater than equal 2 ( A>=2) Vara methu A Rows aparam 2 ku Mela epo 1 start agutho B rows 1 ku pathila +1 varanum. Nan expect pandra B Rows example kuduthuruken.
~~~~~~~~~~~~~~~~~~~~~
S .No A B
~~~~~~~~~~~~~~~~~~~~~
1.
2.
3. 1 1
4.
5.
6. 1 1
7. 2 2
8. 3 3
9.
10.
11.
12. 1 +1
13. 2 +2
14.
15. 1 *1
Advanced filter option is good
Where the tool. Is located in wps
பவர் பாயின்ட் பற்றி கூறுங்கள்
கூறலாம்.
Sir quick analysis option varamatenguthu sir.... Pls help me.... Ctrl q koduthalum display agala
Get data from table /range, right click pannunga bro
Sir..!!
Goal seek la
Cell must contain a formula nu kekku
Nan entha formula apply panna
Plz... Tell me sir
Enaku apdithn tholare kaatuthu, how to solve that?
ஒரு பெரிய டேட்டாவில் ஒரு செல்லை மட்டும் செலக்ட் செய்யும் போது அந்த செல் மட்டும் வேறு கலரில் தெரிய என்ன செய்ய வேண்டும் sir
Good question. will upload soon. Thank you for watching.
My PC quick analysis concept not working ....sir
Me too... Wht s solution
sir i don't get go adds in my excel. can you please help me
Excel version you are using sir. Use latest version excel for people graph
@@cutechinfotamil I am using 2013 sir
@@gokulakrishnan4385 Try with 2016 or 2019
Okay sir
Hi Sir,Slicer comments is not display in Excel ... pls help to display in Excel...
hi
Hello☺☺
Hi Sir,
May i request give some suggestion to the below mentioned requirement please.
I am maintain a data sheet for purchase order pending list, i want separate completed data (row) automatically in separate sheet if one particular cell condition satisficed in without using VB or Macros
Ultimately Pending data only available in the main sheet, completed data will be in separate sheet like
can you suggest any formula please.
My Ms Excel sheet isn't data option in Stock function, How to add that option bro
If data tab is not found you can reinstall ms office software.
@@cutechinfotamil I already reinstall ms office sir That option didn't have sir
@@aadhiseshanks1303 mail me. i will help you
Filter pathi matu inoru video podum pothu oru outline kuduinga bro...
Sir; can you please send your email ID; I need some clarification in excel