VLOOKUP stands for Vertical Lookup. It is a function that makes Excel search for a certain value in a column (the so called table array), in order to return a value from a different column in the same row.

## How does VLOOKUP works in Excel?

VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP. The matched value from a table.

In Excel, a formula is an expression that operates on values in a range of cells or a cell. For example, =A1+A2+A3, which finds the sum of the range of values from cell A1 to cell A3.

## Why do we use pivot tables?

A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.

## What is the shortcut for PivotTable in Excel?

Select the data set and press Alt > N > V (this is a sequential shortcut so press Alt then N then V). A dialog box will appear with options to create a pivot table.

## What is required for a Pivot Table?

Necessary conditions Each column of the Pivot Table must have a title. The title should be written in a single row. In a column, all the items should be of the same data type (numbers, dates or strings). The data table should not contain any merged cells.

## What are the shortcut keys for Excel?

Microsoft Excel Shortcut KeysShortcutMenuShift+F11Shift F11Insert WorksheetShift+F12Shift F12File SaveCtrl+F3Ctrl F3Insert Names DefineCtrl+F4Ctrl F4File Close94 more rows