Posts

Showing posts with the label Tutorials

CONVERT Function In Excel

Image
Ever found yourself grappling with a massive dataset in Excel, desperately trying to calculate the days and years since an employee's start date? Been there, done that! During my tenure in a renowned MNC's HR department, this challenge popped up more often than not. Imagine this – you've imported a colossal CSV file, and there it is, neatly arranged in columns. You spot the Date of Birth (DOB), and the lightbulb goes off – how do you crunch the numbers to get the total days and even years of service? In this video, I'm spilling the beans on a game-changing solution. I'll walk you through the process, sharing a nifty trick involving the CONVERT function that not only calculates the days but also reveals the exact number of years an employee has clocked in. Why am I sharing this gem? Because I've been in your shoes, navigating through the intricate world of HR, Finance, and IT domains. Trust me; this knowledge is a game-changer for professionals like us. So, take

Book Published by Author Dr Walwante

Image
धनतेरस (दिवाली) के शुभ अवसर का जश्न मनाते हुए, हम डिस्कवर टैलेंट में एक महत्वपूर्ण उपलब्धि साझा करते हुए रोमांचित हैं।  दूरदर्शी संस्थापक डॉ. विनोद राधा विश्वनाथ वाळवंटे गर्व से हमारे नव स्थापित एमएसएमई सरकार द्वारा अनुमोदित ऑनलाइन संस्थान और आईएसओ ( 9001:2001) प्रमाणित कंपनी का परिचय देते हैं। हमारे प्रिय डिस्कवर टैलेंट प्रेजेंट्स सदस्यों के अटूट समर्थन की सराहना करते हुए, हम अमेज़न पर तीन ज्ञानवर्धक पुस्तकों के प्रकाशन की घोषणा करते हुए उत्साहित हैं। ये पुस्तकें एमएस वर्ड 365 पेपर, हार्डकवर और किंडल संस्करण सहित विभिन्न प्रारूपों में उपलब्ध हैं। यह हमारी यात्रा में एक महत्वपूर्ण मील का पत्थर है, और हम आपके बहुमूल्य समर्थन के बिना इस बिंदु तक नहीं पहुंच सकते थे। हम डिस्कवर टैलेंट समुदाय का अभिन्न अंग बनने के लिए हार्दिक आभार व्यक्त करते हैं। आपका प्रोत्साहन निरंतर विकास और नवाचार के लिए हमारे जुनून को बढ़ावा देता है। इस अविश्वसनीय यात्रा में हमारे साथ रहने के लिए धन्यवाद।

PivotTable in Excel

Image
A PivotTable is a data processing tool commonly found in spreadsheet software, like Microsoft Excel or Google Sheets. It allows you to summarize and analyze large datasets by dynamically reorganizing and aggregating data.  With a PivotTable, you can create a compact summary report, extract insights, and identify trends from complex data. You can drag and drop fields from your dataset into the rows, columns, values, and filters areas of the PivotTable to organize and analyze data in various ways. This makes it easier to group, categorize, and calculate data based on different criteria. PivotTables provide features like filtering, sorting, and calculated fields to help you tailor your analysis. They are particularly useful when dealing with data that has multiple dimensions and requires flexible summarization.

Excel Interview Prepration

Image
Excel interview questions and answers help you prepare for your interview! If you have any more specific questions or need further assistance, feel free to ask. Good luck! Excel interview questions and answers! Below are some frequently asked questions along with their respective answers: Q: What is Microsoft Excel, and what is it used for? A: Microsoft Excel is a powerful spreadsheet application developed by Microsoft. It is used for various purposes, including data organization, analysis, manipulation, and visualization. Excel is widely used in businesses, finance, accounting, engineering, and many other fields to perform calculations, create charts, and manage large sets of data. Q: How do you freeze panes in Excel? A: Freezing panes in Excel allows you to keep specific rows and/or columns visible while scrolling through a large dataset. To freeze panes, follow these steps:    1. Select the cell below the row(s) you want to freeze and to the right of the column(s) you want to freeze

LEN Function in Excel

