Discover Talent™

TEXTJOIN in Excel - How to use TEXTJOIN formula in Excel - TEXTJOIN Based on The Delimiter #shorts if incase you have the specific delimiter you can add that to bifurcate the text value while joining the text if incase no delimiter is there then you could keep that blank, you can join this text through #TextJoin or #concatenate function which is available on the #ExcelFormula we have already created the videos on this this especially for #Extract #Transform and #Load process while getting a #DataSet from one source and #Analyze this in a better way Not only this formula in upcoming days we are ensuring to cover more generic and most useful function in #Office / #College / #Schools specially teachers who create assignment or team leaders , SME's who are looking out for their promotion we will ensure in upcoming series we will get that cover for that we need your support by \SUBSCRIBING this channel , which motivate us to take out some time for you . We discover talent presents he

Add PowerPoint Presentation in Ms Excel Supposing you have a sheet with some data, for vivid and interesting look, you want to insert a colorful background behind cell and worksheet 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 need to pay any other institution will provide you certific

Rate Conversion in Ms Excel | Euro Tool | Options in Excel Add in | EUROCONVERT function #Euro #Excel #RateConversion  How to add prefix in ms excel checkout #prefix #msexcel #shorts  Discover Talent Presents - How to Add Prefix in Ms Excel We discover talent presents here to help you out boost in your Career  ,we all know every organization small - large ms excel used for analytics or maintaining data entry . In our channel we are covering entire Ms Office course free of cost ( also if you are seeking certification in excel will issue you for the same once you clear the exam more details share us a email will help you out FREE FREE FREE ) apart from ms office if you are keen intrested in other domain like Data analytics , Arts , Medical , Science or any other field we used to provide sources of #FreeCertification which will ease you to add value in your CV .You could enhance your career by joining those courses so what are you waiting for SUBSCRIBE us and turn on the bell i con so you

 Use Filters Effectively in excel - Filters function is the essential feature in ms excel you can either use the ctrl + shift + L or you can use Alt + D + F + F for the filter the specific work sheet in ms excel #Filter and the #AdvanceFilter how to use this function more smartly in the series i have covered for the same.    #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

 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 - How to use Microsoft Visio | How to Create Flow chart in Microsoft Visio #MicrosoftVisio is the most creative tool I can say this will help you to #DataVisualization and #FlowChart creation purpose now it’s completely depend upon your usage how you needed as per your requirement in the series we have the #BasicsVisio tutorial if you need more help on this you can directly pings us on Facebook, Instagram we are happy to help you .  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

 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

 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

Discover Talent Presents | How to correct a REF! error in the Excel function | #Shorts #REF #Formula The #REF! error shows when a formula refers to a cell that's not valid   in this series are covering the topic called #REF Error, In This error occurs when you delete a cell referred to in the formula or if you paste cells over the ones referred to in the formula.  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 #REF! error shows when a formula refers to a cell that's not valid   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 cha

 Discover Talent Presents | How to correct a NAME error in the Excel function #Shorts #NAME! #Formula in this series are covering the topic called #NAME Error This error value appears when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a text string in a formula. (When our spreadsheets are unable to find the excel name that time it occurs) .  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 res

 REPT Function in Excel | How to Use REPT Function | What is the Use REPT In Excel  the #REPT Function is categorized under #Logicalfunctions. The formula will repeat characters a given number of times.  This will help you to #Visualize the #DataSets in Excel especially if you are financial institution or large-scale industry where you want to do #datavisualization or as a #DataSecracy you need hide the exact value of #dollar #Rupee or anything you can do it just click on the play button watch this video till end. You will be fill grateful today after watching this video and learn something new for sure. What exactly this #REPTFunction does ? we have covered this in the video still some glimpse in the form of text is here do refer and sharr your feedback Summary. It basically the Repeat text as specified. The repeated text. You can type this formula like this  =REPT (text, number_times) text - The text to repeat. number_times - The number of times to repeat text. The REPT function repe

 Discover Talent Presents - Substitute Function in excel | SUBSTITUTE Formula in Excel |  Excel Formula Substitutes is the best function in ms excel which help you to replace from one old text to new text string . Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string we have shown to functions in our channel #ReplaceFunction #SubstituteFunction as well checkout our #Shorts and get hands on the #MsExcel Training tutorial free of cost we are here to help you out if incase you would need more support on the understanding #DiscoverTalentPresetns don’t forget us to subscribe on the Youtube Instagram we use to share #ExcelMemer hash tag and we share #Memes in such way so you can understand the concept of #excel trainings  We have published more than 150 videos which are covering Ms excel basic to advance. We also provide free ms excel certification which you add in your resume

