Certificate in Adv. Excel

Certificate in Adv. Excel

Duration : 6 Months

Eligibility : 10th

Fee Monthly : 1000 /-

Total Fee : 2800/-

Course Contain:

Efficiency and Risk

  • Templates
  • Increasing Efficiency and Reducing Risk
  • Data Validation

Advanced Techniques

  • Functions with Superpowers
  • Array Formulae
  • Tables
  • Advanced Range Names
  • What If Analysis
  • Problem Solving

Excel Interactivity

  • Form Controls
  • Visual Basic and Macros

Spreadsheet Impact

  • Conditional Formatting
  • Charts that Inspire
  • Sparkline’s
  • Graphics Tricks and Techniques

Turning Data into Decisions

  • Working with External Data
  • Advanced Uses of PivotTables
  • Power Pivot
  • Reporting with Power Pivot

Course Plenary

  • Course Plenary
  • Revise what you have learned.