|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/microsoft-excel-work-smarter
课程评论：没有评论
课程名称：利用Microsoft Excel更高效地工作 课程概述： 本课程适合拥有一定Microsoft Windows使用经验的学习者，旨在提升其使用Microsoft Excel进行演示的技能。成功完成本课程的学习者应对Windows基础操作有所了解。虽然打印和使用网络浏览器的经验会有所帮助，但并非必需。掌握Microsoft Office产品的使用技能在任何专业环境中都是至关重要的。无论是想扩展技能以申请新职位、创业，还是发展个人技能，这门课程都是您理想的选择。 课程将介绍Microsoft强大且易于使用的电子表格程序，提供一整套组织、分析、展示和储存数据的工具。如果您已经熟悉Excel的基本功能，可以将技能提升到一个新高度。如果您是初学者，将有机会培养基本的Excel技能。 在本课程中，您将学会如何舒适地创建新电子表格、使用基本的公式和函数、美化电子表格并使其专业化，最后学习如何保存和打印电子表格。 课程结束时，您将能够创造高级公式、使用函数分析数据、使用数据透视表和函数分析数据、操作表格、使用图表可视化数据、处理图形对象以及增强工作簿功能。 本课程将帮助您为MO-200考试（Microsoft Excel及Excel 2019）做好准备。您将有机会展示创建和编辑多工作表工作簿的能力，并使用图形元素直观展示数据，还将展示您能够独立完成Excel主要功能的正确应用。 课程大纲： 1. 入门Excel：学习Excel的基本概念、界面布局及功能，开始创建工作簿并处理数据，了解如何修改工作簿、格式化数据、应用布局并准备打印。 2. 使用函数：深入掌握Excel的核心特性：函数和公式，学习如何在Excel中实现并使用公式与函数，使用排序和筛选工具，定义数据集，探索各种专业、文本和逻辑函数。 3. 组织和可视化数据：学习如何在Excel中整理和可视化数据，包括创建、格式化和修改表格和图表，管理大工作簿，使用数据透视表和切片器进行数据分析。 4. 高级Excel功能：尝试Excel的高级功能，包括自定义公式、校对和界面选项、应用条件格式，管理、增强和自动化大型工作簿，及导出数据与使用数据源。 5. 实践：实践使用Microsoft Excel。在这个项目中，您将运用之前模块所学知识，分析和展示销售数据，最后进行回顾和评论。 通过本课程，您将提升Excel技能，为今后的工作和学习打下坚实基础。
Name:Getting started with Excel
Description:In this module, you will get started with some entry-level basics in Microsoft Excel. By getting to know Excel, what it does, its interface, and general layout and features. You will get to start creating workbooks and working with data. Before exploring how to modify workbooks, format data, apply layout and prepare to print.
Name:Working with functions
Description:In this module, you will start working with Excel's core features: functions and formulas. You will learn how to implement and use formulas and functions with data in Excel. You will also learn how to use Sorting and Filtering tools, and define data sets by applying range names. Finally, you will explore an array of specialized, text, and logical functions that can boost your abilities in Excel.
Name:Organizing and visualizing data
Description:In this module, you will move on to how to organize and visualize data in Excel. You will learn all about tables and charts, how to create, format, and modify them to store organize and display data in the way that you need. You will also learn how to manage large workbooks. Finally, you will be introduced to analyzing data, using Excels pivot tables and slicers.
Name:Advanced Excel features
Description:In this module, you will have the opportunity to try out some of the Advanced features that Excel has to offer. These include customizing formulas, proofing, and interface options, as well as applying conditional formatting. How to customize, manage, enhance and automate large workbooks, and how to export data and use data sources.
Name:Honors: Hands-on practice using Microsoft Excel
Description:In this module, you will undertake a hands-on project with Microsoft Excel. In this project, you will use the knowledge and experience that you’ve gained from the previous modules by applying your spreadsheet skills to analyze and present sales data, before reviewing and leaving comments.
This course is intended for learners with some experience using Microsoft Windows, who are seeking to build presentation skills with Microsoft Excel. To be successful in this course you should have an understanding of the basics of using a Windows-based computer. Experience with printing and using a web browser are an asset, but not required. Knowing how to use Microsoft Office products is essential in any professional setting. Whether you want to expand your expertise to apply for a new role, start your own business, or simply develop a new personal skill this course is for you. This course will introduce you to Microsoft’s powerful and easy-to-use spreadsheet program, which provides you with an extensive set of tools to organize, analyze, present, and store data. If you are familiar with Excel’s basic features you can take your skills to the next level. If you are a beginner you will get the opportunity to develop basic Excel skills. In this course, you will become comfortable with creating a new spreadsheet, working with basic formulas and functions, making your spreadsheets look professional and presentable, and saving and printing a spreadsheet. By the end of this course, you will be comfortable creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks. This course will help you prepare for Exam MO-200: Microsoft Excel (Excel and Excel 2019). You will get opportunities to demonstrate the ability to create and edit a workbook with multiple sheets and use a graphic element to represent data visually. You will also show that you can apply the correct application of the principal features of Excel and complete tasks independently.
