|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-data-visualization-techniques-for-impressive-reports/
课程评论：没有评论
此Coursera课程“Excel 图表——令人印象深刻的可视化秘诀”旨在帮助学习者掌握高级Excel图表制作技巧，成为数据可视化专家。课程涵盖了多种企业报告中常用的Excel图表类型，并专注于教授实用的、能显著提升报告专业性和可读性的高级图表技术。 **课程亮点包括：** * **实操性强：** 提供可下载的练习工作簿和答案，以及包含所有图表制作技巧的快速参考备忘录，方便学员跟随演示进行练习并作为日后参考。 * **动态图表制作：** 教授创建动态图表的“秘诀”，帮助学员节省手动更新图表的时间。 * **创新可视化：** 引入新颖的图表处理和创建方法，增强报告的可读性并给读者留下深刻印象。 * **内容全面，结构清晰：** 课程分为五个主要部分，包括数据趋势呈现的最佳实践、动态图表的后台秘密（涉及高级查找函数）、突出图表和表格元素的技巧、绩效对比方法（如实际数据与预算、预测和往年对比），以及对管理报告至关重要的各种图表组合。 * **教学方式多样：** 结合屏幕录制、讲者镜头和翻页板演示，力求模拟课堂体验，使复杂的Excel技巧讲解清晰易懂。 * **版本兼容性：** 演示将使用Excel 2010，但所教授的方法与旧版本和未来版本兼容。 课程特别适合需要使用Excel制作报告和图表的商务人士、财务专业人士、项目管理人员以及追求提升报告质量和效率的学生。学员将获得一套强大的Excel数据可视化工具，从而在工作中脱颖而出。
Without Doubt, With This Advanced Microsoft Excel Chart Course, You will be the Excel data Visualization star in your Department! Significantly Improve your Reports by using Advanced Excel Graph Techniques. This Course Includes:Downloadable Workbook to follow the demonstrations (and use the charts as your templates).Downloadable Exercise Book (answers included).Full set of Cheat Sheets for download in Lecture 3. This PDF document is a quick reference guide for whenever you need to create any of the charts in this training.If you use Excel to generate reports and graphs, my hands-on Excel training provides you with an extremely advanced toolkit worth of knowledge that will take the design of your Excel charts, tables and reports to the next level. It will provide you with the best tricks to create dynamic charts. It will save you tons of time of manually updating your Excel graphs on a monthly basis. The visualization techniques introduce you to some unusual methods to handle and create charts which will enhance readability of your reports as well as impress your readers. Lauren says: "I wish she had more courses on advanced excel and access that are formatted like this one. She frames the content in ways that are applicable to my current job. I will be able to improve my current processes and project turnaround time as well as the look/feel of my tables and charts."John says: "Leila does a fantastic job of walking you thru the process of creating various charts from scratch. From which formula to use to step by step chart creation. As a bonus you have actual exercises to practice your new skills, Absolutely one of the best instructional courses I have taken"Paul says: "Course is clear, to the point and very dynamic. Excellent!"Types of Excel Charts & Excel Graphs are presented:The content and type of Excel charts presented are those that are typical to corporate reporting. Given my background in controlling, finance and project management, I designed the training with this audience in mind and the typical methods used to report, communicate, analyze, check and plan quantitative information. If you are a student taking this course, rest assured that you are well equipped with advanced Excel visualization & chart design techniques to impress any employer who requires you to create graphs & reports in Excel.Demonstration will be done using Excel 2010, but all methods will be compatible with older as well as future versions of Excel unless otherwise stated in the video. My main focus is to introduce you to new "methods" of doing things which you can do no matter which Excel version you have. Why this course is different to other Excel courses:I will not only demonstrate to you, but you will be able to follow each demonstration in your own Excel workbook. To make sure you have understood the techniques, you will complete an exercise at the end of each section (answers are included but you have to try on your own first). I place great value on keeping the training not only informative but also interesting. I know technical courses can be boring, especially when taken online. For this reason, I have mixed screen-casts together with talking head and flip chart type of demonstrations to get it as close to a classroom training style as possible. I have also been told by many students that I have the ability to explain complex topics in an easy to understand manner. I think you will benefit from that.This course is split to 5 major parts:Methods to effectively communicate and present data trends - In this section I will also provide you with a crash course in best practices for table and graph design.Behind the scenes secrets of dynamic charts in Excel, where I introduce you to key functions you need to use to never manually update your Excel charts again -The functions you learn here go beyond graphs and charts. They enable you to do complex look ups in large data tables.Techniques that highlight Excel chart and table elements to direct the reader attention where it is needed most.New ways to compare performance: as in Actual data versus Budget, forecasts and previous yearEffective Chart Combinations that are pivotal to management reportsThis is an Excel Advanced Chart Course BUT you will be surprised how simple the techniques are once you know them!
