|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-2016-part-3-expert/
课程评论：没有评论
课程名称：Microsoft Excel 2016：第三部分（专家级） 课程概述： 您是否希望成为Excel专家，并充分利用Excel 2016的强大功能？本专家课程将帮助您掌握特别有用的功能，例如协作编辑工作簿和管理更复杂的Excel文档，利用公式追踪和引用函数等工具。通过与同事协作、自动化复杂或重复的任务，以及使用条件逻辑构建和应用精细的公式和函数，您将能够充分发挥Excel的潜力。越多地了解如何让Excel为您完成繁重的工作，您将越能专注于从组织产生的大量数据中获取所需的答案。 教学方法： 培训师将逐步讲解使用Microsoft Excel的所有重要和有用功能与特性。您还可以受益于课程中整合的丰富补充材料，例如练习文件、讲义和小测验。 适合对象： - 需要处理大型复杂工作簿的用户 - 想要自动化重复任务的用户 - 需要构建复杂Excel函数并使用这些函数对广泛复杂数据集进行严格分析的用户 课程要求： 本课程面向已熟练使用Excel 2016的学生，旨在提升他们在使用更高级Excel功能方面的技能。 课程目标： 完成本课程后，您将能够进行高级数据分析、与其他用户协作处理工作簿，并自动化工作簿功能。您将能够： - 处理多个工作表和工作簿 - 使用查找函数和公式审计 - 分享和保护工作簿 - 自动化工作簿功能 - 创建微图表和地图数据 - 进行数据预测 本课程涵盖Microsoft Office专家考试的目标，帮助学生为Excel 2016考试和Excel 2016专家考试做好准备。
COURSE DESCRIPTIONWould you like to become an Excel specialist and use the enormous functionality of Excel 2016 to your advantage? In this expert course, you will get to know especially helpful features, such as collaborative editing of workbooks and management of more complex Excel documents, through the implementation of tools such as formula tracking and reference functions. The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.METHODThe trainer explains step by step all important and useful functionalities and features for working with Microsoft Excel. Benefit from the extensive additional materials that are integrated into the training. Look forward to practice files, handouts and quizzes.THIS COURSE IS SUITABLE FOR YOU IFyou need to troubleshoot large, complex workbooksyou want to automate repetitive tasksyou need to construct complex Excel functions and use those functions to perform rigorous analysis of extensive, complex datasetsPREREQUISITESThis course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features.COURSE OBJECTIVESUpon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. You will:Work with multiple worksheets and workbooksUse Lookup functions and formula auditingShare and protect workbooksAutomate workbook functionalityCreate sparklines and map dataForecast dataThis course covers Microsoft Office Specialist exam objectives to help students prepare for the Excel 2016 Exam and the Excel 2016 Expert Exam.
