|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-crash-course-dashboards-data-analysis-heatmaps/
课程评论：没有评论
课程名称：Excel速成课程：仪表板、数据分析与热图 课程概述：本课程是一个100%以项目为基础的微软Excel速成课程，特别关注数据分析、简单仪表板的设计以及热图和其他图表的创建。通过使用现代Excel表格并学习如何从数据中提取洞察力，您将在3小时内实现Excel技能的飞跃。作为一名商业智能顾问，我根据日常业务需求的技能设计了课程，旨在实现特定目标。该课程是快速开发高级Excel用户技能的捷径，特别适用于Office 365环境。 在本课程中，学生将处理Twitter数据和燃料价格数据两个不同的数据集，设计仪表板并使用数据透视表和美观的热图提取洞察力。您将学习如何从数据科学、数据可视化和数据分析的角度探索Microsoft Excel，设计三种仪表板系统（Twitter活动热图、先进货币转换器、商务发票仪表板），并运用Excel的时间智能和文本函数提取日期和时间信息。课程还将教授如何操控数据透视表来设计有效和美观的图表，使用Power Query工具进行数据的操作与整合，以及如何细化Excel仪表板与可视化的技巧，快速提升数据可视化能力。 此外，您还将通过处理从Twitter API获取的数据来测试您的数据分析技能，学习如何最大化办公生产率并通过自动化技能提高薪资。具备先进的Excel技能将为您在商业分析、产品管理、数据分析、运营和战略等角色中开辟多种职业机会。 课程结构采用项目为基础的速成形式，包含18个简短讲座，每个讲座覆盖一个概念，以及两个问题解决环节（数据挑战）。整个课程时长为1.8小时，外加超过1小时的练习题，这些练习涵盖真实生活中的分析场景。课程完全基于实例，通过使用真实活动的数据，确保课程内容实用且易于理解。完成课程后，您将获得可验证的结业证书。 课程要求：建议使用Windows上的Office 365版Excel，或Microsoft Excel 2010-2019（PC/Windows）。Mac用户欢迎，但请注意，数据透视表的界面在不同平台上可能存在差异。具备Excel基础报告知识者优先，但非必需。 适合人群：对数据分析感兴趣的Excel初学者、希望提升办公效率的高级用户、对数据可视化感兴趣的商科学生、以及希望在数据分析和建模方面获得知识的商业专业人士等。
This is a 100% project-based Microsoft Excel crash course with a special focus on data analysis, designing simple dashboards and creating heatmap visuals and other charts. Maximizing office productivity is a key skill to learn. By working with modern Excel tables and learning how to extract insights from data, you'll achieve a leap in your Excel skills in 3 hours.Supercharge your Microsoft Excel skills rapidly in this Crash Course!As a Business Intelligence consultant, I designed the curriculum based on some of the skills needed to get you powering through your daily business needs, and I've designed the courses to achieve specific objectives. This course is a hack to develop advanced power-user skills in Microsoft Excel on Office 365 in a very short period of time.Students will work on two different datasets - Twitter data and fuel prices data - to design dashboards and extract insights using Pivot tables and beautiful heat maps.In this course you will learn how to:Explore Microsoft Excel from a data science, data visualisation and data analysis perspectiveDesign three dashboard systems in Excel - Twitter Activity Heatmap, Advanced Currency Converter, Business Invoicing DashboardWork with Excel time intelligence and text functions to extract HOUR of DAY, DAY of WEEK etcManipulate pivot tables to design effective and beautiful charts and heatmap visualsDesign and customise pivot charts by adding custom imagesUse the Power Query tool to manipulate and mashup dataUse certain tips and tricks to fine-tune your Excel dashboards and visuals to supercharge your data visualisation skillsTest your data analysis skills by working on data retrieved from Twitter APILearn HOW to maximize office productivity and increase your salary with automation skillsWhy Excel skills matterAdvanced Microsoft Excel skills can open up a whole myriad of career opportunities in business analysis, product management, data analysis, operations and strategy roles. As a skilled Excel user that is able to extract insights from data, you will be comfortable in working in industries such as finance, consulting, manufacturing, pharmaceutical, analytics or other business roles. Excel is the primary spreadsheet application used in financial modelling and ad-hoc data analysis.In this 100% example-based and project-based course, you'll develop highly marketable business-focused Excel skills in data analysis and data visualisation to help you outperform competing candidates for promotions, job opportunities, and internships. You'll learn what it means to be the Excel go-to person having an unfair advantage in analytical skills.How is the course structured?The course curriculum has been designed as a project-based, crash course. You will learn rapidly by working through the Twitter dataset to understand rudimentary data analysis and design novel heatmaps. Then in the latter half of the course, you will learn how to work with modern Excel tables and manipulate them using the Power Query tool, structured referencing, and using the functions available on Office 365 version of Excel to craft automated calculations and dashboards.The course builds on itself, meaning that as we continue forward in the course we'll re-use the concepts from previous sections to further reinforce them. All of the material is 100% example-based and we'll use multiple real-life examples throughout the course.The course is composed of 18 short lectures each of which covers one concept at a time, and 2 problem-solving sessions (data challenges). The full course length is 1.8 hours of well thought out, deliberate content to get you building and designing within Excel. You will also get over 1 hour of practice problems which are very detailed and cover real-life analytical scenarios.I designed this course to be as practical and as relatable as possible by using sample data from real-life activities. The course is complete with working files, you'll be able to follow along practising each concept and receive a verifiable certificate of completion when you finish the course!It's a crash course so be ready to take a leap!Are there any course requirements or prerequisites?Preferably Excel on Office 365 for Windows. Microsoft Excel 2010-2019 (PC/Windows)Mac users are welcome but note that the interface of Pivot Tables varies across platformsKnowledge of Excel for basic reporting is an added advantage but not requiredBe ready to make a leap. It's a crash courseWho this course is for:Beginner in Excel interested in data analysisMore advanced users looking to learn how to improve office productivityBusiness students curious about data visualizationBusiness professionals interested in data analysis and modellingCrash course enthusiastsPython developers and coders interested in data analysis and Excel
