|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-excel-for-data-analysts-t/
课程评论：没有评论
课程名称：微软Excel数据分析师课程 课程概述：Excel是全球最受欢迎的电子表格程序，适用于从简单的家庭预算维护到构建复杂的财务模型或设计复杂的仪表盘等多种场景。《通过Excel分析商业数据》课程将教您如何利用Excel的数据分析功能解决现实世界中的商业问题，而不仅仅是关注单个Excel功能和特性。该课程对来自各行各业及功能专业领域的参与者非常有用，例如管理信息系统、财务、市场营销、运营、人力资源、信息技术和行政管理等。通过互动式培训，本课程针对特定的商业情境，展示如何为这些问题领域创建电子表格。参加这一富有信息量和实用性的课程将有助于提高您的工作效率，提升报告的质量和准确性。 本课程适合希望在Microsoft Excel 2013中掌握高级技能的最终用户或希望获得Microsoft Office Specialist (MOS) Excel 2013认证的学员。在课程中，我们将涵盖多个与Microsoft Excel 2013相关的主题，包括：如何在工作表中导航、理解单元格引用、Excel保护功能、常用函数、条件结构的处理（如If函数）、嵌套条件、创建多系列图表、查找函数等。所有这些概念都通过实践视频讲座进行简要讲解。此外，您将在课程中获得模拟练习考试、练习、附加材料和数据集的访问，这对于了解这些工具和技术在实际场景中的应用非常有帮助。
Excel is by far the world's most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial, models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel's data analysis features to the maximum, rather than focusing on individual Excel functions and features.This course would be very useful to participants across various industries and functional specializations such as MIS, Finance, Marketing, Operations, Human Relations, Information Technology and Administration.This interactive training targets specific business situations and then demonstrates how to create spreadsheets for those problem areas. Attend these extraordinary, information-packed, powerful sessions to increase your productivity, improve the quality, accuracy & make a better report.This course is recommended for end users seeking proficiency in the use of Microsoft Excel 2013 at an advanced level or seeking to obtain Microsoft Office Specialist (MOS) certification in Microsoft Excel 2013.In this course, we will cover the various topics about the Microsoft Excel 2013 such as: How to navigate through worksheets and understanding cell referencesExcel protection FeaturesFrequently used functions in ExcelHow to handle conditional structures using If functions.Nested if conditionsHow to create multiple series chart.Lookup FunctionsThe above all concepts are explained briefly in the hands-on video lectures. In this course, you can also get access to the Simulated practice exams, exercises, additonal materials and data sets which is very useful to know how these tools and techniques are applicable in the real time scenarios.
