|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-analytics/
课程评论：没有评论
课程名称：Excel分析 - 数据分析与数据透视表和图表 课程概述：为什么要报名参加这门课程？本课程涵盖了Excel分析的各个方面，从下载数据集到分析和创建完整项目。它包括数据的基础知识和质量数据的重要性，以便为数据分析奠定良好基础。课程适合初学者和中级学习者，以提升技能至高级水平。课程涵盖所有商业类别，无论您目前在哪个行业或希望进入哪个行业，这门课程都适合您。通过本课程，您将能够独立进行Excel分析项目，甚至通过自由职业赚取收入。课程包含视频和非视频的完整项目，逐步指导，以及练习测试。所有问题和疑问将由讲师直接回答。此外，本课程会定期更新，以符合数据分析和Excel的最新动态。 您将学习的内容： 1. 数据： - 数据的定义、类型和导航； - 如何查找数据集以及如何在Excel中自动填充数据。 2. 数据清洗： - 清理数据集中的重复、空白或不一致之处，确保数据质量； - 掌握基本的Excel公式和数据格式整理方法。 3. 数据处理： - 学习统计公式和函数，以及逻辑函数（如IF、SUMIF等）的使用。 4. 数据分析： - 使用数据透视表进行数据分析，学习如何创建和格式化数据透视表。 5. 数据可视化： - 介绍各类图表类型及其在展示洞察和分析中的重要性，学习如何创建和自定义图表。 6. 最终项目（逐步指导）： - 在课程的最后部分，通过一个实际的数据分析项目来应用您所学的知识。 本课程的特色： - 课程内容完整且精准，您无需再参加其他Excel分析课程； - 提供快速的反馈和评估； - 自动生成多语言字幕（阿拉伯语、印地语和西班牙语）； - 定期更新可下载资源。 学生评价： 学员表示这门课程直接切入主题，非常适合希望开始学习Excel数据分析的人。课程内容易于跟随，讲师讲解清晰，适合初学者。参加这门课程后，您将获得必要的技能，以便在数据分析领域开展您的第一个项目。 欢迎加入我们的课程，我们期待成为您成功的一部分。
Why should you enroll in this course?This course covers all aspects of Excel Analytics starting from downloading a dataset to analyzing and creating a full project.It covers the fundamentals of Data and Quality data to have a good basis before getting into data analysis.It's suitable for beginner and intermediate levels to up their skills to advanced.It covers all business categories therefore, No matter what industry you're working in/want to work in, This course is for you.As a result of this course, you will be able to work on Excel Analytics projects on your own and make money freelancing.On-Video and Off-Video full project, Step-by-Step, in addition to practice tests.All your queries and questions will be answered by the instructor directly.Finally, This course is updated regularly to match the latest updates in regard to data analysis and Excel in particular.What will you learn in this course?1- DataData Analysis surely starts with Data, Hence, During Section 1, You will learnWhat's Data? Starting with its definition up to categories and qualitiesWhat are the Data Types in Excel?How to find a dataset?How to Navigate through a dataset?How to Autofil Data in Excel?2- Data CleansingData Cleansing is the process of clearing a dataset of any duplicates, blanks, or inconsistencies and making sure your dataset contains quality dataWhat are the traits of quality data?How to identify duplicates and blanks?Essential excel formulas (TRIM, UPPER, lower, Proper, Substitute, Concatenation)Filter and Sort FeaturesHow to change Data TypesText to ColumnHow to Format data as a table?3- Data ManipulationData Manipulation is the process of manipulating data to extract relevant and key information from your datasetStatistical Formulas or Functions (Mean, Median, Mode, Min, Max, Average)Data Manipulation formulas (SUM, VLOOKUP, HLOOKUP)Logical Functions (IF, IFS, SUMIF, COUNT, COUNTIF, COUNTIFS, COUNTBLANKS)4- Analyze DataStage 4 is analyzing data using Pivot-Tables to gain more insights by creating a pivot table based on different rows/columns/filters and calculationsIntroduction to Pivot-tables to understand what it is and why it is importantHow to create a Pivot-Table?How to Format Data in a Pivot-Table?How to apply calculations on data in a Pivot-Table?How to Sort Data in a Pivot-Table?What are Slicers? How to use them and Why they are important?How to create automated recommended Pivot-Tables?5- Data VisualizationFinally Data Visualization, This is the final stage where you get to present your insights and analysis using Charts and Graphs, Charts are important as each Chart Type could identify hidden patterns and trendsIntroduction to important Chart Types such as (Bar Charts, Column Charts, Line Charts, Combo Charts, Pie Charts, and Doughnut Charts)How to create a Pivot-Chart?How to Apply a Slicer to a Pivot-Chart?How to Manually Style your Pivot-Chart?6- Final Project (Step-by-Step)In the final section of the course, we will run through a hands-on data analysis project where you will make use of the knowledge you have gained throughout the course.What makes this course different from the other courses?This course is complete and precise, Hence, You won't have to take another course in Excel Analytics.This course teaches you everything about data analysis and guides you through your first data analysis project.Less than 8 hours avg response time (By the instructor)Assessment (First Project) evaluation in less than 24 hours by the instructorIt offers auto-generated subtitles in more than 3 languages including (Arabic, Hindi, and Spanish)Regularly updated downloadable resources.What our students say about this course:I would say this course is just straight to the point and exactly as described, i would definitely recommend it to any one who looks to start learning data analysis using Excel, Thank you Moustafa!I like it so far very to the point and basic so anyone can catch on. I am doing work to up my career skills and finding this course was exactly what I needed!awesome course. The course materials are easy to follow even for novices and the instructor teaches very well explained. I will recommend this class to whom want to learn data analytics with excel.This course is complete as you will learn all that you need to get your hands dirty in the field of Data Analysis, You will obtain the important intellectual and technical skills to start your first project.Enroll with us, We're looking forward to becoming a part of your success.
