Data Analysis in Excel (2024)
Hybrid
5 hours
English
Data & Engineering
ภาพรวมหลักสูตร
Unlock the full potential of Microsoft Excel for data analysis with this comprehensive course designed for beginners and professionals alike. Dive into techniques for cleaning and preparing datasets, using Excel's statistical functions for analysis, and creating impactful visualizations.
Master the art of working with pivot tables, advanced formulas like VLOOKUP and INDEX-MATCH, and interactive dashboards to present your data insights. By the end of this course, you’ll have the tools and confidence to make data-driven decisions and present them effectively in your personal or professional projects.
สิ่งที่คุณจะได้เรียนรู้
- Understand the Basics of Excel for Data Analysis: Develop proficiency in Excel's core features, including data entry, basic formatting, and essential functions
- Data Manipulation and Transformation: Gain the ability to sort, filter, and use Excel's advanced functions
- Pivot Tables and Pivot Charts: Master the use of pivot tables and pivot charts to summarize, analyze, and present complex datasets efficiently.
- Data Visualization: Create and customize charts and graphs (bar, line, pie, scatter, etc.) to effectively visualize data trends and insights.
- Advanced Excel Functions and Formulas: Explore more advanced formulas (e.g., IF statements, conditional formatting, array formulas)
ฟรี
Udemy
https://www.udemy.com
ทักษะที่คุณจะได้รับ:
Excel
Vlookup
Pivot Tables
