|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2016-excel-from-beginner-to-advanced/
课程评论：没有评论
Coursera 课程总结：精通 Microsoft Excel - 从入门到高级 本课程是 Microsoft Excel 的全方位训练，涵盖了从初级到高级的所有内容。课程内容以 Excel 2016 版本录制，但适用于 Excel 2010、2013、2016、2019 和 365 版本。Mac 用户可能会因为界面差异而感到稍有不同。 讲师拥有超过 17 年的 Excel 培训经验和多项微软认证，包括 Office 专家、专家级和大师级讲师（覆盖 2000 至 2016 各版本）、微软认证讲师 (MCT) 和微软认证专业人士 (MCP)。 完成本课程后，您将掌握 Excel 技能，有效减轻工作中的不确定性，节省日常工作时间，并为通过微软的 Excel 核心和专家级考试并获得认证打下坚实基础。 **课程将教授的主要技能包括：** * 创建有效的电子表格 * 编写和编辑公式及计算 * 使用排序和筛选选项 * 正确构建数据库并避免常见设计缺陷 * 创建信息丰富且引人注目的图表 * 利用宏消除重复性任务 * 创建多种包含不同数据组的场景 * 在列表或表格中管理大型数据范围 * 通过 IF、PMT、VLOOKUP、FIND、SEARCH、MATCH 等函数提高生产力
Microsoft Excel All-In-One Training This Microsoft Excel course includes all three Levels from Beginner to Advanced Microsoft Excel Level 1 - Beginner Microsoft Excel Level 2 - Intermediate Microsoft Excel Level 3 - Advanced Material recorded with Excel 2016 but works in 2010, 2013, 2016, 2019 and 365. MAC users, since the videos are recorded with the Windows version of Microsoft Excel, the interface will be a bit different.As your instructor I will use my 17+ years of Excel training and certifications including: Microsoft Office Specialist, Expert and Master Instructor: 2000, XP (2002), 2003, 2007, 2010, 2013 and 2016, Microsoft Certified Trainer (MCT), Microsoft Certified Professional (MCP) to guide you step by step through Beginner, Intermediate and Advanced Levels of Excel. At completion of this course you will master Excel skills that will alleviate the discomfort of uncertainty and reduce time working through your daily tasks, as well have all the training you need to help pass both Microsoft's Excel Core and Excel Expert Exams and become certified, like me. Below are just a few of the topics that you will master: Creating effective worksheets Writing and editing formulas and calculations Use sorting and filtering options Build a database right the first time and avoid common design flaws Creating informative and captivating Charts Eliminate repetitive tasks instantly using Macros Create many scenarios with varying groups of data Manage large ranges of data in a List or Table Increase productivity with functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH and much more...
