Posts

Showing posts with the label Advance ms excel

Pareto Chart In Ms Excel - Discover Talent Presents

 Pareto Chart for business analysis - #ParetoChart states that 80% / 20% ratio which understand the business problems, The Pareto chart analysis is a #statistical graphical technique used to map and rank business process problems #MsExcel checkout the more learning for #Analytics and #BusinessSolution with us , we also offer certifications with free of cost and career guidance #SixSigma we are launching soon hence urge you to subscribe our channel and get Free of cost #YellowSixSigma Certificate . It uses the Pareto Principle (also known as the 80/20 rule) the idea that by doing 20% of the work you can generate 80% of the benefit of doing the whole job. Discover Talent Presents what we offer work on large worksheet effectively check out the video and share your comments in below section and don’t forget us to subscribe because your one subscribes or thumb in the form of like motivate us to share #Free content for you all so please support #FreeCertification program by us  With the help

Discover Talent Presents Export Excel Table in SharePoint

Image
 Discover Talent Presents Export Excel Table in SharePoint In this series we are covering Discover Talent Presents – Export Excel worksheet data in SharePoint #Excel #ExportData its very easy way to transfer data from one sheet to other  We used to share videos for those too so stay with us and subscribe so you won’t miss any updates or new videos  We share excel expertise on this channel in this we are covering Quick Excel Tips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on google type discover talent presents and get the free if you want new videos on the same topic do comment below, we have created MsExcel videos for you. Ms excels tips if you have any confusion in understanding or need the file to follow along the steps comment your email id in below section will share so you can follow along the step’s applicable comments on YouTube only. #DiscoverTalentPresents our motto is to #Upskill everyone who has the internet they will learn free of cost no single penny nee

Correct VALUE Error in Excel

Image
 Discover Talent Presents | How to correct a VALUE error in the Excel function #Shorts  in this series are covering the topic called #VALUE_Error, this error is most often the result of specifying a mathematical operation with one or more cells that contain text...  If you don’t know what I meant about the context or through description don’t worry and watch the video if you still have issues in understanding then don’t hesitate comment on YouTube channel asking for the same. We are here to help you out the #VALUE!  It means the Wrong type of argument in a function or wrong type of operator These all functions or error handling method which right now showing in the video is just for that specific formula you may deep dive with the other formulas as well and relate or resolve the issue as per your problem statement , feel free to tag us on Instagram / Facebook  share us the workbook if by any chance you are stuck somewhere while resolving the issues #Learning #Certificate #ErrorHandling

Resolve NA Error in Ms Excel

Image
 in this series are covering the topic called #NA Error , Technically, this is not an error value but a special value that you can manually enter into a cell to indicate that you don’t yet have a necessary value ( NA – No Value available )  .  If you don’t know what I meant about the context or through description don’t worry and watch the video if you still have issues in understanding then don’t hesitate comment on YouTube channel asking for the same.  We are here to help you out the   These all functions or error handling method which right now showing in the video is just for that specific formula you may deep dive with the other formulas as well and relate or resolve the issue as per your problem statement , feel free to tag us on Instagram / Facebook  share us the workbook if by any chance you are stuck somewhere while resolving the issues #Learning #Certificate #ErrorHandlingTechnique these error handling advancement makes you more proficient in excel while you use any #Formula

Basics Function of Ms Excel

Image
 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

Data-Analyst-Essential-Skills

Image
 What all to learn to become a data analyst.  1. Programming Language: You can either learn Python or R. 2. Mathematics: Concepts such as Calculus (Integration, Differentiation) and Linear Algebra. Get Free Training #DataScience - Analytics and much more which are govt. Approved https://youtube.com/shorts/OdLGrJHXYS8?feature=share  Visit above link 🔗 leverage and enhance your skills  3. Statistics: Basic concepts of statistics such as Random variables, Population and Sample, Sampling methods, Mean, Mode, Median, Measure of Dispersion, Range, Variance, Standard Deviation, Q-Q plots, and Normal Distribution. 4. Basic Tools: Microsoft Excel and Microsoft Powerpoint. 5. Databases: SQL or NoSQL databases. 6. Business Intelligence Tools- Tableau, Power BI, or QlikView can be used to visualize the data. 7. Cloud Platforms- Microsoft Azure, AWS, etc. And some domain knowledge.  P.S Please feel free to add anything which I missed :)

