|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-dashboards-reports/
课程评论：没有评论
课程名称：视觉有效的Excel仪表板 课程概述：创建一个令人印象深刻的互动Microsoft Excel仪表板并不容易！在课程中，您将学习如何从零开始，按照结构化的流程将想法转化为成果。该课程将指导您从头开始设置两个完整功能的仪表板，不仅教您如何使用各种功能，还教您如何将这些功能结合起来创建出色的报告。您将学习如何处理新的仪表板项目，以及如何结构化您的工作，使维护仪表板变得简单易行。 课程亮点： - 更新为包括OFFICE 365 & OFFICE 2021版本的KPI仪表板，您可以下载新版本并探索新功能，例如FILTER、SEQUENCE、XLOOKUP等。 - 提供Excel仪表板和报告模板、检查表及设计指南，确保您能直接应用于Excel报告。 - 包含从创意到交付的整个过程，无遗漏关键步骤。 - 使用受信赖的技术，适用与所有Excel报告，并以行业需求为基础进行更新。 - 复杂主题通过一位拥有17年经验的讲师以简单的方式讲授，内容清晰组织，方便高级学习者随时加入。 学生反馈： 许多学生表示，这门课程提供了大量实用技巧，可立即应用于他们的电子表格，适合各种水平的用户，受到广泛好评。 学习成果： 完成本课程后，您将能够创建设计良好的Excel仪表板，使您和同事能够基于数据快速做出明智决策。课程附带的模板和工具将大大简化您的报告制作过程。
Creating an impressive, interactive Microsoft Excel Dashboard from scratch is not easy!I used to stare at my empty sheet and wonder where do I even start? You need a structured process in place to go from idea to outcome in a smooth way. You'll find out all about it in the course. We setup two fully functioning dashboards from scratch.This course doesn't just teach you a set of functions and features, but how you can use them together to create impressive reports. It teaches you how to approach a new Dashboard project and how to structure your work so maintaining the dashboard becomes very easy not just for yourself but for anyone else.★ Note: Course recently updated to include the OFFICE 365 & OFFICE 2021 version of the KPI dashboard. You can download that version if you have Office 365 and see how you can use FILTER, SEQUENCE, XLOOKUP and other newer Excel functions to create the dashboard ★What students are saying"This course provides a lot of great tips which you can immediately apply to your spreadsheets, no matter what standard of user you are. I have been working in excel for a number of years and I am amazed at the number of simple tips I have learnt in such a short time. Fantastic." - Carl Postians"I learned something new and very useful in the first 10 minutes...awesome!" - Nancy BowensWhat you learnThis course teaches you to create well-designed Excel dashboards so you and your colleagues can see trends and make quick decisions informed by data.This Microsoft Excel Dashboard course comes with templates, tools and checklists that can be applied directly to your Excel reports. Excel dashboard & Report templates Checklists and design guidelines Excel workbook to follow along What differentiates this course from the other Microsoft Excel Dashboard courses? It includes:The entire process from idea to delivery - every single step without skipping key points.Tried-and-trusted techniques that are not only applicable to Excel dashboards but any Excel report.Includes Excel templates, tools and checklists that you can use for your own Excel reports.Relevant and up-to-date with industry needs right now, as it's based on feedback and suggestions from finance professionals. Lots of ideas and inspiration to help you come up with own report designComplex topics are taught in a simple way by an instructor with 17 years of experience.The course is designed to have an even balance between talking head and screen-cast.Content is clearly organised so more advanced learners can jump in at any point and follow along with the relevant project file.
