Microsoft Office Button Microsoft Office Button is located on the top left corner of the window.It is a new user interface feature that replaced the traditional “File” menu. You can also see this button in Outlook while creating a new message, task, contact, etc. See the image: When you click the button it offers a…
Read more
What is Microsoft Word Microsoft Word is word processing software. It is developed by Microsoft and is part of Microsoft Office Suite. It enables you to create, edit and save professional documents like letters and reports. Brief History: Microsoft word was released in 1983 as Multi-Tool Word. Its first version was based on the framework…
Read more
MS Word Tutorial MS Word tutorial provides basic and advanced concepts of Word. Our Word tutorial is designed for beginners and professionals. Microsoft Word is a computer application program written by Microsoft. It is mainly used to design text for presentation. Our MS Word tutorial includes all topics of MS Word such as save the…
Read more
HR Interview Questions | Common Interview Questions A list of frequently asked HR interview questions or Common interview questions or Job interview questions and answers are given below. 1) Tell me about yourself? This is the most famous question for an interviewer and also most difficult to answer this question for the candidate. This question…
Read more
MS Excel Interview Questions There are given top frequently asked MS Excel interview questions and answers that has been asked in many companies. Let’s see the list of top Excel interview questions. 1) What is Microsoft Excel? Microsoft Excel is an electronic worksheet or spreadsheet application which is used for organizing, storing, and manipulating and…
Read more
Computer Keyboard Shortcut Keys In modern times, there is no confusion in saying that computers have become a very useful part of daily life. If you use the computer frequently, you must have knowledge about the computer shortcut keys. Computer shortcut keys provide an easier way of navigating and performing commands in computer software. The…
Read more
How to Merge cells in Microsoft Excel? There are different methods we can merge cells in Excel. One of the most used methods is utilizing the Merge & Center option in the Home tab. The issue with using Merge & Center is that it can combine the cells, but not the text within these cells.…
Read more
How to create a drop-down list in Excel? A drop-down list is an outstanding way to give the client an option to choose from a pre-defined list. It very well may be utilized while getting a client to fill a structure or while making an intuitive excel dashboard. Drop-down lists are very regular on social…
Read more
How to Find and Remove Duplicates in Microsoft Excel? Finding Duplicates 1. For finding the duplicates, we will be utilizing the conditional formatting function. In this example, we need to discover if any name has been frequently. So first, we will choose the Name column. 2. Press on the conditional formatting option accessible at the…
Read more
Excel ISNA Function ISNA function helps to get rid of #N/A code error Using ISNA function we can tell Excel to leave the cell blank or to display any desired text like “not found” instead of displaying #N/A code error. See how the function is used in the example: The function is =if(isna(vlookup(E4,list1,2,false)),“”,vlookup(E4,list1,2,false)) =if(isna(vlookup(E4,list1,2,false)),””,vlookup(E4,list1,2,false))<br />…
Read more