- Видео 374
- Просмотров 131 597
IT Skillshala
Индия
Добавлен 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.
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
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
Super job Sir
Thanks
Good knowledge
🙏
Please upload practice file if possible sir
Sure, I will upload soon.
@itskillshala thanks🙏 sir ji
Only channel on RUclips for detailed explanation of each topic of excel
Thank you so much for your kind words. I am trying my best to make these videos as helpful and detailed as possible.
Nice guidance
Thanks...
How to write date like 1st 2nd 3rd 4th with month in custom format
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.
Good explanation
Thanks...
Very good 🎉
Thanks...
Sir iska sheet ka link de dijiye
Ji Sure.Main aaj evening main send karta hu
Ultimate Sharma ji...
Thanks 😊
🎉🎉
Thanks 😊
So Useful information
Thanks....
Sir awesome teaches and ur videos discription helps to get information thank you... And Plz make videos on Msword also
My Pleasure....
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! 😊
🎉🎉
Thanks 😊
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 RUclips 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...