IT Skillshala
IT Skillshala
  • Видео 374
  • Просмотров 131 597
Master Mround Function in MS Excel | Round Time values with Mround function.
Here @itskillshala we will learn:
1.What is mround function ?
2.How mround function works?
3.Use to mround function to round a number to given multiple?
4.Round Time values using mround function.
5.Use of Mround function with other functions?
So Good Luck.
#Skillshala #MS Office #Hindi #excel #exceltipsandtricks #exceltips #exceltutorial #excelforbegginers #exceltricks #learnexcelfree #advancedexcel #excelcourse
it_skillshala
Просмотров: 32

Видео

Part 2: Round Function | Round Time Values | Round to specific decimal values | Round Expressions
Просмотров 457 часов назад
Here @itskillshala we will learn: 1.How to round time values using round function in excel? 2.How to round to specific decimal values in excel? 3.How to round expressions in excel i? 4.What are Roundup and Rounddown functions? So Good Luck. #Skillshala #MS Office #Hindi #excel #exceltipsandtricks #exceltricks #exceltips #learnexcelfree #advancedexcel it_skillshala
Mastering Round Function in MS Excel. Let's learn the magic of round function in excel.
Просмотров 6714 часов назад
Here @itskillshala we will learn: 1.What is rounding in excel? 2.How to round numbers in ms excel? 3.What are rounding functions in ms excel? 4.What is logic behind the round function? 5.How to manually round the numbers? 6.What is round function in excel? 7.How to round decimal numbers in excel? 8.How to round whole numbers in excel? 9.How to round to nearest 10's,100's ans 1000's and so on mu...
Smart Lookup Feature of MS Excel? | Find anything instantly within excel
Просмотров 4119 часов назад
Here @itskillshala we will learn: 1.What is smart lookup insights feature in excel? 2.How smart lookup insights feature helps to find any term in excel So Good Luck. #Skillshala #MS Office #Hindi #excel #excelinhindi #excelforbegginers #exceltipsandtricks #exceltips #exceltricks #exceltutorial #excelforstudents #advancedexcel #excelcourse it_skillshala
Language Translator in excel. | Translate one language into another in excel.
Просмотров 88День назад
Here @itskillshala we will learn: 1.How to translate from one language to another language in ms excel? So Good Luck. #Skillshala #MS Office #Hindi #excelinhindi #excel #exceltipsandtricks #exceltricks #advancedexcel #learnexcelfree #exceltutorial it_skillshala
How to embed Objects or External files in ms excel worksheet? | Mastering Embeded Objects in excel
Просмотров 119День назад
Here @itskillshala we will learn: 1.How to embed objects in MS Excel? 2.How to embed external files in excel? 3.How to embed word,excel,power point,pdf,audio and video files in ms excel? 4.Difference between Hyperlinks and embeded objects? So Good Luck. #Skillshala #MS Office #Hindi #excel #exceltipsandtricks #exceltipsandtricksinhindi #exceltips #exceltricks #excelforbegginers #exceltutorial #...
Thesaurus in Excel | Getting Synonyms in excel
Просмотров 3714 дней назад
Here @itskillshala we will learn: What is the purpose of thesaurus option in excel? How thesaurus options helps to get synonyms of any word in excel? So Good Luck. #Skillshala #MS Office #Hindi #exel #excelinhindi #exceltipsandtricks #excelgyan #exceltricks #exceltips #advancedexcel #excelcourse #learnexcelfree it_skillshala
Part 6: Proofing | AutoCorrect | AutoFormat as you Type in excel?
Просмотров 12514 дней назад
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 #e...
Part 5: Proofing | AutoCorrect | AutoCorrect Exceptions in Excel.
Просмотров 10314 дней назад
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.
Просмотров 8121 день назад
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.
Просмотров 13621 день назад
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 ?
Просмотров 11521 день назад
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
Просмотров 27128 дней назад
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
Просмотров 299Месяц назад
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.
Просмотров 331Месяц назад
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.
Просмотров 401Месяц назад
Part 3 - Printing an Excel Worksheet | Master Scaling in MS Excel | Custom Scaling.
Part 2 : Printing an excel worksheet | Print Area | Margins | Orientation | Page Size
Просмотров 204Месяц назад
Part 2 : Printing an excel worksheet | Print Area | Margins | Orientation | Page Size
Happy Diwali to all viewers and excel lovers.
Просмотров 19Месяц назад
Happy Diwali to all viewers and excel lovers.
Part 1: Printing excel worksheet. | All Printing options
Просмотров 648Месяц назад
Part 1: Printing excel worksheet. | All Printing options
How to Print comments in MS Excel? | Two ways to print comments in MS Excel
Просмотров 137Месяц назад
How to Print comments in MS Excel? | Two ways to print comments in MS Excel
Part 6 : How to select multiple comments,Copy and paste comments and delete multiple comments?
Просмотров 89Месяц назад
Part 6 : How to select multiple comments,Copy and paste comments and delete multiple comments?
Part 5 : Insert Photo in Comment Box in MS Excel
Просмотров 88Месяц назад
Part 5 : Insert Photo in Comment Box in MS Excel
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
Просмотров 220Месяц назад
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 |
Просмотров 180Месяц назад
Format Comments in MS Excel | Bold | Italic | Underline | Alignment | Font color | Font Size |
Insert | Edit | Show | Hide | Delete comments or notes in MS Excel.
Просмотров 1722 месяца назад
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
Просмотров 972 месяца назад
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
Просмотров 2702 месяца назад
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
Просмотров 2202 месяца назад
Part 4: Inserting Symbols in MS Excel worksheet? | 3 ways to insert symbols
Part3: Insert Symbols in MS Excel worksheet using keyboard shortcuts
Просмотров 2562 месяца назад
Part3: Insert Symbols in MS Excel worksheet using keyboard shortcuts

