SKILLMAP TRAINING & SERVICES PVT LTD

JOB SUMMARY

We as a company is looking for An Advanced Excel Trainer who can associate with us on a contract basis.

*The Trainer must impart his knowledge in the following domain of Excel.

Place : Kochi , Kerala

Job Type : Contract

Salary : ₹2,000.00 to ₹5,000.00 /day

Functions/ Formulas- Advanced

1. 1. Fill Across sheet tool2. Subtotal Functions3. Automating using Macros & VBA

   4. Pivot Tables, Pivot chart and Pivot reporting

   5. Keyboard Shortcuts

   6. Data Tables, Simulation and solver

   7. Integrating Excel with Power point

   8. H lookup and V lookup

   9. Using Name manager

   10. Trace Precedents and Trace dependents

   11. Formatting tables and ranges

   12. Advanced Charts

   13. Delimiter

   14. Index + Match

   15. Sampling Functions

   16. Mail merge (excel to word)

   17. Advanced IF Functions

BASICS :

• DESIGNING A SPREADSHEET
• CONDITIONAL FORMATTING
• DATA SORTING & FILTERING
• DATA VALIDATION & DATA CONSOLIDATION
• PIVOT TABLES & TYPES OF PIVOT REPORTS
• GENERATING GRAPHS
• FORMULAS & FUNCTIONS
• USING LOOKUP AND REFERENCE FUNCTIONS
• GENERATING GRAPHS
• FORMULAS & FUNCTIONS
• USING LOOKUP AND REFERENCE FUNCTIONS
• REMOVING DUPLICATES
• RECORDING AND PLAYING A MACRO
• PROTECTING WORKSHEET & WORKBOOK
• PAGE LAYOUT & PRINTING