Udemy – Microsoft Excel Beginner to Advanced with Dashboard Project

This course is designed to take you from absolute beginner to advanced Excel user with practical, real-world skills.

Whether you are:

• A student
• A working professional
• An aspiring data analyst
• Or someone preparing for job interviews

This course will help you build strong Excel fundamentals and advanced data analysis skills.

What You Will Learn:

• Excel Basics & Interface
• Formatting & Data Management
• Sorting, Filtering & Tables
• Data Validation & Conditional Formatting
• Core Functions (IF, SUMIF, COUNTIF, DATE, TEXT, etc.)
• Advanced Lookups (VLOOKUP, HLOOKUP, XLOOKUP, INDEX MATCH)
• Pivot Tables & Pivot Charts
• Interactive Slicers & Timeline
• Choosing the Right Chart for Your Data
• Building a Complete HR Analytics Dashboard

You will build a complete:

• 1.  HR Analytics Dashboard in Excel

Including:

• KPI Overview Cards
• Attrition Analysis
• Department & City Analysis
• Trend Charts
• Interactive Slicers

This project will help you:

• Add real value to your resume
• Improve interview confidence
• Understand business-level Excel usage

By the end of this course, you will confidently:

• Fundamentals of Excel
• Formulas in Excel
• Advanced formulas in Excel
• Bonus tips in Excel
• Secret shortcut in Excel
• Analyse data
• Build dashboards
• Use advanced formulas
• Create professional reports