|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-in-the-business-context-all-versions/
课程评论：没有评论
课程名称：商务环境中的Microsoft Excel（所有版本） 课程概述：在这门课程中，我将教您在工作中成功使用Microsoft Excel所需的所有知识。根据我的经验，许多人并没有充分理解Excel如何帮助他们高效地完成工作，反而浪费了大量时间在可以简单化或自动化的任务上，而无需掌握编程语言。通过各种课程，我将介绍和解释不同的函数和功能，帮助您迅速完成工作中的典型任务。 如果需要修改包含500名员工个人信息的数据集？只需点击几下！分析过去几年的销售业绩并理解驱动业绩的因素？使用数据透视表，快速直奔主题！我的课程是设计为我们一起解决所有主题，实践性很强。完成后，您将能够： - 使用绝对和相对引用，使得复制和粘贴变得轻而易举 - 应用文本函数，快速制作员工识别证，无论数据集多大 - 使用IF函数，根据订单数量确定折扣 - 区分COUNTIF和SUMIF，并了解它们的不同使用场景 - 使用VLOOKUP和HLOOKUP，并理解TRUE与FALSE参数之间的差异。我还将教您VLOOKUP的缺点，以及为什么推荐使用INDEX和MATCH的组合 - 通过将数据格式化为表格，提升工作效率 - 运用数据透视表快速获取业务绩效的相关洞察 在整个课程中，您还将逐渐熟悉“隐藏功能”，例如在两个独立窗口中打开相同文件，从而提高工作效率。
In this course, I will teach you everything you need to know in order to succeed at work with Microsoft Excel. From my own experience, I know that people do not fully understand how Excel can help them work efficiently and effectively. Instead, they waste hours on tasks and activities that could easily be simplified or even automated - without needing programming language skills.Throughout the various lessons, I will introduce and explain different functions and features, which will help you to quickly complete typical tasks at work. Need to modify a dataset containing personal information on 500 employees? Just a matter of a few clicks! Analyzing the sales performance over the past years and understanding what is driving the performance? Use Pivot Tables and cut right to the chase!My course is designed so that we solve all topics together - it's hands on. Upon completion, you will be able to:- use absolute and relative references so that copying and pasting correctly becomes a piece of cake- apply text functions to quickly create employee badges, no matter how large the dataset- employ IF functions to determine discounts based on order quantity- distinguish between COUNTIF, SUMIF and how we can leverage the different use cases- use VLOOKUP and HLOOKUP, as well as the difference between the TRUE and FALSE arguments. I will also teach you the drawbacks of VLOOKUP, and why the combination of INDEX and MATCH is more recommendable - ramp up productivity by formatting data as TABLES- quickly arrive at the right insights into business performance with the help of Pivot Tables.Throughout the lectures, you will also become more and more familiar with the "hidden functionalities", such as opening up the same file in two separate windows to boost your productivity.
