Posts

Showing posts with the label excel tips and tricks

Calculate Grades in Excel

Image
Calculate Grades in Excel In this video series, we will explore practical Excel formulas for calculating grades and managing scores across various educational and professional settings. Whether you're dealing with school grades, college assessments, university evaluations, or MNC Process Knowledge Tests (PKTs), our tutorials will provide clear and actionable insights on using Excel to streamline these processes. Our focus is on showing you how to use Excel effectively to evaluate and discover talent based on training and performance metrics. Each video will walk you through essential formulas and techniques that can be applied in different contexts to help you manage and analyze data efficiently. We are committed to offering this content for free for a limited time. If you have specific training topics or formulas you’d like us to cover, please share your suggestions. We are eager to incorporate your feedback into future videos. Our goal is to reach 20,000 subscribers and achieve 1

TEXTJOIN to Combine Text

Image
 TEXTJOIN to Combine TextDiscover Talent is dedicated to helping you improve your business productivity through our range of Excel training and support services. Whether you are a beginner just starting out or a professional looking to sharpen your skills, we have something for everyone. Our offerings include Excel certification, practical tips and tricks, dashboard creation, and specialized support from our team of Excel experts. We have added 30 seconds video to easy understand about TEXT JOIN Function which Combines multiple cells value. In our latest series, we are excited to introduce the TEXTJOIN function. This powerful function in Excel is designed to combine text from multiple cells or ranges into one string, with a delimiter of your choice separating each value. It’s a simple yet incredibly useful tool for anyone who works with large sets of data and needs to streamline text management. Instead of manually copying and pasting text from different cells, use TEXTJOIN to merge th

FILTER and LARGE Formula

Image
Learn FILTER and LARGE Formula in Excel Learning is an ongoing journey, and mastering essential business skills such as sales, purchasing, finance, and calculations is crucial for success. Excel is a powerful tool that can greatly assist in managing and analyzing these aspects of your business. In our latest video, we delve into how you can leverage two of Excel’s most useful functions, LARGE and FILTER , to identify the top 3 values in your data effortlessly. In this comprehensive tutorial, we provide a step-by-step guide on using the LARGE function to find the highest values in your dataset. We then show how the FILTER function can be combined to streamline your analysis and pinpoint these top values quickly. By using these functions, you can save valuable time and improve your efficiency in handling large datasets. We explain each step clearly, with practical examples, so you can easily follow along and apply these techniques to your own data. Whether you’re managing sales figure

Value Extraction in Excel

Enhancing Value Extraction in Excel - Excel Tips for Improved Office Productivity Are you looking to optimize your Excel skills and boost your career? At We Discover Talent, we have compiled a list of valuable tips to help you extract maximum value from Excel. Whether you need to analyze data or manage data entry in organizations of any size, Excel is a powerful tool. Our tutorials and training sessions cover various aspects, including formula usage, dashboard creation, and advanced Excel techniques. Take advantage of our educational resources to enhance your Excel proficiency and excel in your professional journey. #proficiency #exceltips #Reels #Viral #Educator #Microsoft #Learner #homeeducator #Tutorial #excel #DiscoverTalentPresents #Udemy Follow the Link in Description or Contact me for more learnings #tiktok Enhancing Excel Efficiency: Valuable Techniques for Extracting Data In today's professional landscape, proficiency in Microsoft Excel is essential for individuals looking

Find the Largest Number in Excel

Image
Discover Talent Presents - Find the Largest Number in Excel When there are duplicates MAX or LARGE Function  , this is essential function in ms excel #LARGE #MAX #Formula in #Excel in this series clearly explain how it works max function and its feature  also clearly defined how we can add the FREQUENCY AND #IF formula in #LARGE_Function which fetch the correct result from the #BigData watch this video entirely and dont skip it .   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/DiscoverTalent143  Facebook: - https://www.Facebook.com/DiscoverTalent143  LinkedIn: - https://in.linkedin.com/in/discovertalent143 Blogger: https://discover-talent-presents.blogspot.com Teleg

How to use SumIfs Function

Image
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/DiscoverTalent143  Facebook: - htt

Artificial Intelligence in excel

Image
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 updates or ne

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

=SUM() or Alt + = Which is best?

 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. 

Home Ribbon Tab MsExcel

Image
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 Discover Ta

Add Header and Footer for Ms excel

 In this video we have covered how to setup a page while taking a printout in #MsExcel and also covered the importance of #PageSetup and #ViewTab in #MicrosoftExcel  This video will help you before you taking a any printout to make sure how to select page setup ( #Protrait , #Landscape ) #PageMargin and why we use the #NarrowMargin while giving the printout .  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  What is Page Setup in Excel? How do you set page area in Excel? How do I set my printer page? Why is Page Setup greyed out in Excel? What is the use of view tab ? How to add header and footer in excel sheet? How to add header in excel sheet Our consistent #DiscoverTalent143 follower gave us the recommendation video who is the winner of #MrsFaceOfIndia2020 #PreetiThakuria watch her message at the end.  This function will help you to make your work smartly in your #DailyRegime #Office , #School #College