Discover Talent™

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

 In this #MsExcel video series we will cover #Pivottable #Pivotchart and #RecommendedPivottables this three function you will in the #Msexcel #InsertRibbon tab .  Checkout more on YouTube / Facebook Hurry  Also once you complete the learning from us we will reward you Certificate of Msexcel To know more visit our YouTube channel.  As we have already covered the #HomeRibbon in our previous series if you wish to explore more learning visit the below link https://www.youtube.com/watch?v=23sX95u2wfM&list=PLCqnj_UiTQvPNZd8qDa23Jrm0AomlmTjy Also  in upcoming #Video series we will cover next functions which is in the #InsertRibbon tab so urge you all to stay up to date with #DiscoverTalentPresents  #DiscoverTalent143 A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them You may have the q

 Hi  In this tutorial will show you 5 easy Formulas which we use frequently for preparing Attendance Tracker ,  Employee Attendance Sheet ,  As you know how tracking P, AB, WO important not only in the corporate function but also in Non corporate work like School, Colleges etc.  I would encourage you personally take look at the below video . Watch it and share you opinion  In this video we have covered employees having off on one specific day. In upcoming series will go bit in advance so urge you to subscribe us on YT channel Attendance_in_msExcel  , #MsExcel Hindi Tutorial  How do I create an attendance tracker in Excel?   How do you make an attendance tracker? How do I use employee attendance in Excel 2016? How do I calculate daily attendance in Excel? How do you create a leave schedule in Excel? We may called it in different way for attendance tracker but the ultimate goal here is to track the attendance Weekly , Daily , monthly so you are at the right track in this video you will b

 Hi  I m your host Vinod , In this tutorial will show you TOP-6 uses of Advanced Filter in  MsExcel watch this video till end .  You may have the queries like How do I use Advanced Filter in Excel? What are the criteria we can use in advanced filter in MS Excel? Why Advanced Filter in Excel not working? How do I filter multiple criteria in Excel? How do you filter a formula in Excel? advanced filter ms excel Check out the difference between normal filter ( Alt +D + F + F ) & Advance Filter . What is the demerits in #NormalFilter and how beneficial advanced filter in your daily routine work .  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 –  #Pinterest https://www.pinterest.com/pin/6591440 #Instagram: #DiscoverTalent143  #Tumblr: - https://discover-talent-presents.tumb... #Youtube - youtube.com/DiscoverTalent143 

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

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

 As we all know there is amazing feature call macro in excel. Which helps you to work efficiently and it removes the manual task for sure A macro is like a set of actions which we ideally record or type codes in the form so whenever required to perform those steps we can use or run multiple times.  A macro helps in automating or repeating tasks by recording or storing our input sequences like mouse strokes or keyboard presses. Once this input is stored, it makes up a macro which is open to any possible changes. We have Macro based videos coming soon on our channel But what if you NOVICE in Macro and still wanted to remove manual effort!! Can't you  work smart??  The ans is NO  It's not necessary to learn code specially if the inbuilt feature is available in Ms excel  So do you perform that task using Ms Excel In built function.  As we all know instead of reading videos create nice impact for understanding So recommend you to watch the below given video and subscribe our channe

 world is changing  rapidly and we need to go along with the flow by enhancing the skill sets this #ShortCut Keys will help you in your #Competitive exams #Govt as well as  #Private job . This is a basic approach if you have gone through my previous video which is lesson 1 you will be more than happy to continue with this series. as i told you earlier #MsExcel is too vast i think i need to prepare other #Lession3 video which will cover almost all shortcut keys which will help you to enhance your #Skill sets so what are you waiting for ? urge you to please check out the videos which is available on the #DiscoverTalent143 and watch entire video series which will help you to grow in your career. learning is never ending . if you not able to understand any short cut keys in the #Video then please comment in the below section i am happy to help you out with demo as well. main goal our #DiscoverTalentPresents channel is #ToGrowTogether  as we know this is really easy but not sure where to st

 in #MsExcel #ShortCut plays a very important role . Especially the people who work upon the dash boards , daily reporting , #MIS work . We got amazing response on our #DiscoverTalent143 #Instagram handle . Requesting for the #MicrosoftExcel Shortkeys ! there are ample amount of short cut keys on the . #Google Etc. thing but what my audience needed i know better hence they showed trust upon me :) and without hesitation demanded for the #Begineer level #ShortCutKeys  Here is the video as requested i assure you if you implement this in your daily regime #Working from office or home will help you to stay smartly among the all coworkers so what are you waiting for  Watch the Full video and dont miss the ending ! :) amazing fun and yes you can also find the Discover Talent now on #Google as well Just type - #DiscoverTalentPresents on the Google and be found. We are also available on the -  #Pinterest https://www.pinterest.com/pin/659144095455107390/ #Instagram : #DiscoverTalent143 #Tumblr