The Complete Microsoft Excel Course: Beginner to Expert

Course Overview

• Course Title: The Complete Microsoft Excel Course: Beginner to Expert
• Instructor: Skillify Academy
• Target Audience:
  • Students
  • Business professionals
  • Data analysts
  • Entrepreneurs
• Prerequisites: No prior Excel experience needed

Curriculum Highlights

• Key Topics Covered:
  • Basic Excel Interface
  • Basic Arithmetic Operations
  • Understanding Cell References
  • Statistical Functions
  • Sorting and Filtering Data
  • Using VLOOKUP and HLOOKUP Functions
  • Conditional Formatting
  • Creating Basic Charts
  • Power Pivot
  • Macro Recording and VBA Basics
  • Data Validation and Error Handling
  • Create a daily sales report with dashboard
• Key Skills Learned:
  • Navigating the Ribbon and Workbooks
  • Entering and formatting data
  • Essential Excel functions
  • Organizing data with sorting tools
  • Intermediate formulas
  • Creating charts and graphs
  • Conditional formatting rules
  • PivotTables
  • Advanced formulas
  • Power Query
  • Macros and VBA
  • Data analysis tools
  • Dashboard creation
  • Expert tips and tricks
  • Practical projects and exercises

Course Format

• Duration:
  • 2.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Certificate of completion