Discover Talent™

Fix Excel SUMIFS Returning 0 | Complete Practical Guide F T in WA Excel SUMIFS Not Working? Here’s the Real Fix If your Excel SUMIFS formula is returning 0 even though data exists, you're not alone. This issue usually comes from hidden formatting problems that most users overlook. 🎥 Watch Practical Explanation Common Business Scenario In real workflows, decision-makers often need quick answers like: What is the total sales for Mumbai? How much revenue did Electronics generate in Delhi? Which segment is performing the best? Instead of building dashboards, SUMIFS helps you answer instantly . Why Your SUMIFS Formula Fails The main culprit is unclean data . Extra spaces, especially trailing or leading ones, make Excel treat values as different. Smart Fix Using TRIM The TRIM function removes unwanted spaces and aligns your dataset properly. Once applied, your SUMIFS will start returning accurate results. Using Multiple Criteria...

By Discover Talent Design a Smart, Visual, and Automated Excel Action Plan Tracker Excel is more than just rows and columns. In this practical tutorial, Discover Talent demonstrates how to build a professional Action Plan Tracker inside Excel that visually monitors progress, ownership, deadlines, and completion status without using any external tools. The tracker begins with a clean header design, customized fonts, and color-coded sections. Each action item is assigned a unique Action ID, linked to a project name, priority level, owner, due date, and real-time status. Conditional formatting is used to automatically apply red for Not Started, yellow for In Progress, and green for Completed tasks. A completion percentage column adds instant clarity, making this tracker ideal for audits, project reviews, and management reporting. To elevate the design, gridlines are removed, alignment is optimized, and percentage indicators are rotated for a dashboard-style layout. The re...

Calculate Percentage in Excel Excel is a valuable tool for data analysis, and calculating percentages is a fundamental task within it. This article will show you how to use Excel's percentage formulas in two common business scenarios: 1. Calculating Student/Employee Exam Accuracy Scenario: Imagine you have a spreadsheet with the number of correct answers and the total number of questions for a set of exams. You want to determine the accuracy for each exam. Example: 2. Calculating Percentage of a Specific Value Example: Format the cells containing percentages as "Percentage" using the number formatting options in Excel. Data Validation: Use data validation rules to make sure the input values are within the expected range (e.g., between 0 and 100 for percentages).Cell References: Understand the difference between absolute and relative cell references to efficiently apply formulas across multiple cells. Learn More: For more detailed learning and to explore advanced Excel fun...

#XLOOKUP is a powerful function in Microsoft Excel that allows you to search for a value in a range of cells and return a corresponding value from another range of cells. It was introduced in Excel 365 and is available in all versions of Excel that have been released after that. To use the #XLOOKUP function, you need to provide four pieces of information: The value you want to search for The range of cells you want to search in The range of cells that contains the values you want to return Optional: criteria for the search, such as an approximate match or an exact match Here's an example of how to use the #XLOOKUP function: Assume that you have a list of student names in column A and their corresponding grades in column B. You want to find the grade of a specific student, whose name is in  specific student, whose name is in cell D2. You can use the #XLOOKUP function as follows: =XLOOKUP(D2,A2:A10,B2:B10) This formula will search for the name in cell D2 within the range A2:A10, and ...

 Discover Talent Presents -Extract Domain Name from an Email ID in Excel -1 if you want to see how to extract a user name feel free to watch our previous video series Extract User Name from an Email ID in Excel  Extract Domain Name from an Email ID in Excel In #Excel when we have raw dump with email id's and we need to adhere ETL ( Extract , Transform and Load ) in excel that time formulas and function plays a really important role in this tutorial as well i have demonstrated how you can segregate user name from email id with 2 unique ways feel free to comment in below section which step you loved the most and which save your time make you more productive in your daily regime office work #LEFT #Search Function and #FindAndReplace . These steps are simple and easy to perform if you still find any difficulty to perform feel free to ping me on FB / LINKED IN / Youtube / Instagram channel Happy to assist  You can type this on the google Discover talent presents to get the ...

How to use SumIfs Function  Discover Talent Presents - Sum Ifs Function in Ms Excel #Shorts #Excel #SumIfs . Sum function will help you to get the total of specific value , SUMIFS help you to add multiple condition based on that you will get the summary based #Total of the #Sales / #Salary whatever data you wish to have the #GrandTotal in this tutorial we have tried the sample data sheet where you can add the #Criteria for #SumIfs #Function or #Formula and get the result instantly . Urge you to pause on the video wherever required. our motto is to #Upskill our #People #FreeOfCost  You can type this on the google Discover talent presents to get the free learning material for #MsexcelTraining Hurry up.! We also available on the below platforms. Pinterest https://www.pinterest.com/DiscoverTalentPresents Instagram (#Reels & #IGTV): @DiscoverTalent143  Tumblr: - https://discover-talent-present.tumblr.com  YouTube: (#Shorts) – https://www.youtube.com/DiscoverTalent1...

Discover Talent Presents | Arrange Objects Quickly in Ms Excel - Selection Pane Ms Excel  #Excel #Shorts #SelectionPane  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...