Discover Talent Presents - Copy Format Painter in Excel  Format Painter in Excel | Excel Formatting, in every small or large scale industry #MsExcel used while performing datasheet or #Analytics #FormatPainter best option to replicate the formatting across other #worksheet or #workbook , we replicate the formatting one column or row wise its difficult to apply as its  #Manualwork here in excel now you at one single #MouseClick easily #CopyFormatPainter do you already know this trick ? if yes watch one more time for rehearsal if no then urge you to watch and apply in your #DailyRotine work period happy learning we use to share such excel tips , tricks , excel hacks and much more We have published more than 150 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 in this we are covering #QuickExcelTips #ExcelHacks #Shorts #Tricks

Hide text in spreadsheet discover talent presents Welcome to our channel this #Tips #HideText #MsExcel will help you to work more proactively and effectively in your daily regime Select the cells that contain sensitive data you want to hide. Right-click to choose “Format Cells” option from the drop-down menu. On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box. #ShortcutKey to open format cell is CTRL + 1. Learn more with us and in #MsExcel lets take look and watch video till end and do also share your feedback proactively in below comment section – Discover Talent Presents We have published more than 150 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 in this we are covering #QuickExcelTips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on go

Create Data Entry Form in Excel - discover talent presents  Welcome to our channel this #QuickAccessToolbar #DataEntry #Form in excel #Tips #HideText #MsExcel will help you to work more proactively and effectively in your daily regime Select the cells that contain sensitive data you want to hide. Right-click to choose “Format Cells” option from the drop-down menu. On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box. #ShortcutKey to open format cell is CTRL + 1. Learn more with us and in #MsExcel lets take look and watch video till end and do also share your feedback proactively in below comment section – Discover Talent Presents We have published more than 150 videos which are covering Ms excel basic to advance. We also provide free ms excel certification which you add in your resume or CV.  If any issues occurred while playing video 🎥 don't worry visit our below video which creates value for your career. We shar

 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 :)

 One of the essential function in excel  Not Equal To Operator In EXCEL | Excel formula Highlight column differences   | New Rule Unique Value How to change color if two cells are not equal in Excel? when we work in our daily regime we have the situation to highlight the difference value This function more frequently used in MIS and Office reporting system would recommend to watch our discover talent presents channel on YouTube or Google free of cost no addon or extra fee  ( conditional formatting  is not really helpful ) you can check out this video which will hep you to see the difference data  #NotEqualTo #NewRule #ConditionalFormmating type on google Discover talent presents #msexcel training and watch out more free learning 100% Certification across all stream ( #Finance , #IT #NonIT and other)  if you are new to this channel would encourage you to subscribe our Discover Talent Presents now..!

 Ms Excel  vlookup function will help you to look up value vertically across different worksheet sheet or cell  This will function is most popular function among every industry ( small scale and Large scale) This excel function majorly used in skills MIS ( management information system) WFM ( Work force management) back office related , accounting etc.  Take a look at below video and understand how we can use this in frequently in our daily regime  You can also search us on google just type Discover Talent Presents and learn more excel function along with Powerpoint and Ms Word if you wish to learn more  Type your comments on YouTube ▶️ section and do let us know if you want to learn any specific function or formula we are here to help you with 100% training do  also take a note we also provide 100% free certification explore more on  YouTube 

Concatenate in Excel combine text columns | Excel using the #CONCATENATE function and "&" operator Combine Two or More columns in One Use of Concatenate  Join Text in Ms Excel .MIS work or daily regime especially in MNC’s / KPO / BPO where we have maximum use of #MsExcel you may have situation right where you get the raw dump or csv file from stakeholders and need to published in appropriate format or in school/ Colleges / Universities you have the list of student which are holding there first name last name or employee details with First and Last name in SQL with Join query we can easily do that however in excel Concatenate is the essential function which will help you to save your time and combine n numbers of column in one . Take look at this video and share your thoughts if any difficulty to understand ... Open for the feedback as always #ExcelFunction #TipsAndTricks  As Education is our Right so we offer this service free of cost Do subscribe us for more Learnings an

You may have heard the name. Of #Treemap but do you know how to use it in your daily regime here we #discovertalentpresents up with the #exceltraining  #education  #tutorials free of cost to one 👍 who are passionate about learning new things 🔥 . knowing new things always helps you to boost your career watch out the entire video on #IGTV  or #Youtube  and support us #Excel #discovertalentpresents as you guys are aware Tree map uses in #PowerBI and #Tableau as well  where you can #Visualize #Datavisualization in Better Try out  #Treemap is one of the best self-explanatory graph or chart in excel . Create Treemap chart in excel.  which we can use in our daily , monthly ,yearly or quarterly reporting’s . Treemaps are very easy to add in excel in this series we have covered the same thing feel free to share your thoughts in below comment section which will help us to improvise our content quality in upcoming videos .  Tree map used in power Bi , Tableau   And this is the most demanding #C