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.