Header Ads

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
Business Analyst Excel Training Course Business Analyst Excel Training Course Reviewed by Barakar John on 1:05 AM Rating: 5
Powered by Blogger.