ดึงและวิเคราะห์ข้อมูล The Secret Sauce ด้วย Power Query (ใช้ Excel หรือ Power BI ก็ได้)

🧑🏻‍💻อบรมกับเทพเอ็กเซล

📂หมวดหมู่

• Highlights : บทความแนะนำ (92)
• Excel Functions (503)
• Excel (271)
  • Excel ทั่วไป (164)
  • Pivot Table (15)
  • Excel Chart & Visualization (15)
  • Excel Advanced Formula (42)
  • Excel VBA (16)
  • Python in Excel (7)
  • Solver & Simulation (4)
  • Excel for Business (16)
  • Statistics and Maths (11)
  • Excel and Game (6)
• Power Query (70)
• Power BI (15)
• AI & Automation (35)
  • Automation (6)
  • AI Image & Video (23)
  • AI Chatbot (5)
• Programming (8)
• Personal (7)
• Resources (18)
• Uncategorized (2)

🏷️Tags

aggregate ai api chart clean combination concat data entry DDB depreciation dynamic array filterxml function query group by ifs iterative lambda machine learning marketing math matplotlib m code MINVERSE MMULT pandas parameter pi python regex rept rfm segmentation sequence simulation SLN small solve switch textjoin transpose unique VDB web scraping xirr xnpv