Add background image in Excel Worksheet - Discover Talent Presents #Excel #Shorts #BackgroundImage 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 pe...

 Short cut key Discover Talent Presents - Sum In Excel get #Total in #MsExcel #Shorts #Total_SUM_Excel  We discover talent presents here to help you out boost in your Career , As 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 could not miss any single updates. #Shorts we are creating for urgent followers who want to have #QuickSkills #Discov...

Discover Talent Presents | AI Driven Datasets in Excel - Artificial Intelligence in excel Tutorial –  These datasets will help you to analyze correct and realtime information in #Excel #AI #Data  Automation new scope etc etc. now do you know the excel have that ability who help us to Analyse the data and share us the insights as per ML #AI now you will ask what is ML (Machine learning) basically the task which we used to do same done by the ML more effectively with less errors. Everyone knows #MsExcel but how are we different from others knowing the #NewFeature like this so here we discover talent presents give you the demonstration how this works and how could you create chart without hassle so watch this video entirely and share your feedback in below comment section if any. we are happy to answer those also if you are seeking any certification, which creates value for your career. We used to share videos for those too so stay with us and subscribe so you won’t miss any upda...

 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...

 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 i...

 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...

 I need 7K views targets 🎯 To get new video 🎥 published  Pls show your support coming #Live soon #LiveQuiz  REPLACE Formula in Excel | Change Text with Excel REPLACE Function | How To Use Replace Function  Discover Talent Presents – Replace Function in Excel | How to Use Replace Formula in Ms Excel #Shorts In Accounting, Finance, MIS Related Work Or Any Organization We See The #Shorts  Password protection Salary protected Sheets We Need To Prepare In Data Sheets Through The #ReplaceFunction Function Which Is Available In #Msexcel You Can Easily Do It Without Hassle Watch This YouTube #Shorts And Understand The Ms Excel Tips And Tricks Easy Way with 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 coverin...

 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..!

How to use HLOOKUP Excel Function | Hookup formula in excel | Hlookup vs Vlookup function in Excel  if you are starting with the basics  we are here to help you out learn more about spreadsheets and more importantly the use of  #Formulas which is used in #MsExcel we will guide you each step one by one in this series we have covered the horizontal lookup which retrieve the value which is placed in horizontal way check out our #vlookup shorts as well where we have defined how to use the vlookup and hlookup function we would encourage you to subscribe this channel so you wont missed the important #dataanalysis technique #freecertification  #certification by Discover talent presents if you want to know more about us do  Search us on google typing Discover Talent Presents and enroll 100% free without any cost This function is really effective for any company when we have the large data sets we can't go ahead and manually perform the task instead with. The help of =Hl...

 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 

 Everyone beginner to experience holder who uses the Ms excel they know how to calculate total in Ms excel. Which is good part part. However being known excel and in reality being more productive in our daily regime is more important So here is the Quick Tip from discover talent presents how quickly you could add the sun value for respective cells in Ms excel This video we have demonstrate that the fast work or more productive work applicable any laptop user then if you are windows user or MAC user.  As you know with the help of =Sum() function we could add the total But here with help of keyboard short cuts fraction of sec you will get the result Try this ExcelHack and share your feedback in below comment. 

Discover Talent Presents | Home Ribbon Tab - Conditional Formatting Tutorial 5-6 In this video series we will cover the #ConditionalFormatting #FormatAsStyles #CellStyles #MsExcel #MsExcelTraining . If you are New to my channel would recommend you to subscribe my channel on YouTube .We have covered #Clipboard, #Font, #Alignment , #Number & and in this series we will cover #Styles.  Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you'll need to create a conditional formatting rule. So stay with me and watch the complete video series this made for the beginners who wish to start there career in #Reportng #Anlyst #WorkinMsExcel   Type on Google #DiscoverTalentPresents for FREE Certification in Excel By Discover Talent Presents ( Like , Share , Comment ) Discover Talent Presents | Learn Basic Ms excel – Tutorial 1 https://www.youtube.com/watch?v=09lIUqJlf2s D...

Learn with Discover Talent presents  Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. https://en.wikipedia Total version of #MsExcelTraining  #BasicExcel #MsExcelTutorial 6.2 MicrosoftWindows 6.2.1 #Excel2.0 (1987) 6.2.2 #Excel3.0 (1990) 6.2.3 #Excel4.0 (1992) 6.2.4 #Excel5.0 (1993) 6.2.5 #Excel95 (v7.0) 6.2.6 #Excel97 (v8.0) 6.2.7 #Excel2000 (v9.0) 6.2.8 #Excel2002 (v10.0) 6.2.9 #Excel2003 (v11.0) 6.2.10 #Excel2007 (v12.0) 6.2.11 #Excel2010 (v14.0) 6.2.12 #Excel2013 (v15.0) 6.2.13 #Excel2016 (v16.0) 6.2.14 #Excel2019, #Office365 and subsequent (v16.0) Comments much appreciated  We are coming with discover talent certification program free of cost only for the #discovertalent143 subscribers to know more visit our YouTube channel and explore our videos. We also available on #facebookwatch #youtube #instagram  We are covering all the menu bars one by one in our upcoming video series so stay up to date with me #discovertalentp...