Advance Excel (Basics + Advance)

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

Course Outcome:
*