Posts

Showing posts with the label Advance skills

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

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