Posts

Showing posts with the label ms excel basics

Microsoft Visio In Excel

Image
 Discover Talent Presents - How to use Microsoft Visio | How to Create Flow chart in Microsoft Visio #MicrosoftVisio is the most creative tool I can say this will help you to #DataVisualization and #FlowChart creation purpose now it’s completely depend upon your usage how you needed as per your requirement in the series we have the #BasicsVisio tutorial if you need more help on this you can directly pings us on Facebook, Instagram we are happy to help you .  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

Resolve NA Error in Ms Excel

Image
 in this series are covering the topic called #NA Error , Technically, this is not an error value but a special value that you can manually enter into a cell to indicate that you don’t yet have a necessary value ( NA – No Value available )  .  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 resolving the issues #Learning #Certificate #ErrorHandlingTechnique these error handling advancement makes you more proficient in excel while you use any #Formula

Discover Talent Presents - Copy Format Painter in Excel | Format Painter in Excel | Excel Formatting

Image
Discover Talent Presents - Copy Format Painter in Excel  Format Painter in Excel | Excel Formatting, in every small or large scale industry #MsExcel used while performing datasheet or #Analytics #FormatPainter best option to replicate the formatting across other #worksheet or #workbook , we replicate the formatting one column or row wise its difficult to apply as its  #Manualwork here in excel now you at one single #MouseClick easily #CopyFormatPainter do you already know this trick ? if yes watch one more time for rehearsal if no then urge you to watch and apply in your #DailyRotine work period happy learning we use to share such excel tips , tricks , excel hacks and much more 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. which creates value for your career. We share excel expertise on this channel in this we are covering #QuickExcelTips #ExcelHacks #Shorts #Tricks

What is the Difference between flash fill vs Text to Column

Image
 World is demanding and companies also looking for the smart employees to work with their organization #FlashFill and #TextToColumn is the best option in #MsExcel where you can fill the necessary data in sequential form now what does that mean ? so to understand this you need to watch this video very simpler way we have portray the steps. This will help you to reduce your #ManualWork and it will increase your #WorkEfficiency.  Flash Fill automatically fills your data when it senses a pattern and Text to column You can take the text in one or more cells, and split it into multiple cells using the Convert Text to Columns Wizard. As you know you can split the data with the help of #Texttocolumn and #Flashfill however you might be curious that how can you join the data hence we shared the bonus tip here “Concatenation” function in which you can merge to text cells in one . You might have the queries like  Flash Fill in Excel 2019, 2016 and 2013 with examples Flash fill short cut How to use