Business Analyst Excel Training Course

Duration:12 Hours

Module 1:Introduction to Excel

• Overview
• Home Tab
• Conditional Formatting
• Paste special
• Go to special

Module 2: Data Tab

• Overview
• Simple sort and filter
• Advanced Sort and Filter
• What if Analysis
• Data Validation
• Data Validation

Module 3: Functions

• Overview
• Text Functions like CONCATENATE, TRIM, SEARCH, SUBSTITUTE
• Logical Functions like IF, AND, OR
• Lookup Functions like VLOOKUP, HLOOKUP, REFERENCE, INDEX,MATCH
• Advanced Functions like DCOUNT, DSUM

Module 4: Dynamic charts & Pivot Tables

• Overview
• Create charts
• Use Dynamic charts
• Connecting to Form Controls
• Simple Pivot Tables
• Functions in Pivot Tables
• Integrating Charts with Tables