Posts

Showing posts with the label Ms excel tips and tricks

REPT Function in Ms Excel

Image
 REPT Function in Excel | How to Use REPT Function | What is the Use REPT In Excel  the #REPT Function is categorized under #Logicalfunctions. The formula will repeat characters a given number of times.  This will help you to #Visualize the #DataSets in Excel especially if you are financial institution or large-scale industry where you want to do #datavisualization or as a #DataSecracy you need hide the exact value of #dollar #Rupee or anything you can do it just click on the play button watch this video till end. You will be fill grateful today after watching this video and learn something new for sure. What exactly this #REPTFunction does ? we have covered this in the video still some glimpse in the form of text is here do refer and sharr your feedback Summary. It basically the Repeat text as specified. The repeated text. You can type this formula like this  =REPT (text, number_times) text - The text to repeat. number_times - The number of times to repeat text. The REPT function repe

COVID-19 Recommended Chart and 3D Map

Image
 In this video series we will cover #RecommendedChart #COVID19 #InsertRibbon . this will help you to not only use the insertion function like #clipart #logo #button #image #graphics #photo but alos help you to #datavisualization how to do that . watch this video till end its an free ware asset for all of you and it’s a great platform to enhance your skill So keep watching this video till end . and share your love with us by clicking on the #Like button. C19 Data analysis you can you on your own  https://www.youtube.com/watch?v=23sX95u2wfM&list=PLCqnj_UiTQvPNZd8qDa23Jrm0AomlmTjy Also in upcoming #Video series we will cover #COVID19 data visualization 3D maps with cases and #death data will get it from #WorldHealthOrganization #WHO #COVID19_Deaths #Covid19_Cases with #charts and #3DMap so don’t miss the ending of this video also the beginning of that video. Would encourage you to subscribe our channel to learn and earn the #FreeCertificate in ms excel How ? watch our video series 1

MsExcel Insert Ribbon Tab

Image
 In this video series we will cover illustration MyAddin #InsertRibbon .  this will help you to effectively use the insertion function where you need to insert #clipart #logo #button #image #graphics #photo if any. So keep watching this video till end . and share your love with us by clicking on the #Like button . https://www.youtube.com/watch?v=23sX95u2wfM&list=PLCqnj_UiTQvPNZd8qDa23Jrm0AomlmTjy Also in upcoming #Video series we will cover #COVID19 data visualization with #charts and #3DMap so don’t miss the ending of this video also the beginning of that video. Would encourage you to subscribe our channel to learn and earn the #FreeCertificate in ms excel How ? watch our video series 1 where we have explained our #HowToBecomeCertified in #Excel. Last video series we Had covered the  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 a

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

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 –

Discover Talent Presents | How do you make an attendance tracker

Image
 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

Without Macro Record excel Cells

Image
 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

Discover Talent Presents | Top40 Ms Excel Short Cut keys lesson 2

Image
 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

Discover Talent Presents | Top 30 Short Cut Keys in Ms Excel Lesson 1

Image
 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

Discover Talent Presents | combine two text with The help of MsExcel Function

Image
In daily work routine especially when we worked as a data analyst and we use to pull raw dump if we have more than 10000 column or rown to work upon this. Video will help you.  in #MsExcel how to combine two context with the help of #MsExcelFunction ease. ! watch this video from the beginning to avoid more confusion . share your valuable feedback in below comment section . This video will help you in your #MIS , #Reporting , #DailyDashboard and #Educational purpose. .  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 :- https://discover-talent-presents.tumblr.com/ #Youtube - youtube.com/c/DiscoverTalent143 #Facebook :- Facebook.com/DiscoverTalent143 #LinkedIN :-  Check out Discover Talent’s profile on LinkedIn https://www.linkedin.com/in/discovertalent143