Advanced Excel Workshop Content
Date: May 11th & 12th 2019
Timing: 9:30 AM - 5:30 PM

  • Excel 2007 Quick Overview
  • Basic Formula
  • Fill Series
  • Absolute Referencing
  • Define Name
  • Date Functions
  • Data Formatting
  • Text Functions

  • Condition Formatting
  • Data Sorting & Filter
  • Data Validation
  • Vlookup & Hlookup
  • Pivot Table
  • If & Nested If
  • Sumif & Countif
  • Charts

  • Advance Filter
  • Advance Sorting
  • Group & Outline
  • Consolidation
  • Subtotal
  • Custom List
  • Link & Hyperlink
  • Sharing & Protection

Training Benefits
  • Complete Practice based training with 30+ Practice Files
  • Excel eManual, ExcelProdigy's Practice Kit, Certificate, & Extensive Knowledge @ Excel

Trainer Profile
Mr. Muthu Kumaran C, 6+ Years of Experience in MS Office Corporate Training. Real time Experience in creating Excel Based Templates for various IT Companies. He is a well known Microsoft Certified Trainer and preferred by various corporate companies for his extensive knowledge in MS Excel & MS Office Training Programs.

Venue
Excel Prodigy Training & Consultancy Pvt. Ltd.

No. 109, Chowdri Nagar Main Road,
Valasaravakkam, 
Chennai - 600087