|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/excel-essentials
课程评论：没有评论
课程名称：商业中的Excel技能：基础知识 课程概述： 在这门Excel技能系列课程的第一门课中，您将学习Microsoft Excel的基础知识。在六周的学习中，您将能够熟练导航Excel用户界面，使用公式和函数进行基本计算，专业格式化电子表格，并通过图表和图形创建数据可视化。无论您是自学成才并希望填补知识空白以提高效率和生产力，还是从未使用过Excel的新手，此课程都将为您奠定坚实的基础，让您成为一名自信的Excel用户，并为后续课程的发展更高级技能打下良好基础。 学习Excel的最佳方式就是使用Excel。在本课程中，学习者将通过解决各种商业问题，应用他们学习的Excel技能和技巧。课程中提供可下载的Excel工作簿和完整的数据集，以及实际案例和挑战练习，提供无数机会让学习者在实践中提升Excel技能，同时发现Excel在多种商业环境中的新功能和实用技巧。 电子表格软件是全球工作场所中最常用的软件之一。自信地操作这类软件意味着为您的就业能力添砖加瓦。在数字技能职位快速增长的时代，通过将Excel技能添加到您的就业组合中，为自己在竞争中占得先机。 课程大纲： 1. Excel的关键核心：学习Excel的用户界面、基本术语、必备的导航控制以及如何进行基本数据输入。 2. 进行计算：了解公式的语法，学习如何编写和使用公式与函数进行计算，并理解不同的单元格引用。 3. 格式化：掌握各种格式化工具，如字体格式、边框、对齐方式、数字格式以及Excel样式和主题，以突出关键信息。 4. 数据处理：学习如何管理电子表格，使用筛选和排序找到数据，使用查找和替换检索和修改数据，并使用条件格式化突出特定数据。 5. 打印：学习如何优化电子表格的打印设置，包括边距、方向、页眉和页脚等。 6. 图表：学习创建和修改图表，这是展示数据视觉化的常见方式。 7. 期末评估 该课程将帮助您建立深入的Excel基础，为今后的职业发展提供支持。
Name:Critical Core of Excel
Description:In this module, you will learn about key foundational features of Excel: The Excel user interface, basic Excel terminology, how to operate essential navigational controls in Excel and how to perform basic data entry with Excel spreadsheets.
Name:Performing calculations
Description:The syntax of formulas is very important in Excel. In this module, you will get introduced to formulas and functions - learn how to write them, use them to perform calculations and understand the different cell references.
Name:Formatting
Description:Formatting helps to highlight key messages and make the data presentable. This module covers several formatting tools like font formatting, borders, alignment, number formatting, as well as the Excel styles and themes.
Name:Working with Data
Description:This module is all about working with data – and making it easy to work with. This week you will learn how you can manage your spreadsheets – find data with Filter and Sort, retrieve and change data using Find and Replace, and use Conditional Formatting to highlight specific data.
Name:Printing
Description:Sometimes you need to print your spreadsheets and this module will help you with that. Learn how you can optimise your spreadsheet for printing by managing margins, orientation, headers & footers, and more.
Name:Charts
Description:Charts are one of the most common ways to present data visually. This module walks you through creating and modifying charts in Excel.
Name:Final Assessment
Description:
In this first course of the specialization Excel Skills for Business, you will learn the essentials of Microsoft Excel. Within six weeks, you will be able to expertly navigate the Excel user interface, perform basic calculations with formulas and functions, professionally format spreadsheets, and create visualizations of data through charts and graphs. Whether you are self-taught and want to fill in the gaps for better efficiency and productivity, or whether you have never used Excel before, this course will set you up with a solid foundation to become a confident user and develop more advanced skills in later courses. The best way to learn Excel is to use Excel. In this course, learners will solve a broad range of business problems as they apply the Excel skills and techniques they learn along the way. This course uses downloadable Excel workbooks and full data sets with applied examples and practical challenge exercises. This provides learners with countless opportunities to practice their Excel skills while discovering new and useful productivity features of Excel for a variety of business contexts. Spreadsheet software is one of the most ubiquitous pieces of software used in workplaces across the world. Learning to confidently operate this software means adding a highly valuable asset to your employability portfolio. At a time when digital skills jobs are growing much faster than non-digital jobs, make sure to position yourself ahead of the rest by adding Excel skills to your employment portfolio.
