Learn Microsoft Excel : From Zero to Hero

Course Overview

• Course Title: Learn Microsoft Excel : From Zero to Hero
• Instructor: Ashish Pandit
• Target Audience:
  • Beginners to Microsoft Excel
  • Those looking to enhance data analysis skills
  • Individuals aiming to become proficient in Excel's advanced features
• Prerequisites:
  • A PC with any version of Excel installed

Curriculum Highlights

• Key Topics Covered:
  • Beginner's Guide to Microsoft Excel
  • Excel data tools
  • Pivot tables with slicers
  • Bar charts, Scatter Plots, Histograms
  • Essential Excel formulas
  • Lookup functions (Vlookup, Hlookup, Index, Match)
  • Conditional and Table formatting
  • Excel shortcuts
• Key Skills Learned:
  • Proficiency in Excel data tools
  • Creating Pivot tables
  • Visual data representation
  • Mastering lookup functions
  • Efficient use of shortcuts

Course Format

• Duration: 1 hour on-demand video
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Certificate of completion
  • Downloadable resources on MS Excel techniques
  • Instructor support for queries