- Видео 385
- Просмотров 167 750
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.
Part 3: Mastering SUMIFS with Arrays as criteria?
Here @itskillshala we will learn:
1.SUMIFS function
2.SUMIFS functions with array constants
So Good Luck.
#Skillshala #MS Office #Hindi #excel #exceltipsandtricks #exceltips #exceltricks #excelforbegginers #exceltutorial #advancedexcel #excelcourse
it_skillshala
1.SUMIFS function
2.SUMIFS functions with array constants
So Good Luck.
#Skillshala #MS Office #Hindi #excel #exceltipsandtricks #exceltips #exceltricks #excelforbegginers #exceltutorial #advancedexcel #excelcourse
it_skillshala
Просмотров: 11
Видео
Part 2: mastering SUMIFS function.Handling date criteria with SUMIFS function.
Просмотров 427 часов назад
Here @itskillshala we will learn: 1.Mastering SUMIFS function in excel? 2.How the SUMIFS function works with dates criteria in excel? So Good Luck. #Skillshala #MS Office #Hindi #exceltipsandtricks #exceltips #exceltricks #exceltipsandtricksinhindi #learnexcelfree #advancedexcel #excelcourse it_skillshala
Part 1: Mastering SUMIFS Function in Excel
Просмотров 509 часов назад
Here @itskillshala we will learn: 1.What is SUMIFS Function? 2.What is purpose of SUMIFS function? 3.How the SUMIFS function handles multiple conditions in excel? 4.How SUMIFS function work with text conditions? 5.How SUMIFS function works with Numeric conditions? 6.How SUMIFS function works with Blank and NON Blanks cell's conditions? 7.How SUMIFS function work with conditions using wild card ...
Mastering SUMIF Function in MS Excel?
Просмотров 11419 часов назад
Here @itskillshala we will learn: 1.What is SUMIF Function? 2.How SUMIF function works? 3.How to sum values greater than or smaller than a specific number? 4.How to sum numeric values based on some text condition? 5.SUMIF using a cell reference. 6.SUMIF with Blank and Non-Blank cells. 7.SUMIF with wildcard characters 8.SUMIF with dates. 9.SUMIF with array constant. So Good Luck. #Skillshala #MS...
Part 1: Mastering SUM Function in MS Excel
Просмотров 9821 час назад
Here @itskillshala we will learn: 1.What is SUM Function? 2.Use of SUM Function. 3.Syntax of SUM Function. 4.How SUM Function helps to add numeric values? So Good Luck. #Skillshala #MS Office #Hindi #exceltipsandtricks #excel #exceltips #exceltricks #exceltutorial #excelforbegginers #advancedexcel #learnexcelfree it_skillshala
Master Even/Odd function in excel?How to round numbers using odd and even function in excel?
Просмотров 134Месяц назад
Here @itskillshala we will learn: 1.How to round number using Even function? 2.How to round number using Odd function? 3.Difference between Odd and Even function? So Good Luck. #Skillshala #MS Office #Hindi #excel #exceltips #exceltricks #exceltipsandtricks #exceltutorials #exceltraining #excelforbegginers #learnexcelonline #advancedexcel it_skillshala
Master TRUNC function in excel ? Truncate the fractional part of a number in excel
Просмотров 48Месяц назад
Here @itskillshala we will learn: Master TRUNC function in excel? Truncate the fractional part of a number using TRUNC Function. Difference between TRUNC and INT Function in excel. So Good Luck. #Skillshala #MS Office #Hindi #excel #excelinhindi #exceltips #exceltricks #exceltipsandtricks #exceltutorialsinhindi #advancedexcel #advancedexceltraining #excelcourse it_skillshala
Master INT Function in Excel? Round Numbers using INT function.
Просмотров 53Месяц назад
Here @itskillshala we will learn: 1.How to round numbers using INT function? 2.Round Negative numbers using INT function? 3.How to split Date and Time in excel using INT function? So Good Luck. #Skillshala #MS Office #Hindi #excel #exceltips #exceltricks #exceltipsandtricks #excelforbegginers #exceltutorial #advancedexcel #excelcourse it_skillshala
Mastering Ceiling.Math Function in Excel.
Просмотров 42Месяц назад
Here @itskillshala we will learn 1.What is Ceiling.Math Function in excel? 2.How to round numbers using ceiling.math function in excel? 3.How to round negative numbers using ceiling.math? 4.Difference between Floor.math and ceiling.math function in excel. 5.Difference between ceiling and ceiling.math in excel? So Good Luck. #Skillshala #MS Office #Hindi #excel #exceltipsandtricks #exceltips #ex...
Mastering Ceiling Function in Excel
Просмотров 33Месяц назад
Here @itskillshala we will learn: 1.How to round numbers using ceiling function? 2.How to round negative numbers using ceiling function in excel? So Good Luck. #Skillshala #MS Office #Hindi #excel #exceltipsandtricks #exceltipsandtricksinhindi #exceltips #exceltutorial #excelforbeginners #learnexcelfree #advancedexcel #advancedexceltraining #excelcourse it_skillshala
Mastering Floor Function in MS Excel | Difference between Floor and Floor.math
Просмотров 78Месяц назад
Here @itskillshala we will learn: 1.How the floor function works? 2.How to round numbers using floor function? 3.How to round negative numbers with floor function? 4.Round negative numbers towards zero with floor function? 5.Round negative numbers away from zero with floor function? 6.Difference between floor and floor.math function? 7.Difference between floor and mround function? So Good Luck....
Master Mround Function in MS Excel | Round Time values with Mround function.
Просмотров 54Месяц назад
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 #advanced...
Part 2: Round Function | Round Time Values | Round to specific decimal values | Round Expressions
Просмотров 72Месяц назад
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.
Просмотров 96Месяц назад
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
Просмотров 58Месяц назад
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.
Просмотров 98Месяц назад
Language Translator in excel. | Translate one language into another in excel.
How to embed Objects or External files in ms excel worksheet? | Mastering Embeded Objects in excel
Просмотров 1472 месяца назад
How to embed Objects or External files in ms excel worksheet? | Mastering Embeded Objects in excel
Thesaurus in Excel | Getting Synonyms in excel
Просмотров 502 месяца назад
Thesaurus in Excel | Getting Synonyms in excel
Part 6: Proofing | AutoCorrect | AutoFormat as you Type in excel?
Просмотров 1362 месяца назад
Part 6: Proofing | AutoCorrect | AutoFormat as you Type in excel?
Part 5: Proofing | AutoCorrect | AutoCorrect Exceptions in Excel.
Просмотров 1122 месяца назад
Part 5: Proofing | AutoCorrect | AutoCorrect Exceptions in Excel.
Part 4 Proofing | Understanding AutoCorrect Feature.
Просмотров 882 месяца назад
Part 4 Proofing | Understanding AutoCorrect Feature.
Part 3: Proofing | Mastering AutoCorrect feature in Excel.
Просмотров 1422 месяца назад
Part 3: Proofing | Mastering AutoCorrect feature in Excel.
Part 2: Proofing | Check and correct spellings within a range | Workbook | Formula and Comments ?
Просмотров 1312 месяца назад
Part 2: Proofing | Check and correct spellings within a range | Workbook | Formula and Comments ?
Part 1: Proofing in Excel | Spellchecker | Autocorrect Options in Excel
Просмотров 2962 месяца назад
Part 1: Proofing in Excel | Spellchecker | Autocorrect Options in Excel
Part 5 : Print an Excel worksheet | Print Titles | Grid-lines | Row & Column Headings | Page Order
Просмотров 3222 месяца назад
Part 5 : Print an Excel worksheet | Print Titles | Grid-lines | Row & Column Headings | Page Order
Part 4: Printing an Excel Worksheet | Insert | Remove | Reset Page Breaks in MS Excel.
Просмотров 3582 месяца назад
Part 4: Printing an Excel Worksheet | Insert | Remove | Reset Page Breaks in MS Excel.
Part 3 - Printing an Excel Worksheet | Master Scaling in MS Excel | Custom Scaling.
Просмотров 4222 месяца назад
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
Просмотров 2203 месяца назад
Part 2 : Printing an excel worksheet | Print Area | Margins | Orientation | Page Size
Happy Diwali to all viewers and excel lovers.
Просмотров 193 месяца назад
Happy Diwali to all viewers and excel lovers.
Part 1: Printing excel worksheet. | All Printing options
Просмотров 6813 месяца назад
Part 1: Printing excel worksheet. | All Printing options
Sir please upload practice file for practice
Nehi jurunga me
🙏
This is my favourite topic , thank you sir
My Pleasure
very important lecture, thank you
My Pleasure
Please provide practice file sir if possible
Very knowledgeable video
Thanks a lot
Very informative video
Thanks...
Thanks sir
My Pleasure
Great lecture, thank you very much sir!
Thanks 🙏
Nice sir
Keep watching
Good
Thanks
Awesome
Thanks...
We find your videos very informative Sahil ji..Thanks 🎉
Thanks..
Hi good morning sir very nice lecture Please upload pratice file
Thanks for watching! I'll upload a practice file soon.
nice
Thanks...
really helpful sir, subscribed
Glad it helped!
Kisi bhi number ko lakh me convert karne ke liye coding kya hoga. Sir please tell me
You got a new subscriber.. I subscribed your channel.. Thanks for uploading such informative video in detail, easily understandable. ❤
Thanks 😊
Not working
Happy New year Sir.... Very informative topic with easy explanation.....everything covered in single video.
Happy New year to you too.
Explain beautifully with full confidence, well done
Thanks....
Nice
Thanks...
Excellent Sharma ji
Thanks
Nice 👌
Thanks 😊
Nice tutorial but Can't find lesson 78
I will check
@@itskillshala Thanks, I forgot to mention, less 97 is also not available, plz check and upload both lessons (lesson 78 and lesson 97).
Keise hum k se normal may la sakta hay
Aap custom formating ko hata de
Ho hi nhi rha
It's working
@itskillshala okie i try again..
Need formula in excel please help, please solve and update a new function in excel. As I needed. A1 = 10 A2 = 0 A3= (Condition applied) My condition if A1>A2 then value in A5 is =A1 value as it is.
मायक्रोसॉफ्ट एक्सेस सिखाइये
Ji Jaldi hee
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 😊