|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2019-learn-basic-concepts-of-excel/
课程评论：没有评论
课程名称：学习Microsoft Excel并创建交互式仪表板 课程概述： 本课程涵盖两个Microsoft应用程序的培训：Microsoft Excel和Microsoft Power BI，这两款软件在办公室和商业领域中非常实用。 在Microsoft Excel/Office 365部分，您将学习： - 数据透视表、数据透视图、Power Query、Power Pivot、Power Map、假设分析工具、求解器等主题。 - 如何在Excel中添加图表。 - 如何使用公式和函数。 - 如何在Excel中创建仪表板。 此外，课程还包含额外的可下载仪表板模板，这些模板提供了多种预算和销售分析的解决方案，包括： - 每月预算仪表板模板 - 销售KPI仪表板模板 - COVID-19数据分析仪表板模板 - 房地产管理仪表板模板 - 完全自动化的库存管理仪表板模板等。 在Microsoft Power BI/Office 365部分，您将学习： - 如何在Microsoft商业智能Power BI中分析数据。 - 如何创建报告和仪表板。 - 如何从网站及其他来源提取数据，并在Power Query编辑器和Power BI中转换数据。 - 数据如何在Power BI中可视化。 - 如何在报告页面中添加按钮和自定义视觉元素。 本课程内容丰富，无论是初学者还是希望提升技能的用户，都能从中获益匪浅。
Note: Select "auto" to watch 1080p HD quality videos.This course covers training for two Microsoft apps.Microsoft Excel and Microsoft Power BI.These two apps are very useful in the office and business world. Microsoft Excel/Office 365Learn pivottables ,pivotcharts,power query,power pivot,power map,what-if-analysis tools,solver and others topics.Learn how to add charts in Microsoft Excel sheet.Learn how to use formulas and functions in Microsoft Excel.Learn how to create dashboards in Excel.To see more topics of this course,view course contents in the course landing page.Note:-Extra downloadable Dashboard Templates are included with this course in the resource.21.Covid 19 (1).xlsx20.Covid 19.xlsx19.Monthly Budget Dashboard Template.xlsx18.University Monthly Budget Dashboard Template.xlsx17.Monthly Personal Budget Dashboard Template.xlsx16.Multiple Dependent drop down list Sales Dashboard.xlsx15.Dependent drop down list Sales Dashboard.xlsx14.Sales KPI Dashboard Template 2.xlsx13.Download Searchable Drop Down List COVID - 19 Microsoft Excel Dashboard Live Update 26/05/2020.xlsx12.Searchable drop down list Excel Dashboard Template with lookup picture.xlsx11.Extra Project 2 - Sales Commission Calculator Template.xlsx10.Extra Project 0 - Searchable Drop Down List Sales Dashboard Template.xlsx9.KPI Sales Dashboard Template.xlsx8.Business Finance Management Dashboard Template.xlsx7.Extra Project 0 - COVID - 19 Data Analytics in Excel Dashboard Template 1 - Live Update.xlsx6.Download Sales KPI Dashboard Template1.xlsx5.Download Customer Analytics Dashboard Template.xlsx4.Extra Project 5 - Real Estate Management Dashboard Template.xlsx3.Download Sales Team Dashboard Template.xlsx2.Extra Project 6 - Fully Automated Inventory Management Dashboard Template.xlsx1.Extra Project 0 - COVID - 19 Data Analytics in Excel Dashboard Template 2 - Live Update.xlsx ______________________________________________________________________________________________________ Microsoft Power BI/Office 365Learn How to Analyze Data in Microsoft Business Intelligence Power BI.How to Reports and Dashboards are Created in Power BI.In this course,you will learn,how to analyze business data in Microsoft business intelligence power bi.You will learn how to extract data from the website and an other sources and how that data is transformed in power query editor and power bi.You will learn how to that data is visualized in power bi.You will learn how to create reports and dashboards in power bi and how to add buttons in report page.You will learn how to custom visuals are added and data is visualized from that visuals.And much more!
