|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-data-visualization-creating-impactful-reports/
课程评论：没有评论
本课程名称为《Excel与数据可视化：创建影响力仪表盘》。如果您已经进入职场，您一定注意到Excel在任何行业中的重要性，它不仅对银行家和分析师必不可少，市场营销、数字营销、HR、客户关系管理等职能也同样需要它。Excel是一种强大的工具，已深深融入全球商业流程中，用于分析销售数据、预算、财务建模和人力资源规划等。掌握Excel可以使您的工作生活更加轻松，但如果不加以掌握，它也可能成为一场噩梦！ 本课程旨在让您深入探讨Excel的美妙之处，掌握数据分析技能。课程通过三个实际案例进行组织，同时涵盖了数据可视化这一热门话题。您将学习如何创建令人印象深刻的互动Excel仪表盘，并了解最有用的Excel函数和公式。三个实际案例分别基于以下数据集： 1. 从Google Analytics提取的电子商务网站观众和销售数据（约5000行） 2. 从INSEE提取的1900年至2019年间法国命名数据（约70万行） 3. 从Yahoo Finance提取的加密货币价格数据（约5万行） 希望本课程能帮助您提升Excel技能，给您的（未来）同事们留下深刻印象！准备好了吗？让我们出发吧！
Have you already stepped into the professional world? If yes, you must have noticed that Excel is essential to any function in any industry, not only Bankers or Analysts, but also Marketing (Product/Project manager...), Digital (SEO/SEA managers, CRM, Community manager, Business developer, Product owner...), HR, Client relationship manager etc.Excel is a powerful tool that has become entrenched in business processes worldwide, for analyzing sales data, budgeting, financial modelling, HR planning etc.. It can be your best friend, helping you to simplify your life; but it could also be a nightmare if you don't master it well! Within this course, I hope you can discover the beauty of Excel, perform a deep-dive into this powerful tool and master data analysis with EXCEL! To make your learning more attractive, I organize this course by going through 3 practical cases and also cover the trendy topic of data visualization. I will also share my methodology to create impressive interactive Excel dashboards and show you the most useful Excel functions & formulas!The 3 practical cases are based on different sets of data:- Audience and sales data of an e-commerce site, extracted from Google Analytics (c. 5000 lines)- Data on names given in France from 1900 to 2019, extracted from INSEE (c. 700 000 lines)- Data on prices of Cryptocurrency, from Yahoo Finance (c. 50 000 lines)I hope that this course can help you to improve your Excel skills and impress your (future) colleagues! Are you ready? Let's GO!****** You can also find the SYLLABUS of this course in the introduction section.******
