
Advance Excel (Basic + Advance)
Course Code: C073
Duration: 6 Weeks
Offline Course Daily: 2 Hrs.
Online Course Daily: 1 Hrs.
Eligibility: Fresher
Course Description:
Complete Practical Oriented Course With Project
Course Contents:
• Introduction to Excel Object Model
• Working with Nested if Conditions
• Data Validations, Customization of Series List
• Various Types of Functions: Mathematical, Statistical
• Logical and Text Functions
• What if Analysis, Goal Seek, Trends and Scenarios
• Pivot Tables, Understanding of Name Ranges
• Recording and Running Macros
• Conditional Formatting
• Charts & Sparkline