Do want to add a hyperlink to another sheet in excel? Well, there are several ways in which you can create a hyperlink in excel. In today's discussion, we will look into how to create a hyperlink in excel that will navigate you to another sheet of the same excel file. Using Link Option Using Link Button in Header Hyperlink to Defined Names Hyperlink Using Formula Modify the … [Read more...]

Excel allows you to add and remove watermark from the spreadsheet. Watermark can either be a text or a picture that you add to the background of your document that appears behind the main text of your document. However, the watermark does not overshadow the main text of the document. This is because the watermark is usually applied in a lighter shade so that it doesn’t create any problem in … [Read more...]

Relative and absolute cell reference are the two ways to refer to a cell in excel. Both of them function differently when they are copied to the other cells of the spreadsheet. In this context, we will discuss both relative and absolute references. We will learn, how to use them with the help of examples. Relative Cell Reference The relative cell reference is the one that changes as you copy … [Read more...]

A scroll lock is a function that determines the action of arrow keys present on your keyboard when you are working in Excel. You might have experienced that sometimes pressing the arrow keys moves the entire excel sheet instead of moving the cursor to the next cell. You can easily enable and disable the scroll lock feature. But before moving to the steps let us first know more about the scroll … [Read more...]

Have you ever used the Index and Match formulas of Excel? Well, both of these formulas are used to perform lookups. They can even be used together which will let you perform the two-way lookup. INDEX function The INDEX function returns a value or a reference to a value that occurs at a specific position in the provided reference range. The INDEX function has two forms: Array Form The … [Read more...]

The bar graph in Excel is one of the easiest ways to present data graphically. It not only makes your data presentable but is also helpful in engaging your audience. Bar graph presents the data with rectangular horizontal bars. The length of the bar depends on the data values. In this context we will be discussing the steps to make: Simple Bar Graph Bar Graph with 2 Variables Bar … [Read more...]

Are you trying to count duplicate values in Excel? Sometimes we compile multiple worksheets into in single large excel sheet. This integrated single worksheet may consist of duplicate values. You may require to count the duplicate values in an excel sheet in order to get a clear view of the large data. The Excel formula COUNTIF() will play a most important role in counting the duplicate in the … [Read more...]

Excel allows you to wrap text in a cell so that it becomes presentable and easy to read. If the length of the string in your cell is long enough to fit into the cell, it overlaps the content of another cell while writing and is partially visible when we move on from that cell. The wrap text option of Excel allows the string of a cell to appear in multiple lines within the cell. While wrapping … [Read more...]

Excel allows you to round off numbers in case you don’t want to see decimal point values in your Excel cell. With more decimal places in a cell, you could see the ##### symbol which makes the data unpresentable. Even sometimes you don’t require value accurate up to the microscopic level. But, the round-off numbers in cells are easy to read and are more presentable. Here, we will be learning … [Read more...]

Bell curve is a kind of graph that displays the normal distribution of a variable. It is mostly used to analyze the performance of employees or students etc. Bell curve helps you in identifying the poor, average and good performers in the team. The individuals whose performance is marked at the left side of the bell curve can be identified as poor performers and the individuals whose … [Read more...]