LEN Functions in Excel | How to Use LEN function in Excel | Calculate Text String in Excel The LEN function is a powerful tool in Microsoft Excel that allows users to calculate the length of a text string. It is especially useful when dealing with large datasets or when you need to perform operations based on the length of a cell's content. This description will provide an overview of the LEN function, explain how to use it in Excel, and highlight its practical applications. Join us on Discover Talent Presents to learn more about office 365 and Free certification open for trainers and educators  The LEN function can be particularly helpful when working with conditional formatting or data validation. For instance, you can use it to highlight cells that contain text strings exceeding a certain length. By applying conditional formatting rules based on the LEN function, you can easily identify and visually distinguish lengthy entries.

FIND formula in excel

Welcome to Discover Talent Presents! We are dedicated to providing valuable resources for your professional growth, especially in the realm of Microsoft Excel. Join us as we explore the world of business analysis and discover how to excel in Excel!  Our channel is a hub of knowledge for all things related to MS Office, and we offer our entire course free of charge. Whether you're an Excel enthusiast or seeking certification, we've got you covered. Clear the exam, and we'll happily provide you with the certification you deserve. To learn more, simply send us an email, and our team will assist you without any cost.  But that's not all! We understand that career growth extends beyond MS Office. That's why we also offer sources for free certification in various domains such as data analytics, arts, medical, science, and more. These certifications will undoubtedly add value to your CV and enhance your career prospects. Don't miss out on this opportunity—join our cour

Office Script and Automate in MS Office 2016

 #FAQ #Excel #Office365 Ask - Help ls its urgent. I have "Microsoft office professional plus 2016" in which "office script"/automate option is not showing. How can I find that option Ans - To access the "Office Scripts" feature in Microsoft Office Professional Plus 2016, please follow the steps below: 1. Open any Office application such as Word, Excel, or PowerPoint. 2. Click on the "File" tab at the top left corner of the screen. 3. Click on "Options" at the bottom left corner of the screen. 4. In the left-hand menu, select "Customize Ribbon." 5. In the right-hand menu, select the checkbox next to "Office Scripts." 6. Click "OK" to save the changes. If you do not see the "Office Scripts" option in the list, it is possible that this feature may not be included in your version of Office Professional Plus 2016. In this case, you may need to upgrade to a newer version of Office that includes the &quo

Shortcut Key in Excel

Excel is crucial in every small large-scale industry and MNC learn more about Office 365 shortcut keys of Excel sheet  CTRL+A. . . . . . . . . . . . . . . . . Select All CTRL+C. . . . . . . . . . . . . . . . . Copy CTRL+X. . . . . . . . . . . . . . . . . Cut CTRL+V. . . . . . . . . . . . . . . . . Paste CTRL+Z. . . . . . . . . . . . . . . . . Undo CTRL+B. . . . . . . . . . . . . . . . . Bold CTRL+U. . . . . . . . . . . . . . . . . Underline CTRL+I . . . . . . . . . . . . . . . . . Italic F1 . . . . . . . . . . . . . . . . . . . . . . Help F2 . . . . . . . . . . . . . . . . . . . . . Rename selected object F3 . . . . . . . . . . . . . . . . . . . . . Find all files F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window F6 . . . . . . . . . . . . . . . . . . . . . Shifts focus in Windows Explorer F10 . . . . . . . . . . . . . . . . . . . . Activates menu bar options ALT+TAB . . . . . . . . . .

Format Painter in Excel

Image
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 #Trick

Add background image in Excel Worksheet

Image
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 penny

Free Online Courses

Image
 In Lockdown Get 100% Free Training's | free training courses | Free Online Courses | 50+ Free Course As we all know lockdown in place due to Covid19 things are not really good but as we can hope for the best we need to invest some time in self this is the right time to learn more and upskill we discover talent presents are here to help you out with interview preparation, Ms office trainings and 100% free trainings material one of the website like.  Credly is the world's largest network especially when you login to the linked in or the Facebook and when you search some trainings you can find the #Credly whereas per your areas of interest you can enrol  for the #FreeTrainings #Certification #Badges you will get it watch out our video series you will come to know how to explore this website and what is the procedure to sign up or sign in for this website. Also there are some paid trainings to in the Credly however if you analyze the website in proper way you will come to know to