Posts

Showing posts with the label Advance excel

Extract Data in Excel with Easy Steps

Image
Discover Talent Presents - Extract User 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 scan too for having a course  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 In

SUBSTITUTE Function in Excel

Image
 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

Not Equal To Operator In EXCEL

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

Treemap in MsExcel | Discover Talent Presents

Image
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

How do you show Time in excel

Image
 Learn with us #DiscoverTalent with easy steps how you can add the TIME in excel not only addition but also you can do the TOTAL of total hours are in placed.  Learn how to do formatting in #msxcel while using a #timestamp  As we all know adding time in ms excel while tracking a employees data is really importnat so usually do a ctrl+shift+; its nice but not always when we work in the multinational company as a #MIS ,Backoffice or any other post as we know ms excel is really importnat . After watching this video you will be able to set specific formatting in the excel sheet where you want to add the time stamp for in and out . this also helps to maintain #downtimetracker during this #covid situation  as we all know every one is almost doing work from home to track their attendance or shift time we usually use a time function and in this tutorial its almost cover how to recifty the #error time function and how to effectively use the time function we plotted this in three diffrent segeme

Ms Excel TOP10 Tricks

Image
 Every excel user should know this  Learn with Discover Talent presents #QuickAnalysisTool , #GoalSeek , #Vlookup , #Filter , #Dropdownlist , #Edatefunction, #RemoveDuplicates, #Autofitcolumnwidth, #FlashFill #AutoFill and #PasteSpecial . We are well known about this acronym In ms excel especially the #MIS or #OfficeStaff but the people who is In the beginner level and they wish to learn about this functionality so for that we have prepared this video series  #QuickAnalysisTool – it helps you to easily prepared summary , charts calculation one single click to know more watchout our videos.   #GoalSeek – This is the most popular function in #MsExcel where people wanted identify the value  which will tally the given total, As per #Wiki - In computing, goal seeking is the ability to calculate backward to obtain an input that would result in a given output. This can also be called what-if analysis or back-solving. It can either be attempted through trial and improvement or more logical mea

How to create rotational WO attendance sheet with 4 Simple Formulas

  In this video we have covered How to create #rotational week off #attendance sheet with 4 Simple Formulas in #MsExcel TOP MNC’s projects having such requirement also during this pandemic Virtual #Schools #Colleges staff management may have this requirement so urge you to watch this video till end  If you have #FixedWeekOff in place then watch the below video  https://www.youtube.com/watch?v=xi7xhqu1mNs if you need to #PractiseMaterial then please do share your email id in below comments  PS :- People who subscribed #DiscoverTalent143 those only get the practise material . .  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  How to create attendance sheet in excel ? Which formulas should I use while making a attendance sheet ? What is the charges for attendance sheet ? How quickly you will make attendance sheet ? What things needs to be in consideration while making a attendance sheet ? What is discover t

How do you use Subtotal in Excel?

Image
 As we all know in every daily routine office work, school work, colleage work, pvt, govt companies need a Ms excel.  Also to calculate the certain amount we would require calculation not only the formulas but also sometimes bit tips like pivotable See when you apply pivotable on the sheet it's not directly give you summary report. It's shows you a result however to have the summary we need to copy that data in other sheet and make it out the formatting thing.  What if you are hurry and don't have time to copy paste thing in separate sheet and your boss asked you to share him or her subtotal How do you use Subtotal in Excel? Watch this video full.  It's very easy method where you will learn so many new concept and it saves your time 

Consolidate data in multiple worksheets – Excel

Image
 Learn #MsExcel with us if you are unsure how to #Consolidate the XLS file then watch #MsExcelTutorial free of cost. learning is always necessary  If you have the queries like below then you are at the right place watch Hindi Tutorial for ms excel and be pro in your daily regime  How do I create a consolidated sheet in Excel? How do you delete consolidate in Excel? Where is consolidate in Excel? Consolidate data in multiple worksheets – Excel In this tutorial we have shown 3 tabs where you can consolidate file in it however if you want you can consolidate the sheets as well whichever location they are available to make you understand we create this basic level tutorial  . Thanks for watching this video and if you are new on this YouTube then please subscribe our channel  This function will help you to make your work smartly in your #DailyRegime #Office , #School #Colleges etc. #MIS #Reports  Just type - #DiscoverTalentPresents on the Google and be found.  We are also available on the –

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 | MCQ of Ms Excel For all kind of Examinations

Image
 Hi i m your host Vinod today i will going to show you today #QuestionAndAnswer #FAQ #ImportantQnA #MsExcel #MCQ You may have this question about   1  TOP 30Question and Answer for Ms Excel ?  2.MCQ Ms Excel?  3.Most Common Microsoft Excel Interview Questions ? 4  ms excel interview questions and answer paper?  5  Competitive examexamfff4 Ms excel preparation 5. Multiple Choice question with answers for Ms excel  This all question's answer you will find here.!  If you are new visitor on this blog the  urge you to do subscribe  us!  Which will not only help you but it will also helps to provide content to right people.   Don't worry this FAQ answers we have the solution watch this video till end .and share this video with your friends.  In the upcoming competitive exams also such ms excel related question and answer get cover , its also involved the interview question and answer if you are aspiring for #MScit Examination then urge you to practise with this question you will crac

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