Posts

Showing posts with the label Training excel

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

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

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