Apsis Technologies MIS Executive and Analyst Interview Questions, Process, and Tips

Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• Vlookup stands for 'Vertical Lookup'.

• It is commonly used in Excel to search for a value in the leftmost column of a table and return a value in the same row from a specified column.

• The syntax for Vlookup is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

• Example: =VLOOKUP(A2, B2:D...read more

I primarily use Salesforce and Microsoft Excel for analyzing and managing primary sales data.

• Salesforce for tracking customer interactions and sales data

• Microsoft Excel for organizing and analyzing sales data

Vlookup searches for a value in the first column of a table and returns a value in the same row from a specified column. Xlookup is a more powerful and flexible version of Vlookup.

• Vlookup searches vertically in a table for a value and returns a corresponding value from a specified column.

• Xlookup can search both vertically and horizontally in a table, and can return values from any column or row.

• Vlookup requires the loo...read more

I use Salesforce CRM tool for tracking secondary sales.

• Salesforce CRM is used to record and track secondary sales data

• It helps in analyzing sales trends, forecasting, and performance evaluation

• Customized reports and dashboards can be created for better insights

• Integration with other tools like ERP systems for seamless data flow

I am proficient in Excel and can rate myself 8 out of 10.

• I am skilled in using formulas and functions in Excel.

• I have experience in creating pivot tables and charts.

• I am proficient in data analysis and reporting using Excel.

• I have used VLOOKUP, HLOOKUP, and other advanced functions in Excel.

• I have completed Excel certification courses.