|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-beginner-to-advanced-bundle-2013-2019/
课程评论：没有评论
课程名称：终极Excel初学者到高级捆绑课程 概述：本课程包括实践练习和终身访问，现已包括Excel 2019。由Excel专家Simon Sez IT提供，课程涵盖所有Excel用户从初学者到高级用户所需的知识。课程针对2013、2016和2019版本，您可以选择学习相应的版本。 **Excel初学者部分**：此部分适合全新接触Excel的用户或从旧版升级的用户。内容包括： - Excel的新功能 - 创建工作簿 - 输入文本、数字及日期处理 - 工作簿导航 - 页面设置及打印选项 - 行、列及单元格操作 - 剪切、复制和粘贴 - 函数和公式基础 - Excel格式化，包括单元格和数字格式 - 制作图表和图形 - 排序与筛选 - 透视表基础 - 逻辑和查找函数基础 **Excel高级部分**：这一部分进行更深入的学习，关注财务信息的整合、分析和报告。内容包括： - 高级图表和图形制作 - 使用详细的格式工具 - 查找和高级查找函数 - 财务函数，如计算利息和折旧 - 统计函数 - 连接其他工作簿和数据集 - 创建数据条和微型图的可视化效果 - 精通透视表和透视图 - 情景管理器、目标求解与求解器 - 高级图表制作，如表面图、雷达图、气泡图和股票图（视版本而定） **课程内容与附加信息**： 本捆绑课程包括七个部分，提供丰富的学习资源： - Excel 2019 初学者：95个视频，时长7.5小时 - Excel 2019 高级：57个视频，时长8小时 - Excel 2016 初学者：65个视频，时长9小时 - Excel 2016 中级：39个视频，时长4.5小时 - Excel 2016 高级：57个视频，时长9小时 - Excel 2013 初学者：54个视频，时长10小时 - Excel 2013 高级：47个视频，时长9小时 - 所有课程均附有练习文件和结业证书 **课程总结**： 此Excel综合大捆绑课程旨在满足所有Excel用户的需求。无论您是全新入门的用户，还是希望掌握更高技能的用户，这个课程都能助您提升Excel使用能力。完成课程后，您将在Excel公式和函数方面有扎实的基础，能够有效使用和共享电子表格，制作直观的图表，提升职场能力。 课程评价： 学生反馈积极，如工程学生表示此课程涵盖了专业优化工具的所有教程，另一位学生称课程帮助他顺利完成了大学作业。 基于以上内容，Simon Sez IT还教授多种软件工具，包括Microsoft Excel、PowerPoint、Word、Project、Outlook、QuickBooks、Photoshop Elements及Web开发语言等。
**This course includes practice exercises and LIFETIME access** **Excel 2019 now included**Everything you need to become a spreadsheet guru in Microsoft Excel from Beginner to Advanced users by Excel experts Simon Sez IT. Separate lessons for 2013, 2016, and 2019, pick your version!Excel for BeginnersWith this Microsoft Excel beginners course, you'll gain a fantastic grounding in Microsoft Excel. This in-depth course is perfect for those brand new to Excel and who are using Excel 2013, 2016, 2019 or Excel 365 editions. This course is perfect if you're brand new to Excel or are upgrading from an older version.What You'll LearnWhat's new in ExcelCreating workbooksEntering text, numbers and working with datesNavigating workbooksPage setup and print optionsWorking with rows, columns and cellsCut, Copy and PasteIntroduction to functions and formulasFormatting in Excel, including formatting cells and numbersCreating charts and graphsSorting and FilteringIntroduction to PivotTablesLogical and lookup formulas - the basicsAdvanced ExcelWith this comprehensive, 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 LearnAdvanced 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 (version dependent!)***Exercise files included with all courses***BONUS: Excel 2016 Intermediate now included!This 7-course bundle includes:Excel 2019 Beginners: 95 Videos, 7.5 HoursExcel 2019 Advanced: 57 Videos, 8 HoursExcel 2016 Beginners: 65 Videos, 9 HoursExcel 2016 Intermediate: 39 Videos, 4.5 HoursExcel 2016 Advanced: 57 Videos, 9 HoursExcel 2013 Beginners: 54 Videos, 10 HoursExcel 2013 Advanced: 47 Videos, 9 HoursAnd if that wasn't enough. You also get:Exercise files to practice what you learnedCertificates of completionSummaryThis Excel mega bundle is designed for students of all Excel capabilities. If you are brand new to Microsoft Excel or who are upgrading from a previous version and want to keep up to date with Excel developments, then the start at the beginning.If you already have a good understanding of MS Excel then you might want to start in the Advanced section where the expert author will help you take your spreadsheeting skills to the next level.Multiple VersionsIf you're upgrading from an older version of Excel or know that an upgrade is around the corner, then this package is for you as it includes courses covering 2013, 2016 and 2019.OutcomesUpon completion of this course, you'll have a great grounding in Excel formulas and functions. You'll be confident in navigating, sharing and using spreadsheets in a variety of ways.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…"As an engineering student, i could say that this course covers the whole tutorials about optimization tools for professionals."- Uayur Uygun"The course provided a detailed view of all the new features of excel 2019. The examples and exercises provided a great platform to develop and build on the knowledge I acquired over the course."- Peter Marshall"Well structured easy to follow content. This course helped me pass my college coursework at full distinction.:)"- Andrew Mcmaster"Did 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!
