Basics Function of Ms Excel
We have published more than 80 videos which are covering ms excel basic to advance. We also provide free ms excel certification which you add in your resume or CV . which creates value for your career . We share excel expertise on this channel ( #QuickExcelHacks , #ExcelTips, #MsExcelTraining , #MsExcel and #MsOffice Guide ) Free of cost ( no hidden charges ) urge you to subscribe us to upskill yourself
हमने 80 से अधिक वीडियो प्रकाशित किए हैं जो आगे बढ़ने के लिए एमएस एक्सेल बेसिक को कवर कर रहे हैं। हम मुफ्त एमएस एक्सेल सर्टिफिकेशन भी प्रदान करते हैं जिसे आप अपने रिज्यूम या सीवी में जोड़ते हैं। जो अपने कैरियर के लिए वैल्यू बनाता है . हम इस चैनल पर एक्सेल विशेषज्ञता साझा करते हैं (#QuickExcelHacks, #ExcelTips, #MsExcelTraining, #MsExcel और #MsOffice गाइड) मुफ्त (कोई छिपा शुल्क नहीं) आपसे आग्रह करते हैं कि आप हमें अपने आप को उप-कौशल प्रदान करने के लिए सदस्यता लें
Discover Talent Presents | Ms Excel training - You Should Know These Basic Functions of Excel - LIVE
here you should know the
Basic understanding of Excel
1. Excel Basics - How to Create sheet?
you must be aware there is difference between workbook and worksheet
workbook - when we open any file
worksheet - sheet 1, sheet 2 these are the worksheet
2. Excel Basics - adding Tabs
in excel there is option called sheets 1 , 2 , 3 when we open the ms excel first time bottom we can see
how to add those just right click on the sheet add/delete/rename it
if you are still not aware how to perform don't worry watch my previous video where I have clearly defied how it works exactly with step wise guide
3. Excel Basics - AutoSum
see we use excel for calculate the worksheet spreadsheet or our data there is most frequent use of the auto sum
4 Excel Basics - changing cell types
one of the crucial part in ms excel. we use data for visualization with the help of pivot and graph. prior that need to ensure we are using appropriate change cell type in the worksheet.
this option is available home ribbon tab and Number to date, Date to number etc.
or You can change the cell type by right-clicking on the cell and selecting "Format Cell"
5. excel basics formatting cells
for #Visualize our #Datasets in ms excel we need #Formatting this option is completely based upon your creative thoughts how you want to represent your data to the stakeholders or you want impress your boss
again #DataVisualization is the technique it's depends upon person to person and it's vary
this cell formatting will help you to change color, change font, change style of the spreadsheet
6. excel basics sorting data
in ms excel you could sort the data from ascending to descending order this will ease your work..
where is this option it's in data ribbon tab and right hand side you could see the #sorting in #excel
when we add the filters on the worksheet you could see the AZ or ZA Option which will also directly helpful for the Ascending Descending the data
7. Excel Basics Merging Cells
Two or more cells can be merged together to create one large cell.
8.Excel Basics Have basic understanding the formulas
in the initial phase when you are learning the excel let's have practise upon the below list on formulas
= Sum()
= Min ()
= Max ()
= If ()
= Count ()
etc.
you could get these on excel help section if not then visit my channel and learn comment for any understanding needs be clear we are here to happy to help you for #Upskilling #Learning is never ending.
now let's see last basic function of excel
8. Basic Function Excel combine Formulas
these function I will keep it last because when you be a professional in the 1-7 basic excel course you could easily get master mind in the 8 . option so what I meant Combine formulas how it will benefits you?
so it's really simple
when we use Vlookup function in excel and we need to merge match function in it somewhere this will be easy for data extraction
similarly when we use IF function in excel somewhere and you want to have total count with the help of count function you could do that.
so this is what I had my #Live video 🎥 1 shoot. if I made any mistake while explaining do leverage the description part and need your support to get subscriber which motivate me to create more #FreeTutorial #ExcelHacks #ExcelLearnings to all of you
if you are paying for any Institute I urge you to stop paying there leverage the free platform like Discover Talent Presents we conduct exam as well if you intrested to achieve #FreeCertification you could add those on your #Linkedin profile we will also help you to make #Joboriented person where most of the #ExcelUse
hope you find this useful
LIKE Comment SHARE