MsExcel Insert Ribbon Tab

Image
 In this video series we will cover illustration MyAddin #InsertRibbon .  this will help you to effectively use the insertion function where you need to insert #clipart #logo #button #image #graphics #photo if any. So keep watching this video till end . and share your love with us by clicking on the #Like button . https://www.youtube.com/watch?v=23sX95u2wfM&list=PLCqnj_UiTQvPNZd8qDa23Jrm0AomlmTjy Also in upcoming #Video series we will cover #COVID19 data visualization with #charts and #3DMap so don’t miss the ending of this video also the beginning of that video. Would encourage you to subscribe our channel to learn and earn the #FreeCertificate in ms excel How ? watch our video series 1 where we have explained our #HowToBecomeCertified in #Excel. Last video series we Had covered the  A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by a

How do you concatenate cells in Excel

Image
 In this Tutorial we have covered #concatenate  ( #TextFunction , #HowToCombineText , #MsExcelTutorial  ) function which is available in ms excel.  This will save your lots of time and you will be more productive in your daily routine work .  The word concatenate is just another way of saying "to #combine" or "to join #together". We have also showed very basic step of #Text function or formula how do we leverage this in our daily routine as per our requirement complete your choice.  This whole tutorial in hindi we made it to make you understand . There may be other uses of this function but here we covered the basic thing . Text function specially ( DD, DDD, DDDD ) How it will change to the dates.  You may have queries like below then you are at the right place watch Hindi Tutorial for ms excel and be pro in your daily regime  text function in excel How to Combine Cells in Excel - Text or Numbers – Contextures How do you concatenate cells in Excel? How do you concat

Ms excel Questions by discover Talent presents

Image
Which keyboard shortcut opens the Go To dialog box? a. Ctrl + B b. Ctrl + Shift + B c. F2 d. F5 @@@@@@@@@@@@@@@@@@@ To keep specific rows and columns from scrolling off the screen you first must  position the cell pointer a. to the right of the column you want to remain on the screen b. below the row you want to remain on the screen c. on the row you want to remain on the screen d. both below and right of the row and column you want to remain on the screen @@@@@@@@@@@@@@@@@@@@@ When you create two or four separate windows containing part of the  spreadsheet that can be viewed, you have created a. sections b. panes c. views d. subsheets @@@@@@@@@@@@@@@@@@@@@ The accounting style shows negative numbers in a. Bold b. Brackets c. Paranthesis d. Quotes @@@@@@@@@@@@@@@@@@11 Which of the following component displays the contents of active cell? a. Name box b. Formula bar c. Menu bar d. Status bar @@@@@@@@@@@@@@@@@@@ How many sheets are there in Excel Workbook by default? a. 2 b. 3 c. 4 d. 5 @

Ms excel Solved Question and Answer

Image
Macro helps you to do automation?  A. True B. False When we use power pivot in Ms excel do we need to create raw dump in Table format?  A. True B. False

Ms Excel Frequently asked Question and Answer

Image
What function displays row data in a column or column data in a row ? Index Transpose Rows Hyperlinks Which of these will not select all the cells in a document? Pressing Ctrl + A on the keyboard All of above Using the Edit + Select All menu Clicking three times with the right mouse button in the spreadsheet

Discover Talent Presents | What is Excel name manager?

Image
Hi  i m your host Vinod today i will going to show you how to effectively use the NameManager Msexcel - DefineName. #ConditionalFormating . You may  have this question about #NameManager #DefineCell in #Spreadsheet #MsExcel :-  1. What is Excel name manager. 2 How cells are named in MS Excel  3. what are range names in Excel?  4. How can I create a formula in Excel? . 5. How do you create a range of data in Excel?  Don't worry this FAQ answers we have the solution watch this video till end .and share this video with your friends.  Steps for your reference to keep you handy! Select the range for which you want to create a Named Range in Excel.  Go to Formulas Define Name. In the New Name dialogue box, type the Name you wish to assign to the selected data range. Click OK. now what is the use of it and how to use in daily routine life so dont worry we are here to help you out !  Just type - #DiscoverTalentPresents on the Google and be found.  We are also available on the –  #Pinterest