• should be able to setup font size, style, alignment, filter, format, etc.,
• should be able to do basic setup like inserts picture, shapes, tables, header, footer, charts, etc.,
• should be able to do page formatting and page setup.
• should be able to write conditional expressions ( using if ).
• ability to use lookup and reference functions ( v lookup , h lookup , index)
• should be able to use v lookup to consolidate data from multiple sheets
• ability to use templates for standardization of worksheets.
• should be able to format charts, use 3d graphs, bar and line chart together.
• skill in modifying data in excel / chart so would automatically get updated in chart.
• should know pivot table creation, function, calculation, graph and formatting ( removing old data , grand total, sun -total etc.)
• should be able to communicate good verbal and written in english skills.
• ability to work independently and as part of a team and support to seniors.
• transfers information from paper formats into computer files using keyboards, or optical scanners.
• performs high-volume data entry using word processing, ms office, spreadsheet, database, or other company software.
• reviews data for errors, missing pages, or missing information and resolves any discrepancies.