- 367
- 122 978
IT Skillshala
India
Приєднався 14 жов 2022
Skills are Power. Build your skills not your resume.
Hi I am Sahil Sharma having 14 years of teaching experience. I had taught various core computer science and computer application subjects at graduate and post graduate level. Now I am here to teach you MS Office. A world wide Popular software for daily office needs.MS Office includes MS word, MS Excel, MS Power Point, MS Access, MS Outlook, MS Publisher, MS OneNote.
So What are you waiting for? Lets start the journey of learning with me.
Hi I am Sahil Sharma having 14 years of teaching experience. I had taught various core computer science and computer application subjects at graduate and post graduate level. Now I am here to teach you MS Office. A world wide Popular software for daily office needs.MS Office includes MS word, MS Excel, MS Power Point, MS Access, MS Outlook, MS Publisher, MS OneNote.
So What are you waiting for? Lets start the journey of learning with me.
Part 6: Proofing | AutoCorrect | AutoFormat as you Type in excel?
Here @itskillshala we will learn:
1.What is AutoFormat As you work options in Excel?
2.Internet and Network Path with Hyperlinks.
3.Apply As you work.
4.Include Rows and columns in table.
5.Automatically AS you work
6.Fill Formulas in table to create calculated columns
So Good Luck.
#Skillshala #MS Office #Hindi #excel #exceltricks #exceltipsandtricks #exceltips #excelgyan #excelforbegginers #exceltutorial #excelcourse
it_skillshala
1.What is AutoFormat As you work options in Excel?
2.Internet and Network Path with Hyperlinks.
3.Apply As you work.
4.Include Rows and columns in table.
5.Automatically AS you work
6.Fill Formulas in table to create calculated columns
So Good Luck.
#Skillshala #MS Office #Hindi #excel #exceltricks #exceltipsandtricks #exceltips #excelgyan #excelforbegginers #exceltutorial #excelcourse
it_skillshala
Переглядів: 57
Відео
Part 5: Proofing | AutoCorrect | AutoCorrect Exceptions in Excel.
Переглядів 719 годин тому
Here @itskillshala we will learn: 1.What are AutoCorrect Exceptions in Excel. 2.How the abbreviations and acronyms are written without making any capitalization errors? 3.What are "Don't Capitalize After" and "Initial Caps" options? So Good Luck. #Skillshala #MS Office #Hindi #excel #exceltipsandtricks #exceltipsandtricksinhindi #exceltips #exceltricks #learnexcelfree #advancedexcel #exceltutor...
Part 4 Proofing | Understanding AutoCorrect Feature.
Переглядів 5114 годин тому
Here @itskillshala we will learn: 1.How to automatically correct the spelling mistakes using autocorrect feature of excel? 2.How to convert abbreviations to full forms using autocorrect feature of ms excel? 3.How to remove capitalization errors using autocorrect feature of excel? 4.How to insert symbols in worksheet using autocorrect feature of excel? 5.How to insert lengthy and complex formula...
Part 3: Proofing | Mastering AutoCorrect feature in Excel.
Переглядів 12319 годин тому
Here @itskillshala we will learn: 1.Understanding AutoCorrect Feature of MS Excel. 2.Show AutoCorrect Options Button 3.Correct two initials. 4.Capitalize name of days 5.Correct accidental use of Caps Lock key. So Good Luck. #Skillshala #MS Office #Hindi #exceltipsandtricks #exceltips #exceltricks #excelforbegginers #exceltutorial #advancedexcel #excelcourse #microsoftexcel it_skil...
Part 2: Proofing | Check and correct spellings within a range | Workbook | Formula and Comments ?
Переглядів 100День тому
Here @itskillshala we will learn: 1.What is Proofing? 2.How to identify and correct spelling mistakes within a worksheet? 3.How to identify and correct spelling mistakes within a Workbook? 3.How to identify and correct spelling mistakes within a Formula? 4.How to identify and correct spelling mistakes within a Comment? So Good Luck. #skillshala #Skillshala #MS Office #Hindi #excel #exceltricks ...
Part 1: Proofing in Excel | Spellchecker | Autocorrect Options in Excel
Переглядів 209День тому
Here @itskillshala we will learn: 1.What is Proofing feature in MS Excel? 2.How to speck spellings in MS Excel? 3.How to start the Spellchecker of MS Excel? 4.What are Ignore and Ignore All options in Spelling Dialogue box in excel? 5.What are Change and Change All options in Spelling Dialogue box in excel? 6.What is Autocorrect option in excel? 7.What is UNDO Last option in Spelling Dialogue b...
Part 5 : Print an Excel worksheet | Print Titles | Grid-lines | Row & Column Headings | Page Order
Переглядів 25914 днів тому
Here @itskillshala we will learn: 1.What is Print Title option in excel? 2.How to repeat a top row/rows at every printout of excel worksheet? 3.How to repeat left column/columns at every printout of excel worksheet? 4.How to Print comments in excel? 5.How to print cell errors in excel? 6.What is Page Order in excel? 7.What is Down then Over and Over then Down Page orders in excel? 8.How to view...
Part 4: Printing an Excel Worksheet | Insert | Remove | Reset Page Breaks in MS Excel.
Переглядів 31714 днів тому
Here @itskillshala we will learn: 1.What are Page Breaks in Excel? 2.How to insert Horizontal Page Breaks in Excel? 3.How to insert Vertical Page Break in Excel? 4.How to remove Page Breaks in excel? 5.How to reset Page breaks in excel? So Good Luck. #Skillshala #MS Office #Hindi #msofficeinhindi #excel #excelgyan #excel #exceltricks #exceltipsandtricks #exceltutorial #learnexcelfree #advancede...
Part 3 - Printing an Excel Worksheet | Master Scaling in MS Excel | Custom Scaling.
Переглядів 38221 день тому
Here @itskillshala we will learn: 1.What is Scaling in MS Excel? 2.What are different ways to apply Scaling? 3.What is Height wise scaling? 4.What is Width wise scaling? 5.What is percentage wise scaling? 6.What is custom scaling? 7.Scaling by dragging page breaks. So Good Luck. #Skillshala #MS Office #Hindi #excel #spreadsheet #exceltipsandtricks #exceltips #exceltricks #exceltipsandtricksinhi...
Part 2 : Printing an excel worksheet | Print Area | Margins | Orientation | Page Size
Переглядів 19721 день тому
Here @itskillshala we will learn: 1.How to adjust page margins in ms excel? 2.How to change margin units in ms excel? 3.How to change page orientation in ms excel? 4.How to select page size in ms excel? 5.What is Print Area in excel ? 6.How to select Print Area in excel? 7.How to set Print Area in excel? 8.How to clear Print area in excel? So Good Luck. #Skillshala #MS Office #Hindi #spreadshee...
Happy Diwali to all viewers and excel lovers.
Переглядів 1928 днів тому
Happy Diwali from @itskillshala. Have wonderful and Prosperous Diwali. So Good Luck. #Skillshala #MS Office #Hindi it_skillshala
Part 1: Printing excel worksheet. | All Printing options
Переглядів 62028 днів тому
Here @itskillshala we will learn: 1.How to print an excel worksheet? 2.How to print active worksheets? 3.How to print excel workbook? 4.How to set margins of excel worksheet? 5.How to print one side of paper? 6.How to print on both sides of a paper? 7.What are collated and uncollated printing options? 8.How to change the orientation of a page? 9.What is Portrait and Landscape orientation of pag...
How to Print comments in MS Excel? | Two ways to print comments in MS Excel
Переглядів 137Місяць тому
Here @itskillshala we will learn: How to print comments in MS Excel? Two ways to print comments in MS Excel? Print Comments at the end of sheet in excel. Print comments as displayed on sheet in excel. So Good Luck. #Skillshala #MS Office #Hindi #excel #excelinhindi #exceltips #exceltricks #exceltipsandtricks #exceltutorial #excelforbegginers #conditionalformatting #advancedexcel #learnexcelfree...
Part 6 : How to select multiple comments,Copy and paste comments and delete multiple comments?
Переглядів 89Місяць тому
Here @itskillshala we will learn: 1.How to select multiple comments in ms excel? 2.How to copy and paste comments in ms excel? 3.How to delete multiple comments in ms excel? So Good Luck. #Skillshala #MS Office #Hindi #exceltips #exceltricks #exceltipsnandtricks #exceltipsandtricksinhindi #excelcourse #excelcourses #exceltutorial #exceltutorials #exceltutorialsinhindi #learnexcelfree #learnexce...
Part 5 : Insert Photo in Comment Box in MS Excel
Переглядів 87Місяць тому
Here @itskillshala we will learn: 1.How to insert a picture in comment box in excel? 2.How to insert a photo in comment box in excel? So Good Luck. #Skillshala #MS Office #Hindi #exceltips #exceltricks #exceltipsandtricks #exceltipsandtricksinhindi #exceltutorial #excelforbegginers #comments #commentsinexcel #learnexcelfree #learnexcelonline #learnexcelfree #advancedexcel #advancedexceltraining...
Part 4: How to Change the shape of a comment box in excel?
Переглядів 104Місяць тому
Part 4: How to Change the shape of a comment box in excel?
Part 3: Format Comment Box in Excel | Color & Lines | Resize | Margin | Object Positioning
Переглядів 216Місяць тому
Part 3: Format Comment Box in Excel | Color & Lines | Resize | Margin | Object Positioning
Format Comments in MS Excel | Bold | Italic | Underline | Alignment | Font color | Font Size |
Переглядів 178Місяць тому
Format Comments in MS Excel | Bold | Italic | Underline | Alignment | Font color | Font Size |
Insert | Edit | Show | Hide | Delete comments or notes in MS Excel.
Переглядів 169Місяць тому
Insert | Edit | Show | Hide | Delete comments or notes in MS Excel.
Part 2: Custom themes in MS Excel | Create themes | Create new theme colors and fonts | Save themes
Переглядів 95Місяць тому
Part 2: Custom themes in MS Excel | Create themes | Create new theme colors and fonts | Save themes
Part 1: Apply themes to MS Excel workbook | Theme Fonts | Theme Colors | Theme Effects
Переглядів 267Місяць тому
Part 1: Apply themes to MS Excel workbook | Theme Fonts | Theme Colors | Theme Effects
Part 4: Inserting Symbols in MS Excel worksheet? | 3 ways to insert symbols
Переглядів 215Місяць тому
Part 4: Inserting Symbols in MS Excel worksheet? | 3 ways to insert symbols
Part3: Insert Symbols in MS Excel worksheet using keyboard shortcuts
Переглядів 252Місяць тому
Part3: Insert Symbols in MS Excel worksheet using keyboard shortcuts
Part2:Insert Symbols in MS Excel worksheet.
Переглядів 2032 місяці тому
Part2:Insert Symbols in MS Excel worksheet.
Mastering Header and Footers in MS Excel
Переглядів 3962 місяці тому
Mastering Header and Footers in MS Excel
Mastering Hyperlinks in MS Excel | Insertion,Editing and removing hyperlinks
Переглядів 4602 місяці тому
Mastering Hyperlinks in MS Excel | Insertion,Editing and removing hyperlinks
Inserting and Formatting Icons in ms excel.
Переглядів 482 місяці тому
Inserting and Formatting Icons in ms excel.
Capture and insert the Screen shots of any opened window effortlessly in excel.
Переглядів 892 місяці тому
Capture and insert the Screen shots of any opened window effortlessly in excel.
Very nice information
Thanks
great sir
Thanks...
Nicely Explained 👍👌
Thanks.... 😊
Very useful feature well explained
Thanks for your kind words. 😊
Very good ji
Thanks... 😊
nice...as always
Thanks....😊
Amazing explanation sir as usual. A proud student 👏
Thank you so much for your kind words! 😊
🎉🎉
Very useful information
Thanks...
Sharing my experience, This channel is the best platform to learn excel for Beginners and Advance learner as well in the entire UA-cam platform. I recommend everyone to subscribe to this channel whoever want to learn EXCEL with Good conceptual Knowledge.
"Thanks for your kind words. I am highly grateful. I’m making every effort not to skip any topic, and when I start teaching a topic, I aim to cover it in such detail that once it's done, there will be nothing left to study or teach further on that subject. This way, it will be easier for both beginners and advanced learners. Currently, my videos get very few views, and I have very few subscribers. I am only able to upload two videos per week. Although Shorts and Reels reach a larger audience, I believe that no skill can be learned through Shorts and Reels. Gradually, my target is to upload videos daily so that as many people as possible can learn this skill. Let’s see how long it takes to achieve success. Thanks a lot once again."
Excellent Sharma Ji...Very informative video on Excel...Keep it up...
Thanks....
Ek software hai esme (File Teb) me excal options show nhi ho raha hai or sare tab customized hai to vaps kese la sakte hai ??
Kon sa software hai
@itskillshala excal me banaya huva hai jisne bhi banaya vo customized karke jarurat k anusar tab rakha hai but jab file tab k sare sub teb show nhi ho Raha hai ?? Exacl option par click nhi ho Raha hai taki sare customized hum apni tarh se badal sake ??
Enable kre ya nhi
Trusted Source hai to enable ki need nahi hai.Otherwise hai
Sir excel ms Word maine sikha hai aur job pe bhi hu data entry me but aage badhne ke liye es line me kaunsa course kare plz reply
Dear Brother Word and Excel sirf data entry software nahi hai.Inka use to corporate sector main bhee hai.Iske leye aako apne skills ko improve karna hoga.Sirf Advance Excel seekh kar hee aap Data Analyst, Reporting Specialist, MIS (Management Information Systems) Executive.ki jobs ke leye elligible ho jaynege and ye jobs high package jobs hain.
Hi sir ms Word pe full video bnaiye plz
I will try.
Sir mere ek prob hai.. Sir ek sab no. Ko thousands an d hundred me convert krna chahta hu...jisme negativr no. Bracket me or 0 dash me convert ho jae..and m 10 sheet me ek sath consitional formating krna chahta hu...sir can u pls help me
आपको भी दीपावली की हार्दिक शुभकामनाएँ
Thanks....
Useful information Sharmaji
Thanks....
Very useful information
Thanks...
Thank you sir
My Pleasure
Very useful information
Thanks...
Very nice sir Sir app excel ke advance option pe video banaye
Ji zaroor
Very useful information Thanks ji
Thanks....
Excellent Sharma ji
Thanks...
Very nice sir
Thanks....
Laptop par f4 work nhi kr rha h screen setting khul rhi h
Function Kwy F4 laptop par hee Kam karti hai.Its working
@@hawkgaming8223 press function and F4
@@mmeezan9658 ok will try
@@mmeezan9658 thanks bro problem solve ho gya ab ho rha h sahi se
@@hawkgaming8223 welcome bhai
Well done Sharma ji
Thanks...😊
f4 is not working
It's working dear
@@itskillshala in my laptop i have press funtion button with F4 button
Very nice
Thanks...
Very nice
Thanks....
Very useful information
Thanks...
Very nice
Thanks...
Very useful videos
Thanks...
Very nice
Thanks dear...
Very nice
Thanks dear...
Sir hour plz upload a tutorial at hours calculation.
Good 👍
Thanks...
Very nice video appreciated 😊
😊 Thanks
Sir ek name ke 3ya4 serial duplicate order alag alag serial number pe vlookup lgane sirf ek hi number pakadta hai jaise ram ka 4 order 4 serial number pe par vlookup me 1 serial number pakadta hai baki ka manualy type karna padta hai Eska koi trik btaye sir 🙏🙏🙏🙏
Sir ek name ke 3ya4 serial duplicate order alag alag serial number pe vlookup lgane sirf ek hi number pakadta hai jaise ram ka 4 order 4 serial number pe par vlookup me 1 serial number pakadta hai baki ka manualy type karna padta hai Eska koi trik btaye sir 🙏🙏🙏🙏
Very nice video bro
Thanks dear
मुझे exel मे 5 वी कक्षा का रिझल्ट् बनवाना हैं मदद करो
Super sir....my concept is totally cleared...i can do any cell referencing task...earlier i was having lot of doubts but now i can say...i can resolve it any cell referencing issue.
Thanks dear
Sir, nobody taught me like this....research level teaching....nobody might be teaching like this on youtube.
Glad to hear that.Thanks 🙏
How to do it in mobile??
Sir. I am your subscriber but sorry to write that you don't reply to your subscriber. I want to learn off set function m.s excel. Please upload a tutorial of complete off set function and hours calculation as well. I will thankful to you. Regards.
Dear subscriber, I consider all my subscribers as my brothers, sisters, and friends. You are all very valuable to me. I address and reply to all my subscribers' queries if there is anything they don’t understand from my uploads. I have always replied to you as well. However, it is natural for there to be a delay in handling individual requests. I didn’t refuse your request; I mentioned that I would upload a lecture on this topic. But if you expect me to upload the video on the topic you mentioned within two days or any other time limit. I’m sorry, brother, that’s not possible. Thanks."
Sir, how to do digital sign in excel sheet document
I will upload video soon
Sir. I m your subscriber and belong from Pakistan. Please explain sumproduct with multi carietera and usage logical function ",and", or. How use in sum product I will thankful.Regards.
Sure.I will upload
Very good video
Thanks dear
Very informative
Thanks dear