Category Archives: Microsoft Office

Create a Hyperlink to a Location in the Current Document Microsoft Word

Create a Hyperlink to a Location in the Current Document Microsoft Word In this tutorial we will learn how to Create a Hyperlink to a Location in the Current Document Microsoft Word. To go to a specific paragraph, heading or location on a document by clicking on a hyperlink in word document is very useful, it

How to Edit Excel File with Multiple Users

How to Edit Excel File with Multiple Users In this post we will learn How to Edit Excel File with Multiple Users.For this we have to save the Excel file on shared location(network drive) where several people can edit the contents simultaneously.As the owner of the shared workbook, you can manage it by removing users from the

How To Launch a Program from PowerPoint?

How To Launch a Program from PowerPoint? In this post we will learn How To Launch a Program from PowerPoint?.By this way we can launch a program direct from the slide. 1. Launch PowerPoint, create new PowerPoint document or edit the already created one. 2. To be able to open a program from PowerPoint.The object can be

IF Function In Microsoft Excel

IF Function In Microsoft Excel In this post we will discuss or learn how to use IF Function In Microsoft Excel.The “IF” function is a simple and powerful one and helps automate decision making in your spreadsheet. The “IF” function checks if the specified condition is true or false. Syntax: IF(logical_test, [value_if_true], [value_if_false]) Logical_test: [Required] Any value

Microsoft Power Query for Excel

Microsoft Power Query for Excel In this post we will learn about Microsoft Power Query for Excel.Microsoft Power Query for Excel is an Excel add-in that enhances the self-service Business Intelligence experience in Excel by simplifying data discovery and access.The add-in can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=39379.Here we will use Power Query for data modelling and structuring the data

How To Compare Two Word Document

How To Compare Two Word Document In this tutorial i will teach you How To Compare Two Word Document.Microsoft Word have a built in functionality for this.You just have to both the documents which you want to compare. 1. Open Microsoft Word. 2. Click the Review tab and, from the Compare group, choose Compare > Compare.