Комментарии

  • @sandeepshekhawat2076
    @sandeepshekhawat2076 День назад

    Super job Sir

  • @KolachiMishaque-vp4hm
    @KolachiMishaque-vp4hm 4 дня назад

    Good knowledge

  • @AmitSingh-ro3dm
    @AmitSingh-ro3dm 6 дней назад

    Please upload practice file if possible sir

  • @AmitSingh-ro3dm
    @AmitSingh-ro3dm 6 дней назад

    Only channel on RUclips for detailed explanation of each topic of excel

    • @itskillshala
      @itskillshala 6 дней назад

      Thank you so much for your kind words. I am trying my best to make these videos as helpful and detailed as possible.

  • @HarmeetSinghTalwar-dz6ru
    @HarmeetSinghTalwar-dz6ru 8 дней назад

    Nice guidance

  • @nisikantbehera5002
    @nisikantbehera5002 9 дней назад

    How to write date like 1st 2nd 3rd 4th with month in custom format

    • @itskillshala
      @itskillshala 8 дней назад

      d"th" mmmm OR d"st" mmmm but remember its totally static not dynamic. if you write d"th" its good got 11th,12th etc.but not for 1st or 2nd.for 1st you have to write d"st" and for 2nd you must write d"nd".So better to use formula rather than custom format here.

  • @badrinarayanborude3326
    @badrinarayanborude3326 11 дней назад

    Good explanation

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l 12 дней назад

    Very good 🎉

  • @rahulchemtech7291
    @rahulchemtech7291 13 дней назад

    Sir iska sheet ka link de dijiye

    • @itskillshala
      @itskillshala 12 дней назад

      Ji Sure.Main aaj evening main send karta hu

  • @atul03031971
    @atul03031971 13 дней назад

    Ultimate Sharma ji...

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l 13 дней назад

    🎉🎉

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l 14 дней назад

    So Useful information

  • @rahulsulakhe8114
    @rahulsulakhe8114 16 дней назад

    Sir awesome teaches and ur videos discription helps to get information thank you... And Plz make videos on Msword also

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l 16 дней назад

    Very nice information

  • @goharraza2841
    @goharraza2841 17 дней назад

    great sir

  • @PunjabiTravellers.
    @PunjabiTravellers. 18 дней назад

    Nicely Explained 👍👌

  • @satinderpalsinghbhatia5030
    @satinderpalsinghbhatia5030 20 дней назад

    Very useful feature well explained

    • @itskillshala
      @itskillshala 19 дней назад

      Thanks for your kind words. 😊

  • @hellomyguys7651
    @hellomyguys7651 23 дня назад

    Very good ji

  • @rakeshkataria6924
    @rakeshkataria6924 24 дня назад

    nice...as always

  • @KochharAmandeep
    @KochharAmandeep 24 дня назад

    Amazing explanation sir as usual. A proud student 👏

    • @itskillshala
      @itskillshala 24 дня назад

      Thank you so much for your kind words! 😊

  • @Bhuvviiii
    @Bhuvviiii 29 дней назад

    🎉🎉

  • @Bhuvviiii
    @Bhuvviiii 29 дней назад

    Very useful information

  • @mustafaansari6478
    @mustafaansari6478 Месяц назад

    Sharing my experience, This channel is the best platform to learn excel for Beginners and Advance learner as well in the entire RUclips platform. I recommend everyone to subscribe to this channel whoever want to learn EXCEL with Good conceptual Knowledge.

    • @itskillshala
      @itskillshala Месяц назад

      "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. Месяц назад

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

  • @digitalgyaan1782
    @digitalgyaan1782 Месяц назад

    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 Месяц назад

      Kon sa software hai

    • @digitalgyaan1782
      @digitalgyaan1782 Месяц назад

      @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 Месяц назад

    Enable kre ya nhi

    • @itskillshala
      @itskillshala Месяц назад

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

  • @RahulKumar-lc7qh
    @RahulKumar-lc7qh Месяц назад

    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 Месяц назад

      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 Месяц назад

    Hi sir ms Word pe full video bnaiye plz

  • @Taxconstitution
    @Taxconstitution Месяц назад

    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 Месяц назад

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

  • @atul03031971
    @atul03031971 Месяц назад

    Useful information Sharmaji

  • @BhuvneshSharma-y2l
    @BhuvneshSharma-y2l Месяц назад

    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 2 месяца назад

    Very nice

  • @vbhambri3
    @vbhambri3 2 месяца назад

    Very nice

  • @naeemulhassan1426
    @naeemulhassan1426 2 месяца назад

    Sir hour plz upload a tutorial at hours calculation.

  • @titviral40
    @titviral40 2 месяца назад

    Good 👍