Posts

Showing posts with the label Ms excel training

Add PowerPoint Presentation in Ms Excel

Image
Add PowerPoint Presentation in Ms Excel Supposing you have a sheet with some data, for vivid and interesting look, you want to insert a colorful background behind cell and worksheet We used to share videos for those too so stay with us and subscribe so you won’t miss any updates or new videos  We share excel expertise on this channel in this we are covering Quick Excel Tips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on google type discover talent presents and get the free if you want new videos on the same topic do comment below, we have created MsExcel videos for you. Ms excels tips if you have any confusion in understanding or need the file to follow along the steps comment your email id in below section will share so you can follow along the step’s applicable comments on YouTube only. #DiscoverTalentPresents our motto is to #Upskill everyone who has the internet they will learn free of cost no single penny need to pay any other institution will provide you certific

Add background image in Excel Worksheet

Image
Add background image in Excel Worksheet - Discover Talent Presents #Excel #Shorts #BackgroundImage Supposing you have a sheet with some data, for vivid and interesting look, you want to insert a colorful background behind cell and worksheet We used to share videos for those too so stay with us and subscribe so you won’t miss any updates or new videos  We share excel expertise on this channel in this we are covering Quick Excel Tips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on google type discover talent presents and get the free if you want new videos on the same topic do comment below, we have created MsExcel videos for you. Ms excels tips if you have any confusion in understanding or need the file to follow along the steps comment your email id in below section will share so you can follow along the step’s applicable comments on YouTube only. #DiscoverTalentPresents our motto is to #Upskill everyone who has the internet they will learn free of cost no single penny

Pareto Chart In Ms Excel - Discover Talent Presents

 Pareto Chart for business analysis - #ParetoChart states that 80% / 20% ratio which understand the business problems, The Pareto chart analysis is a #statistical graphical technique used to map and rank business process problems #MsExcel checkout the more learning for #Analytics and #BusinessSolution with us , we also offer certifications with free of cost and career guidance #SixSigma we are launching soon hence urge you to subscribe our channel and get Free of cost #YellowSixSigma Certificate . It uses the Pareto Principle (also known as the 80/20 rule) the idea that by doing 20% of the work you can generate 80% of the benefit of doing the whole job. Discover Talent Presents what we offer work on large worksheet effectively check out the video and share your comments in below section and don’t forget us to subscribe because your one subscribes or thumb in the form of like motivate us to share #Free content for you all so please support #FreeCertification program by us  With the help

Discover Talent Presents Export Excel Table in SharePoint

Image
 Discover Talent Presents Export Excel Table in SharePoint In this series we are covering Discover Talent Presents – Export Excel worksheet data in SharePoint #Excel #ExportData its very easy way to transfer data from one sheet to other  We used to share videos for those too so stay with us and subscribe so you won’t miss any updates or new videos  We share excel expertise on this channel in this we are covering Quick Excel Tips #ExcelHacks #Shorts #TricksinMsExcel you can search us (WWW) on google type discover talent presents and get the free if you want new videos on the same topic do comment below, we have created MsExcel videos for you. Ms excels tips if you have any confusion in understanding or need the file to follow along the steps comment your email id in below section will share so you can follow along the step’s applicable comments on YouTube only. #DiscoverTalentPresents our motto is to #Upskill everyone who has the internet they will learn free of cost no single penny nee

Correct VALUE Error in Excel

Image
 Discover Talent Presents | How to correct a VALUE error in the Excel function #Shorts  in this series are covering the topic called #VALUE_Error, this error is most often the result of specifying a mathematical operation with one or more cells that contain text...  If you don’t know what I meant about the context or through description don’t worry and watch the video if you still have issues in understanding then don’t hesitate comment on YouTube channel asking for the same. We are here to help you out the #VALUE!  It means the Wrong type of argument in a function or wrong type of operator These all functions or error handling method which right now showing in the video is just for that specific formula you may deep dive with the other formulas as well and relate or resolve the issue as per your problem statement , feel free to tag us on Instagram / Facebook  share us the workbook if by any chance you are stuck somewhere while resolving the issues #Learning #Certificate #ErrorHandling

Discover Talent Presents | Excel Error and Solution | Fix Excel Common Errors - Most Useful Function

Image
VALUE Error - Starts from 0:30 –  SUBSCRIBE in this series are covering the topic called #VALUE_Error, this error is most often the result of specifying a mathematical operation with one or more cells that contain text...  If you don’t know what I meant about the context or through description don’t worry and watch the video if you still have issues in understanding then don’t hesitate comment on YouTube channel asking for the same. We are here to help you out the #VALUE!  It means the Wrong type of argument in a function or wrong type of operator #DIV/0!  Error -- Starts from 1:33 –  Discover Talent Presents | How to correct a DIV/0 error in the Excel function #Shorts #DIV_Error Division By zero Everyone knows a #MsExcel few starting from basics and majority are learning #AdvanceFunction of excel now if we can we see the Error handling technique are in excel training's we have seen so in this series are covering #DIV_Error How to correct a DIV/0! error in the Excel function why th

Discover Talent Presents Create Data Entry Form In Excel

Image
Create Data Entry Form in Excel - discover talent presents  Welcome to our channel this #QuickAccessToolbar #DataEntry #Form in excel #Tips #HideText #MsExcel will help you to work more proactively and effectively in your daily regime Select the cells that contain sensitive data you want to hide. Right-click to choose “Format Cells” option from the drop-down menu. On the Number tab, choose the Custom category and enter three semicolons (;;;) without the parentheses into the Type box. #ShortcutKey to open format cell is CTRL + 1. Learn more with us and in #MsExcel lets take look and watch video till end and do also share your feedback proactively in below comment section – Discover Talent Presents 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.  If any issues occurred while playing video 🎥 don't worry visit our below video which creates value for your career. We shar

=SUM() or Alt + = Which is best?

 Everyone beginner to experience holder who uses the Ms excel they know how to calculate total in Ms excel. Which is good part part. However being known excel and in reality being more productive in our daily regime is more important So here is the Quick Tip from discover talent presents how quickly you could add the sun value for respective cells in Ms excel This video we have demonstrate that the fast work or more productive work applicable any laptop user then if you are windows user or MAC user.  As you know with the help of =Sum() function we could add the total But here with help of keyboard short cuts fraction of sec you will get the result Try this ExcelHack and share your feedback in below comment. 

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

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