|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-in-the-business-context-advanced-course/
课程评论：没有评论
课程名称：商业环境下的Microsoft Excel - 高级课程 概述：理解Excel背后的逻辑以及使用高级公式的能力是提升职场竞争力的关键。如果您已经掌握了Microsoft Excel的基本功能，并希望将技能提升到一个新的水平，这个课程将非常适合您。我们将通过解决一些典型的工作相关问题，如创建展示各国销售额的仪表板、跟踪员工工作时间或规划项目活动，来扩展您对Microsoft Excel的知识。课程旨在让您理解Excel的潜能，并在解决不同情况时能够有效应对，同时了解不同方法的优缺点。 在本课程中，您将： - 在第一章中利用生产力增强工具提升工作效率 - 使用高级筛选器动态筛选数据集 - 从零开始创建模型和仪表板，并通过动态图表进行可视化 - 从互联网检索数据并直接整合到工作簿中 - 应用Excel的编程语言Visual Basic - 理解Excel如何处理日期和时间，以及如何使用不同的公式进行操作 不要再浪费时间在可以轻松自动化的琐事上！利用高级公式和对Excel内在逻辑的扎实理解，腾出时间专注于更重要的工作活动！
Understanding the underlying logic of Excel and the ability to use advanced formulas are key to getting an edge at work. If you already have a solid understanding of basic functionalities in Microsoft Excel, and would like to take your skills to the next level, this is the right class for you.Together, we will expand our knowledge of Microsoft Excel by working on typical work-related problems such as creating a dashboard to show sales by country, keeping track of employees' time spent at work, or planning project activities. The course is designed so that you will understand what is possible in Excel, and how to best tackle different situations whilst being aware of the advantages and disadvantages of different approaches. In this course, you will:- ramp up your productivity with the productivity boosters in chapter 1- use advanced filters to dynamically filter your data set- create models and dashboards from scratch and visualize them in dynamic charts- retrieve data from the internet and integrate them directly into your workbook- apply Visual Basic, the programming language in Microsoft Excel- understand how Excel treats date and time, and what you can do with the different formulasDon't waste your time at work carrying out mundane tasks, which could easily be automated! Leverage advanced formulas and a solid understanding of the inherent logic of Excel to free up your time to focus on the truly important activities!
