|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-with-excel-2016/
课程评论：没有评论
**课程名称：** NEW! EXCEL 2016：从入门到精通 **课程概述：** 本课程旨在帮助学员将Excel技能从初学者提升至专业水平。课程内容精炼，摒弃冗余，覆盖了广泛的Excel功能，包括基础操作及数据透视表等更高级的应用。课程全部使用Excel 2016进行录制。 **主要学习内容：** * 创建工作簿 * 工作簿内跨工作表引用 * 快速图表制作 * 快速排序 * 快速填充 （Flash Fill） * 命名区域 * Excel工作表管理（移动、着色、创建） * 利用地址数据创建3D地图 * 常用Excel函数（如SumIf, VLookUp, Left, Right, Mid, Len等） * 高级Excel功能，如嵌套公式 * 使用切片器（Slicers）进行快速排序和美化表格 * 全面的数据透视表教学视频 **课程特色：** * 完成课程可获得可验证的结业证书。 * 课程内容紧凑，效率高。 * 定期（每月新增4个新讲座）更新课程内容，并鼓励学员提供反馈，共同进步。
By Completing this course, you will receive a verifiable Certificate of Completion.This course has cut down on the fluff and empty space to keep it shorter, but still cover a wide range of topics. Designed for people starting out with Excel, it also covers some of the more complicated and important areas like Pivot Tables.This Excel course is recorded completely using Excel 2016, the latest version of Excel offered in the Microsoft Office 2016 suite.Some of the topics include (but not limited to)Creating your first workbookReferencing from other sheets within a bookQuick ChartsQuick SortingFlash FillNamed RangesExcel Sheet Management (moving, colouring, creating)Creating 3D maps using address data in a listPopular Excel Functions like SumIf, VLookUp, Left, Right, Mid, Len and morePower Excel functionality like nested formulasUsing slicers to quickly sort and make spreadsheets look goodA complete set of Pivot Table videosI aim to add 4 new lectures every month to the course, and would love to have your feedback. So once you have signed up and completed the training, let me know what you would like to learn next!
