|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/excel-basics-data-analysis-ibm
课程评论：没有评论
课程名称：Excel数据分析基础 课程概述：本课程旨在为您提供使用Excel电子表格进行数据分析的基本工作知识。课程覆盖了使用电子表格的第一步以及它们在数据分析过程中的应用。课程中包含大量视频、演示和示例供您学习，并提供逐步说明以让您在实时电子表格上进行应用和实践。Excel是处理数据的基本工具，适用于商业、市场营销、数据分析或研究。该课程适合有意从事数据分析或数据科学的专业人士，以及希望在自己领域使用Excel进行数据分析的学习者。您将获得使用函数清洗和整理数据的宝贵经验，并使用筛选、排序和创建数据透视表等技术对数据进行分析。 课程开始时将介绍Microsoft Excel和Google Sheets以及如何从多种格式加载数据。在了解基础后，您将学习执行一些基本数据整理和清洗任务，并通过使用筛选、排序和数据透视表扩大您的数据分析知识。通过整个课程的实践，您将理解电子表格作为数据分析工具的使用及其局限性。 本课程强调实践和应用学习。通过每次实验，您将获得数据操作的实际经验，理解电子表格的重要作用。您将学习如何通过理解数据格式中的函数更快速地清洗和分析数据，然后将数据转换为数据透视表，并学习其特性使您的数据更有条理和可读。最终项目将使您展示新获得的数据分析技能。到课程结束时，您将与多个数据集和电子表格进行工作，并展示数据清洗和分析的基础技巧，无需学习任何编码。 本课程使得开始使用Excel变得简单。您无需有电子表格或编码的先前经验，也无需下载或安装任何软件。您只需具备带有现代网页浏览器的设备，以及创建一个微软账户以免费访问Excel在线的能力。如果您已经拥有Excel的桌面版本，也可以轻松跟随课程进度。 课程大纲： 1. 数据分析基础知识：学习电子表格应用的基本原理，了解Excel界面及工作表和工作簿的导航。 2. 开始使用Excel电子表格：学习基本的电子表格任务，包括查看、输入和编辑数据，移动、复制和填充数据，基础公式和最常用功能的引用。 3. 使用电子表格清洗和整理数据：了解数据质量的重要性，如何将文件数据导入Excel，数据隐私基础，去除重复和不准确的数据，处理数据不一致性，以及使用Flash Fill和Text to Columns功能。 4. 使用电子表格分析数据：学习数据分析基础，如何筛选和排序数据，使用数据分析师常用函数，以及如何创建数据透视表及其功能。 5. 最终项目：完成所有四个模块后，通过一个实践实验完成数据清洗、准备及分析的评分作业。此最终作业将由同伴评分。
Name:Introduction to Data Analysis Using Spreadsheets
Description:In this module, you will learn about the fundamentals of spreadsheet applications, and you will be introduced to the Excel interface and learn how to navigate your way around a worksheet and workbook.
Name:Getting Started with Using Excel Spreadsheets
Description:In this module you will learn how to perform basic spreadsheet tasks, such as viewing, entering and editing data, and moving, copying and filling data. In addition, you will learn about the fundamentals of formulas, and learn about the most common functions used by a data analyst. Finally, you will learn how to reference data in formulas.
Name:Cleaning & Wrangling Data Using Spreadsheets
Description:In this module, you will learn about the importance of data quality, and you will learn how to import file data in to Excel. You will also learn about the fundamentals of data privacy. In addition, you will learn how to remove duplicate and inaccurate data, and how to remove empty rows in your data. Finally, you will learn how to deal with inconsistencies in your data and how to use the Flash Fill and Text to Columns features to help you manipulate and standardize your data.
Name:Analyzing Data Using Spreadsheets
Description:In this module, you will learn about the fundamentals of analyzing data using a spreadsheet, and learn how to filter and sort data. You will also learn how to use some of the most useful functions for a data analyst, and how to use the VLOOKUP and HLOOKUP reference functions. In addition, you will learn how to create pivot tables in Excel, and use several pivot table features.
Name:Final Project
Description:Great! You have now completed all four modules of this course. In this final module, you will be introduced to a hands-on lab where you will complete a graded assignment for cleaning and preparing data, and then analyzing data using an Excel spreadsheet. This final assignment will be graded by your peers.
This course is designed to provide you with basic working knowledge for using Excel spreadsheets for Data Analysis. It covers some of the first steps for working with spreadsheets and their usage in the process of analyzing data. It includes plenty of videos, demos, and examples for you to learn, followed by step-by-step instructions for you to apply and practice on a live spreadsheet. Excel is an essential tool for working with data - whether for business, marketing, data analytics, or research. This course is suitable for those aspiring to take up Data Analysis or Data Science as a profession, as well as those who just want to use Excel for data analysis in their own domains. You will gain valuable experience in cleansing and wrangling data using functions and then analyze your data using techniques like filtering, sorting and creating pivot tables. This course starts with an introduction to spreadsheets like Microsoft Excel and Google Sheets and loading data from multiple formats. With this introduction you will then learn to perform some basic level data wrangling and cleansing tasks and continue to expand your knowledge of analyzing data through the use of filtering, sorting, and using pivot tables within the spreadsheet. By performing these tasks throughout the course, it will give you an understanding of how spreadsheets can be used as a data analysis tool and understand its limitations. There is a strong focus on practice and applied learning in this course. With each lab, you will gain hands-on experience in manipulating data and begin to understand the important role of spreadsheets. Clean and analyze your data faster by understanding functions in the formatting of data. You will then convert your data to a pivot table and learn its features to make your data organized and readable. The final project enables you to show off your newly acquired data analysis skills. By the end of this course you will have worked with several data sets and spreadsheets and demonstrated the basics of cleaning and analyzing data all without having to learn any code. Getting started with Excel is made easy in this course. It does not require any prior experience with spreadsheets or coding. Nor does it require downloads or installation of any software. All you need is a device with a modern web browser, and ability to create a Microsoft account to access Excel online at no-cost. However if you already have a desktop version of Excel, you can follow along quite easily as well.
