1.How to apply the Vlookup function on Excel database?
*In the Formula Bar, type =VLOOKUP().
*In the parentheses, enter your lookup value, followed by a comma. This can be an actual value, or a blank cell that will hold a value: (H2,
*Enter your table array or lookup table, the range of data you want to search, and a comma: (H2,B3:F25,
*Enter column index number. This is the column where you think the answers are, and it must be to the right of your lookup values: (H2,B3:F25,3,
*Enter the range lookup value, either TRUE or FALSE. TRUE finds partial matches, FALSE finds exact matches. Your finished formula looks something like this: =VLOOKUP(H2,B3:F25,3,FALSE)
2.How to apply the Hlookup function on Excel database? *lookup_value - The value to look up.
*table_array - The table from which to retrieve data.
*row_index - The row number from which to retrieve data.
*range_lookup - [optional] A Boolean to indicate exact match or approximate match. Default = TRUE = approximate match.
3.How to apply the Pivot on the given data?
*Click any single cell inside the data set.
*On the Insert tab, in the Tables group, click PivotTable. The following dialog box appears. Excel automatically selects the data for you. The default location for a new pivot table is New Worksheet.
4.How to create a Pivot charts on excel?
*Select a cell in your table.
*Select PivotTable Tools > Analyze > PivotChart .
*Select a chart.
5.How to insert multi-line charts in Excel?
*To create a combo chart, select the data you want displayed, then click the dialog launcher in the corner of the Charts group on the Insert tab to open the Insert Chart dialog box. Select combo from the All Charts tab. Select the chart type you want for each data series from the dropdown options.