0484-2535677 Palarivattom, Kochi, Kerala Mon - Sat 8.00 - 18.00. Sunday CLOSED

Advanced Excel Trainer

  • Location:
  • Salary:
    ₹2,000 - ₹5,000 / day
  • Job type:
    Contract
  • Posted:
    1 year ago
  • Category:
    Marketing
  • Deadline:
    May 2, 2020

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
This job has expired.