StudyBaba

Easy way to create a simple chart in Excel. The chart provides you the easy way to understand huge data, create a good comparison, and a relationship among different series. In the beginning, you can practice with simple data like write some names and put any value into the next column and create a graph.  In this article, we will learn about a simple graph, which covers the basic and important necessary points to create a simple graph.  In a graph, we must have at least two axis x and y. Let suppose we have data with student's marks of different subjects. We can create a simple chart which shows name wise mark wise comparison among the staff. See the image below to get a good understanding of graphs. Image: 1 - Simple Graph Steps - How to make it easily.. Follow the steps. First select the data on which you want to apply the graph. Second Go To : Insert or Use Short cut key : Alt + N Third: Select the graph as you required. Insert Bar or Pie c

Know Duplicate or Repeated Values in Excel. Normally we work on excel reports with huge data and it is difficult to pick the duplicate values without any formula or function. Excel provides us a good feature to find out duplicate or repeated values during work within the spreadsheet. To get an error-free report it is important to sort the duplicate values. During working with excel sheets we always need to identify duplicate or repeated values in data. In Excel, We have two options to get duplicate values. Two different options are available to find duplicate values. Follow the options given below to make a good understanding. Duplicate function is very important to use in excel, lots of use in MS Excel. If you are a MIS reporting professional, you must understand this method. Method -1 : Select the data Go To Conditional Formatting. Go To Highlighting Cell Rules . Select Option Duplicate Values . Dialogue Box will open From drop-down Select Duplicate . You can choo

Set a password for your workbook and worksheets. There is two types of security in excel, you can secure workbooks as well as worksheets. First - Secure worksheets Excel. Open an Excel File - Go to Review Click Protect Sheet One duologue box will be open. Put your password as you like. Click Ok . Retype your password Click Ok . Save your worksheet Now your worksheet is protected. No one can change your data. If anyone wants to make changes, they must enter the password. Close and reopen, try to make changes, put the password before use. If you want to edit data Go To : Review Click Unprotect Sheet Enter the password Click OK *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*- Second: Secure WorkBook in Excel. If we want to protect our whole workbook with a password, then follow the simple steps. Open a new Excel File . Go To Save As One Duologue box will be open. P