CERTIFICATE IN ADVANCED EXCEL

Duration: 3 MONTHS

Course Syllabus

  • 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
  • Sparklines
  • Graphics Tricks and Techniques
  • Turning Data into Decisions
  • Working with External Data
  • Advanced Uses of PivotTables
  • PowerPivot
  • Reporting with PowerPivot
  • Course Plenary
  • Course Plenary
  • Revise what you have learned.

Read More

Eligibility

.


Back to top