IT Skillshala
IT Skillshala
  • 367
  • 122 978
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
Переглядів: 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.
Working with Equations in MS Excel
Переглядів 1072 місяці тому
Working with Equations in MS Excel
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.
Mastering 3D Models in MS Excel
Переглядів 582 місяці тому
Mastering 3D Models in MS Excel

КОМЕНТАРІ

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l 3 години тому

    Very nice information

  • @goharraza2841
    @goharraza2841 День тому

    great sir

  • @PunjabiTravellers.
    @PunjabiTravellers. День тому

    Nicely Explained 👍👌

  • @satinderpalsinghbhatia5030
    @satinderpalsinghbhatia5030 4 дні тому

    Very useful feature well explained

  • @hellomyguys7651
    @hellomyguys7651 7 днів тому

    Very good ji

  • @rakeshkataria6924
    @rakeshkataria6924 7 днів тому

    nice...as always

  • @KochharAmandeep
    @KochharAmandeep 7 днів тому

    Amazing explanation sir as usual. A proud student 👏

    • @itskillshala
      @itskillshala 7 днів тому

      Thank you so much for your kind words! 😊

  • @Bhuvviiii
    @Bhuvviiii 12 днів тому

    🎉🎉

  • @Bhuvviiii
    @Bhuvviiii 12 днів тому

    Very useful information

  • @mustafaansari6478
    @mustafaansari6478 15 днів тому

    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.

    • @itskillshala
      @itskillshala 15 днів тому

      "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."

  • @PunjabiTravellers.
    @PunjabiTravellers. 17 днів тому

    Excellent Sharma Ji...Very informative video on Excel...Keep it up...

  • @digitalgyaan1782
    @digitalgyaan1782 19 днів тому

    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 ??

    • @itskillshala
      @itskillshala 19 днів тому

      Kon sa software hai

    • @digitalgyaan1782
      @digitalgyaan1782 19 днів тому

      @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 ??

  • @MDArifAlam-e2o
    @MDArifAlam-e2o 19 днів тому

    Enable kre ya nhi

    • @itskillshala
      @itskillshala 19 днів тому

      Trusted Source hai to enable ki need nahi hai.Otherwise hai

  • @RahulKumar-lc7qh
    @RahulKumar-lc7qh 19 днів тому

    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

    • @itskillshala
      @itskillshala 19 днів тому

      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.

  • @sonuahmad7366
    @sonuahmad7366 19 днів тому

    Hi sir ms Word pe full video bnaiye plz

  • @Taxconstitution
    @Taxconstitution 26 днів тому

    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

  • @SanjaySingh-su4rn
    @SanjaySingh-su4rn 27 днів тому

    आपको भी दीपावली की हार्दिक शुभकामनाएँ

  • @atul03031971
    @atul03031971 28 днів тому

    Useful information Sharmaji

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l 29 днів тому

    Very useful information

  • @saurabhkumar8401
    @saurabhkumar8401 Місяць тому

    Thank you sir

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l Місяць тому

    Very useful information

  • @shahbazperwez6708
    @shahbazperwez6708 Місяць тому

    Very nice sir Sir app excel ke advance option pe video banaye

  • @satinderpalsinghbhatia5030
    @satinderpalsinghbhatia5030 Місяць тому

    Very useful information Thanks ji

  • @atul03031971
    @atul03031971 Місяць тому

    Excellent Sharma ji

  • @hellomyguys7651
    @hellomyguys7651 Місяць тому

    Very nice sir

  • @hawkgaming8223
    @hawkgaming8223 Місяць тому

    Laptop par f4 work nhi kr rha h screen setting khul rhi h

    • @itskillshala
      @itskillshala Місяць тому

      Function Kwy F4 laptop par hee Kam karti hai.Its working

    • @mmeezan9658
      @mmeezan9658 Місяць тому

      @@hawkgaming8223 press function and F4

    • @hawkgaming8223
      @hawkgaming8223 Місяць тому

      @@mmeezan9658 ok will try

    • @hawkgaming8223
      @hawkgaming8223 Місяць тому

      @@mmeezan9658 thanks bro problem solve ho gya ab ho rha h sahi se

    • @mmeezan9658
      @mmeezan9658 Місяць тому

      @@hawkgaming8223 welcome bhai

  • @atul03031971
    @atul03031971 Місяць тому

    Well done Sharma ji

  • @mmeezan9658
    @mmeezan9658 Місяць тому

    f4 is not working

    • @itskillshala
      @itskillshala Місяць тому

      It's working dear

    • @mmeezan9658
      @mmeezan9658 Місяць тому

      @@itskillshala in my laptop i have press funtion button with F4 button

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l Місяць тому

    Very nice

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l Місяць тому

    Very nice

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l Місяць тому

    Very useful information

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l Місяць тому

    Very nice

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l Місяць тому

    Very useful videos

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l Місяць тому

    Very nice

  • @vbhambri3
    @vbhambri3 Місяць тому

    Very nice

  • @naeemulhassan1426
    @naeemulhassan1426 Місяць тому

    Sir hour plz upload a tutorial at hours calculation.

  • @titviral40
    @titviral40 Місяць тому

    Good 👍

  • @Dragon_gaming-dk9pp
    @Dragon_gaming-dk9pp Місяць тому

    Very nice video appreciated 😊

  • @sonuahmad7366
    @sonuahmad7366 Місяць тому

    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 🙏🙏🙏🙏

  • @sonuahmad7366
    @sonuahmad7366 Місяць тому

    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 🙏🙏🙏🙏

  • @hellomyguys7651
    @hellomyguys7651 Місяць тому

    Very nice video bro

  • @vitthalpatekar5497
    @vitthalpatekar5497 Місяць тому

    मुझे exel मे 5 वी कक्षा का रिझल्ट् बनवाना हैं मदद करो

  • @mustafaansari6478
    @mustafaansari6478 Місяць тому

    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.

  • @mustafaansari6478
    @mustafaansari6478 Місяць тому

    Sir, nobody taught me like this....research level teaching....nobody might be teaching like this on youtube.

    • @itskillshala
      @itskillshala Місяць тому

      Glad to hear that.Thanks 🙏

  • @kaifjindran6086
    @kaifjindran6086 Місяць тому

    How to do it in mobile??

  • @naeemulhassan1426
    @naeemulhassan1426 Місяць тому

    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.

    • @itskillshala
      @itskillshala Місяць тому

      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."

  • @markosegeorge1354
    @markosegeorge1354 Місяць тому

    Sir, how to do digital sign in excel sheet document

  • @naeemulhassan1426
    @naeemulhassan1426 Місяць тому

    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.

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l 2 місяці тому

    Very good video

  • @RajeshGupta-pw7bw
    @RajeshGupta-pw7bw 2 місяці тому

    Very informative