Posts

Showing posts with the label Ms excel advance

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

LEN Function in Ms Excel

Image
 LEN function in Excel | What is LEN Function? | How to Use LEN function? LEN function is the most popular function across MsExcel how , where and when we used so writing some context which will give you brief about the #LEN Function . When we create address field , Name field or Password field in excel Forms that time we need to calculate the total text were used by the user ( stakeholder ) if any . That time this #LENFunction #MsExcel will really helps you to identify the current characters or space were used by the input user #Shorts with specific function if you needed comment on below section of #DiscoverTalentPresents so we can create more tutorials on it which will help you to learn more or explore more about the excel . Thanks for watching this Shorts  We Discover Talent Presents is the Free online education system which offers 100% Free certification guide, Free Trainings Reference, Interview QnA , Ms Office Trainings.  As Education is our Right so we offer this service free o

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

Consolidate data in multiple worksheets – Excel

Image
 Learn #MsExcel with us if you are unsure how to #Consolidate the XLS file then watch #MsExcelTutorial free of cost. learning is always necessary  If you have the queries like below then you are at the right place watch Hindi Tutorial for ms excel and be pro in your daily regime  How do I create a consolidated sheet in Excel? How do you delete consolidate in Excel? Where is consolidate in Excel? Consolidate data in multiple worksheets – Excel In this tutorial we have shown 3 tabs where you can consolidate file in it however if you want you can consolidate the sheets as well whichever location they are available to make you understand we create this basic level tutorial  . Thanks for watching this video and if you are new on this YouTube then please subscribe our channel  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 –

Ms excel Questions by discover Talent presents

Image
Which keyboard shortcut opens the Go To dialog box? a. Ctrl + B b. Ctrl + Shift + B c. F2 d. F5 @@@@@@@@@@@@@@@@@@@ To keep specific rows and columns from scrolling off the screen you first must  position the cell pointer a. to the right of the column you want to remain on the screen b. below the row you want to remain on the screen c. on the row you want to remain on the screen d. both below and right of the row and column you want to remain on the screen @@@@@@@@@@@@@@@@@@@@@ When you create two or four separate windows containing part of the  spreadsheet that can be viewed, you have created a. sections b. panes c. views d. subsheets @@@@@@@@@@@@@@@@@@@@@ The accounting style shows negative numbers in a. Bold b. Brackets c. Paranthesis d. Quotes @@@@@@@@@@@@@@@@@@11 Which of the following component displays the contents of active cell? a. Name box b. Formula bar c. Menu bar d. Status bar @@@@@@@@@@@@@@@@@@@ How many sheets are there in Excel Workbook by default? a. 2 b. 3 c. 4 d. 5 @

Ms Excel Frequently asked Question and Answer

Image
What function displays row data in a column or column data in a row ? Index Transpose Rows Hyperlinks Which of these will not select all the cells in a document? Pressing Ctrl + A on the keyboard All of above Using the Edit + Select All menu Clicking three times with the right mouse button in the spreadsheet