|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-2019-advanced-course/
课程评论：没有评论
课程名称：掌握 Microsoft Excel 2019/365 - 高级 Excel 课程概述： 本课程包含实践练习和终身访问权限，旨在帮助学员超越基础知识，提升Excel技能。通过8小时的专家视频培训，学员将深入了解更高级的Excel功能，重点在财务信息的高水平整合、分析和报告。 您将学习： - Excel 2016的新特性 - 高级图表和图形创建 - 详细格式工具的使用 - 查找和高级查找函数 - 财务函数（如计算利息和折旧） - 统计函数 - 如何连接到其他工作簿和数据集（如 MS Access 和网页） - 使用数据条和火花线创建出色的可视化效果 - 掌握数据透视表和数据透视图 - 场景管理器、目标寻求和求解器 - 高级图表（如曲面图、雷达图、气泡图和库存图） 课程内容： - 8小时的视频教程 - 超过55节独立视频讲座 - 实践文件供学员应用所学知识 - 讲师使用的演示文件 - 完成证书 本课程针对已经具备良好Excel基础的学生，帮助他们进一步提升能力。通过57节讲座和超过8小时的内容，学员将学习最实用的高级函数和公式，包括财务和统计函数，如何最好地可视化数据，使用数据透视表和数据透视图，以及高级图表的创建。 完成此课程后，学员将能够创建有影响力的图表，从高效且有效地传达数据和财务记录的数据源处理数据。您将能够以多种格式报告数据，包括表格、图形和数据透视表。 学员反馈： 课程受到了学生们的好评，许多学员表示课程讲解清晰，同时配备了丰富的示例和外部资源，非常适合想要深入学习Excel的人士。 了解更多： Simon Sez IT还教授各种其他软件，包括Microsoft Excel、PowerPoint、Word、Project、Outlook、QuickBooks、Photoshop Elements及网络开发语言等。 这是一个提升个人职业能力的良好机会！
**This course includes practice exercises and LIFETIME access**Get beyond the basics and supercharge your current Excel skills.With this 8-hour, expert-led video training course, you'll gain an in-depth understanding of more advanced Excel features that delve into high-level consolidation, analysis and reporting of financial information.What You'll LearnWhat's new/different in Excel 2016Advanced charting and graphing in ExcelHow to use detailed formatting toolsLookup and advanced lookup functionsFinancial functions including calculating interest and depreciationStatistical functionsConnecting to other workbooks and datasets outside of Excel e.g. MS Access and the web.How to create awesome visualizations using sparklines and data barsMastery of PivotTables and Pivot ChartsScenario Manager, Goal Seek and SolverAdvanced charts such as Surface, Radar, Bubble and Stock Charts***Exercise and demo files included*** This course includes: 8-hours of video tutorialsOver 55 individual video lectures Exercise files to practice what you learnedDemo files used by the trainerCertificate of completionThis course is designed for students that already have a good understanding of Microsoft Excel and are looking to take their capabilities to the next level. Contents and OverviewThrough 57 lectures and over 8-hours of content, this course will take you through learning how to use the most business-relevant advanced functions and formulas you might need. This includes:Financial functions (interest depreciation etc.)Statistical functionsHow to best visualize your data using PivotTables and Pivot ChartsAdvanced chartingAnd so much more...Upon completion of this course, you'll be able to create charts that have an impact from databases that communicate data and financial records efficiently and effectively. You will be able to report data in various formats including: tables, graphs and PivotTables. Once completed you'll have advanced understanding of Excel that will positively impact your professional capability.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★★★★★ "Everything is thoroughly explained in a clear and concise way, starting from the very beginning so that anyone without any prior knowledge of the programme can easily follow the explanations. I would recommend this course to anyone that would like to get started on learning Excel or reinforce the basics of using the software, since this course covers concepts that can be useful to anyone without any prior training."- Blanca EstabanDid 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!
