MS-Excel Insights

This blog is intended to provide you the knowledge about most important and widely used feature known as Pivot Table which is a table of statistics that summarizes the data of a more extensive table. This summary might include sums, averages, or other statistics, which the Pivot Table groups together in a meaningful way that can be used for analysis and presentation. To access PivotTable, following steps are available:   Go to Insert ribbon and Choose Pivot Table option. Press keyboard shortcut key Alt + N + V.   Arguments for creating PivotTable   Choose the data that you want to analyze: It indicates to select the source data table/range which is considered to create the Pivot Table.   Choose where you want the PivotTable report to be placed:    It indicates to select the cell location where the PivotTable is pasted.               ...

  XLOOKUP function which is used to extract the cell value from any selected data source with reference to the selected lookup value. XLOOKUP works for the data either it is vertically or horizontally organized which means XLOOKUP has the functionally for both VLOOKUP & HLOOKUP function. Syntax There are 6 arguments used in XLOOKUP function out of which first 3 arguments are required and others are optional as follows. lookup_value :   Cell that contain text or number which is selected to search the same from the selected lookup-array and extract the desired value from the selected return_array .    lookup-array : Range of cells from the source data that is selected to search the selected lookup_value. return_array Range of cells from the source data that is selected from which the corresponding value will be returned, based on the position of lookup_value in the lookup_array . [if_not_found] (optional) This argument allows th...

      1.         Ctrl + A: This is used to select all the cells in a worksheet.   2.         Ctrl + B: This is used to bold the value of selected cell or range of cells in a worksheet. 3.         Ctrl + C: This is used to copy the value of selected cell or range of cells in a worksheet. 4.         Ctrl + V: This is used to paste the copied cell value in cell or range of cells in a worksheet. 5.         Ctrl + F: This is used to find out the cell value in selected cell or range of cells in a worksheet. 6.         Ctrl + H:         This is used to override the existing cell value in selected cell or range of cells in a  worksheet. 7.         Ctrl + G:    ...