|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/dashboards-with-excel/
课程评论：没有评论
**Coursera 课程总结：Excel 仪表板制作** 本课程专注于教授如何使用 Microsoft Excel 制作专业的商业图表和仪表板。许多由控制器创建的报告因包含过多无关信息、混淆的图形和复杂的图例而难以被管理层理解。本课程旨在改变这一现状，通过“一页纸”（OPO）的概念，指导学员一步步创建简洁、专业的报告。 课程内容涵盖： * **专业表格的构建** * **欧元和百分比的偏差分析** * **条形图的应用** * **投资组合/四象限矩阵的制作** * **数据趋势图表的创建** * **Excel 相机工具的使用** 学员还将获得包含公式和解决方案的 Excel 培训文件。 **学习目标：** 完成本课程后，学员将理解成功的报告关键技术和方法，并掌握如何在 Microsoft Excel 中创建专业的仪表板。 **先决条件：** 具备 MS Office 基础知识，并拥有自己的 Excel 版本。 **技术说明：** 课程以 Excel 2016 创建，但所教授的图表和工具也兼容 Excel 2010 和 2007 版本，方法大同小异。
GENERALWhen controllers create reports or tools, they are not always read by management.Too often, the reports contain superfluous material, such as clipart, or confusing graphics and numerous legends.In this Online-Course you will learn how to create professional Business Charts with Excel step by step.The concept named OPO - one page only.At PUMA AG I was responsible for the worldwide Retail Controlling and developed a new Reporting-System for the stores. All reports were standard at board-management.In Germany I publish many articles and books about Microsoft Excel and how to use professional Dashboards in companies.CONTENTS (with Excel 2013 - 2016) you will learn:Building a professional tableDeviations (Euro and percents) in tablesbar chartsPortfolio / 4 fields matrixCharts for developmentsUsing the Excel cameraIn addition, you will receive the Excel training file (including the formulas and solutions)COURSE OBJECTIVEAfter the video course, you will understand the key techniques and methods for successful reporting and you will know how to create professional dashboards in Microsoft Excel.Basic knowledge of MS Office and an Excel version on your own computerrequired.PLEASE NOTEThe video course was created with Excel 2016, but the charts and tools can also be used with Excel 2010 and 2007. The approach is very similar.
