Professional Advanced Excel

About this course

🎯 သင်တန်းအကျဉ်းချုပ် ဒီသင်တန်းသည် Excel ကို အခြေခံနှင့် Intermediate အဆင့်ကျော်ပြီးသူများအတွက် ရည်ရွယ်ထားပြီး Business Reporting, Data Analysis, Automation နှင့် Dashboard Development များကို Professional Level ဖြင့် လက်တွေ့အသုံးချနိုင်စေရန် သင်ကြားပေးပါသည်။ 👨‍💼 သင်ယူမည့်သူများ Senior Office Staff / Accountant / Analyst များ Data Analyst / MIS Officer ဖြစ်လိုသူများ Business Intelligence ပိုင်းတွင် လုပ်ကိုင်လိုသူများ Freelancer / Consultant များ Excel Skill ဖြင့် Career Upgrade လုပ်လိုသူများ 📚 Course Content (Professional Modules) 📌 Module 1: Advanced Formula Mastery Nested IF, IFS, SWITCH Advanced Lookup (XLOOKUP, INDEX + MATCH + MATCH) Dynamic Array Functions (FILTER, SORT, UNIQUE) TEXT, DATE, FINANCIAL Functions (PMT, NPV) Error Handling (IFERROR, IFNA) Formula Optimization Techniques 📌 Module 2: Advanced Data Management Structured Tables & Named Ranges Advanced Data Validation (Dependent Dropdown) Data Cleaning Techniques (Powerful Methods) Remove Duplicates with Conditions Data Consolidation 📌 Module 3: Pivot Table (Expert Level) Advanced Pivot Table Design Slicers & Timeline Calculated Field & Calculated Item Pivot Performance Optimization Multi-source Data Analysis 📌 Module 4: Dashboard Development Interactive Dashboard Design Principles Dynamic Charts & Controls KPI Dashboard Creation Business Reporting Automation User-friendly Interface Design 📌 Module 5: Power Query (Data Transformation) Data Import from Multiple Sources (Excel, CSV, Web) Data Cleaning & Transformation Automation Merge & Append Queries Refreshable Reports 📌 Module 6: Power Pivot & Data Modeling Data Model Creation Table Relationships DAX Basics (SUMX, CALCULATE, etc.) Advanced Data Analysis Techniques 📌 Module 7: Excel Automation with VBA Macro Recording & Customization VBA Basics (Variables, Loops, Conditions) User Forms (Basic) Automating Reports & Tasks Button-based Automation 📌 Module 8: Real-World Business Projects Sales & Revenue Dashboard Financial Analysis Report Inventory Management System HR Attendance & Payroll Template Complete Business Intelligence Dashboard 🛠️ Professional Skills You Will Gain Data Analysis & Decision Making Skill Dashboard Design (Corporate Level) Automation (Time Saving Techniques) Business Reporting (Professional Format) Problem Solving with Excel ⏰ သင်တန်းကြာချိန် Duration – (6 Weeks / 8 Weeks / 12 Weeks Customize) Class Type – Online / On-campus / Corporate Training

What you'll learn

• Excel

Requirements

• Basic Computer Skill