In this tutorial you will learn about protection in excel for worksheets and workbook. By the protection your worksheet be saved from the unauthorized access to your data. Which saved in worksheet. By protecting your workbook in excel you can save your workbook from the unauthorized access to your data. Excel provide security option forRead more »

In this tutorial you will learn how to use drawing objects in excel. By using drawing objects in excel you can enhance the design of worksheet in microsoft excel. It also can increase the readability of worksheet of excel workbook and provide convenience to the reader. Drawing objects are different shapes that are available inRead more »

In this tutorial you will learn how to do object linking and embedding through excel. By object linking you can link the data of microsoft excel with other application like microsoft word. You update data in microsoft excel and you need to update it in linked application like microsoft word so by embedding you doRead more »

In this tutorial you will learn how to use hyperlinks in excel. By using hyperlink you can insert the link by which you can go on other location. you can link the sheet with the text by using hyperlink in microsoft excel. You can link the web page with the text in excel by selectionRead more »

In this tutorial you will learn the use of data validation in excel. It is very useful and time saving in excel because the chance of error decrease. It also increase the convenience for the data entry because the chance of flaw be decrease. use data validation in excel example:- You have the record sheetRead more »

In this tutorial you will learn how to use data form in excel. Data form is the way by which you make the interface of excel worksheet convenient. You can use data form when you have large spread sheet and you need to scroll to see data in the worksheet of excel. By data formRead more »

In this tutorial you will learn how to use VLOOKUP function in excel. This is like as LOOKUP function and use for searching in microsoft excel work sheet. This function is slightly different from the the lookup function because it find value form first column of microsoft excel work sheet. Syntax of VLOOKUP function isRead more »

In this tutorial you will learn how to generate worksheet template in excel. Template makes the work easy and save the time. If you need a worksheet again and again so create a worksheet template to save the effort and time because you have not need to make excel worksheet from scratch. The worksheet templateRead more »

In this tutorial you will learn how you can use reference formulas with multiple excel work sheets. With reference formula you can use multiple values of multiple work sheets in excel. It is very useful for the calculation of data which is on different work sheet of one work book of excel. Reference formula isRead more »

In this tutorial you will learn how to use lookup function in excel. Lookup function is use to search data in work sheet of microsoft excel. It is very powerful feature of microsoft excel by which search of data is very easy in excel sheet. You can type it like as following. =LOOKUP(Value, Range ofRead more »

Next Page »