Posts

Showing posts with the label Microsoft excel

Discover Talent Presents |create Sparklines Chart,Slicer and Timeline

Image
 In this video #InsertRibbonTab series we will cover How to visualize a mini chart A #sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use spark lines to show trends in a  series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. #Slicer and #Timelines ( Filter option in ms excel will help you to filter large sheet ms excel file in one go )Please note watch video till end to understand the #MsExcelTipsandTricks #ExcelHacks #LearnExcel  This will help you to not only use the insertion function like #clipart #logo #button #image #graphics #photo but also it helps you to #datavisulization 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. #WinChart , #ColumnChart #WinAndLossChart  #Filters  We are going to issue

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

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 

Discover Talent Presents | How do I use Advanced Filter in Excel?

Image
 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 

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