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