Posts

Common errors encountered in MS-Excel and how can these be rectified

Not Applicable Error ( #N/A ): Reason: This error occurs when a function cannot find what it has been asked to look into the Source Data Table or Table Array. This means that no details exist into the data in reference to that selected lookup value. For Instance :     Assume, we have applied Vlookup function in Table2 to find the Cost (Per Day) from Table1 in reference to lookup value as Resource Names, however this error occurred at the last cell because there are no details, for the resource 'A'. Solution:  Make sure that the Source Data Table or Table Array is complete before its use into the function. If still (with the complete table), no lookup value exists in the table then either remain this error as it is or override this error into text as 'Not Applicable' move forward with the next calculation. For Instance :      Assume , earlier we were working with the incomplete data in following Table1 and then after getting the complete data in which d...
Post a Comment
Read more

Pivot Table

Image
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.               ...
1 comment
Location: Delhi, India
Read more

Xlookup function

Image
  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...
Post a Comment
Location: Delhi, India
Read more