Advance Excel Training in Gurgaon

    The spreadsheet designing within MS Excel is an art that will not be handy until you have gone through a dedicated training program. Quick access of procedure sums, setting maximum & minimum ranges, chart preparation. The customized training on Advance Excel, VBA and MIS is designed in such a way that the people from the relevant field can have insight about the tools and techniques to develop a customizable MIS system.

since Advanced Excel classes in Gurgaon are conducted on weekends it become more and more convinient for working persons to join this course. Industry experienced corporate trainer takes up classes in small group to teach various advanced functions of advanced excel techniques, small size batch gives individual attention to each participant. during MS Excel Training

    Day 1: Introduction
  • Different File extensions
  • All Keyboard shortcuts
  • Data types and properties
  • Create, delete and update new templates
  • Day 2: Basics of Advanced Excel additional Formatting
  • Define Name
  • Paste special
  • Conditional formatting
  • Basic functions
    Day 3: Advanced formulas and linking
  • Advanced formulas like Database, time, date, number, mathematical logicalCreating links
  • Errors and error types
  • Day 4: Sorting & Filtering
  • Multilevel sorting
  • Custom sorting
  • Filtering
    Day 5: Goal Seek, Scenarios, Grouping and Subtotals
  • Creating, using, and ,editing scenarios
  • Concept of Goal seek and using it
  • Grouping large data by different criteria
  • Adding subtotals to grouped data

Office Address

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Branch Office

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Call Now

9968523574, 8588809802,
0124-4077100

Email us

Email Us at

website

Office Address

M-48, OLD DLF Colony, Sec-14, Gurgaon, Haryana

Call Now

9968523574, 8588809802,
0124-4077100

Email us

Email Us at

website