|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2016-advanced-training-master-class/
课程评论：没有评论
课程名称：Microsoft Excel 2016 高级培训大师班 课程简介： 本课程旨在帮助学员成为Microsoft Excel的专家，课程包含9小时的专业视频教学，配有练习文件和演示文件，方便学员进行实际操作。通过简明易懂的步骤讲解，学员将可以快速掌握Excel 2016的高级功能。本课程是完成“Microsoft Excel 2016 初学者”课程后的一个重要进阶。 课程内容包括： - 学习如何导入和导出数据 - 制作各种图表与图形 - 有效创建和使用函数与公式 - 创建和运用数据透视表 - 使用Excel进行数据分析 - 理解财务和统计函数的实用方法 课程设置： - 9小时的视频教程 - 超过50个单独的讲座视频 - 练习文件以巩固所学知识 - 培训师使用的演示文件 - 可打印的课程文字记录，方便做笔记 - 完成课程后颁发结业证书 该课程适合已经熟悉Excel的学员，旨在帮助他们提高使用技巧，拓展Excel的应用潜力。课程通过57节讲座，涵盖日常工作环境中函数的使用、专业财务函数的应用（如支付、未来价值和折旧）、统计函数（如平均值、百分位数和回归分析），以及与外部数据连接的概念，帮助学员提高工作效率。 在报告方面，学员将学习表面图、股票图、雷达图和气泡图的制作，以及生成色彩丰富的图表和数据库，有效传达数据和财务记录。完成课程后，学员将能应用所学，进行重要的分析和计划。 学生反馈： 许多学员对本课程给予了高度评价，认为课程内容条理清晰，实例丰富，极大地帮助了他们深入理解Excel。 课程更新： - 2017年7月更新：添加英文字幕 - 2017年6月更新：现已提供课程文字记录 如需了解更多课程信息，可搜索“Simon Sez IT”以查看完整的课程列表及多课程捆绑的超值选项。
Become a Microsoft Excel expert with this easy to follow course featuring 9-hours of professionally produced videos. Exercise and demo files included.Practice what you learned with included exercise files Detailed easy instruction to master Microsoft Excel 2016 A full 9 hours of professional video instruction 60+ easy to follow how-to videos Everything explained step-by-step for quick comprehension The next step after completing Microsoft Excel 2016 for Beginners Learn how to import and export data to and from ExcelLearn how to create various charts and graphsEffectively create and use functions and formulasImport and export data Create and effectively use Pivot TablesHow to use Excel for data analysisDiscover practical methods for financial & statistical functions This course includes: 9-hours of video tutorialsOver 50 individual video lectures Exercise files to practice what you learnedDemo files used by the trainerPrintable course transcriptions to follow along and take notesCertificate of completionThis course is designed for students that are already familiar with Excel, but wish to improve their skills and open the possibilities with this versatile spreadsheet program. Bring your basic knowledge of Excel 2016 and learn how to reach the next level of database tracking and reporting.Contents and OverviewThrough 57 lectures and over 9-hours of content, this course will take you through learning how to use functions in everyday work environments. Professional financial functions are covered including payments, future value and depreciation. Students will learn statistical functions like averages, percentiles, and regression.In order to improve efficiency, students will also cover concepts for connecting to external data like other workbooks or web data; tables including style, selection and sizing. Pivot tables and data analysis will be key concepts helpful to the work environment.For help with reporting, students will learn surface charts, stock charts, radar charts and bubble charts and graphs.Upon completion of this course, students will be able to create colorful charts and databases that communicate data and financial records efficiently and effectively. Students will be able to apply data to various reporting forms like tables, graphs and pivot tables in order to show important analysis like depreciation, percentiles and regression for use with planning. Students who finish this course will have an advanced knowledge of the versatility of Excel that is immediately applicable to their work with the database. ** Updated July 2017. English close captions added** Updated June 2017. Course transcripts now available.Here's what our students are saying…"This is an excellently pieced together information. Beautifully explained with lots of examples and external resource areas for the nerds. I highly recommend this course for anyone whose intention is to learn Excel." - Frank Uchegbu"Greatly explained and great zoom in of the working area."- Jorge Tech"Very detail and advance. The exercise and solution sheets help greatly in understanding and familiarisation of the lessons. Highly recommended for users getting to know Excel in details."- John ChanDid you know?Simon Sez IT teaches all sorts of software, including:- Microsoft Excel- Microsoft PowerPoint- Microsoft Word- Microsoft Project- Microsoft Outlook- QuickBooks- Photoshop Elements- Web Development Languages- And so much more!Just search "Simon Sez IT" to see our full list of individual courses and incredible value multi-course bundles on Udemy.
