Posts

Showing posts with the label ms excel tutorial

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

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

How Correct Name Error Function in Excel

Image
 Discover Talent Presents | How to correct a NAME error in the Excel function #Shorts #NAME! #Formula in this series are covering the topic called #NAME Error This error value appears when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a text string in a formula. (When our spreadsheets are unable to find the excel name that time it occurs) .  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  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 res

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

Data Validation in Excel

Image
  Data Validation Whole Number | Decimal | Drop Down List | Date | Text Length in Microsoft Excel #DropDownList #DataValidation is an essential function in Ms excel which is most frequently used in excel specially when we create structed forms or any #ExcelTemplate when users interact with your created forms or template and as a publisher and creator you want he /she chose the required field as per the #Validation then this rules needs to set it up as per your requirement there nice amount of options like If incase it's working the above video then refer the below video #WholeNumber #Text #Decimal #Date #List #SelectList and much more few I have covered in this series if you wish to know more about other categories too feel free revert us will help you out now 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 t

Add Header and Footer for Ms excel

 In this video we have covered how to setup a page while taking a printout in #MsExcel and also covered the importance of #PageSetup and #ViewTab in #MicrosoftExcel  This video will help you before you taking a any printout to make sure how to select page setup ( #Protrait , #Landscape ) #PageMargin and why we use the #NarrowMargin while giving the printout .  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  What is Page Setup in Excel? How do you set page area in Excel? How do I set my printer page? Why is Page Setup greyed out in Excel? What is the use of view tab ? How to add header and footer in excel sheet? How to add header in excel sheet Our consistent #DiscoverTalent143 follower gave us the recommendation video who is the winner of #MrsFaceOfIndia2020 #PreetiThakuria watch her message at the end.  This function will help you to make your work smartly in your #DailyRegime #Office , #School #College