Worksheet, Rows, Columns and Cells in Excel

A worksheet in excel is formed from Rows and Columns. Intersection of a Row and column in an excel worksheet could be a rectangle known as a Cell. Cells store a worth, a formula, or text an excel worksheet contains very sizable amount of cells. A cell could be a smallest building block of an … Read more

What is Vlookup?

Vlookup (short for ‘vertical’ lookup) is a built-in Excel function that is designed to work with data that is planned into columns. For a described value, the function discoveries (or ‘looks up’) the value in one column of data, and returns the consistent value from another column. Vlookup Syntax & Rules This page delivers details … Read more

Vlookup Exact Match

In this tutorial page we tend to show the way to use the excel Vlookup function once you want a precise match to the lookup price. Excel Vlookup function is used to ‘look up’ the number of pay owed to every member of a sales team throughout the previous week. As shown below, the worker … Read more

Vlookup Example with Closest Match

This page shows the way to use the excel Vlookup function once the [range_lookup] argument is about to TRUE (or is omitted). When the [range_lookup] is about to TRUE, this tells the Vlookup function that, if a precise match to the lookup_value isn’t found, then the nearest match below the lookup_value ought to be returned … Read more

Title Bar, Help Button, Zoom Control and View Buttons in Excel

Title Bar The title bar is a bar located at the topmost of a window or a dialog box that shows the name of the window or software program being used. For example, in the image below, the title bar shows the name of the program “Excel-Tutorials – Microsoft Excel” Help Button It present on upper right corner of the excel … Read more

Method of Subtraction in Excel

It is similar to addition just change the plus “+” sign with minus sign “-“. Select the cell where you want the show the result as cell D7 in this example. Then type = sign in the cell, now select first cell D4 then type “-” sign then select second cell D5. Now pressing the … Read more

How to use spell check in Excel

Choose the data then click on the review tab it will show spelling command in the left corner of the ribbon. Left click on it or press F7. If there is some spelling mistake in the data, the spell check will recommend corrections in the spelling dialogue box. See the picture:  

What is Sigma Button?

Sigma is a Greek letter that appears just like the Latin letter M on its side! That, ∑ In mathematics and statistics sigma, ∑, means that sum of, to add along. The sigma operate in excel, therefore, is add (values) How to Use sigma Button to do addition in excel Select the cell to show … Read more

Use Sigma Button to calculate average in Excel

Select the cell to show the result. In the Home tab click on the small arrow next to the Sigma button & press left button on mouse on the Average option. You will see the image shown below. While pressing the Enter key you will get the result  

How to select data in Excel

There are varied choices to select data. The foremost common method is a left click on the cell then dragging the mouse over the data you wish to select. Begin from the upper-left cell of the data, as cell A1 within the image given below: