|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/spreadsheet-excel-google-sheet/
课程评论：没有评论
**Coursera课程总结：电子表格 — Excel与Google Sheet（入门到进阶）** 本课程旨在帮助您从零基础到中级水平掌握电子表格软件，提升数据分析能力。您将学习如何使用Microsoft Excel和Google Sheet创建、处理、可视化和分析数据。 **核心内容:** * **Excel与Google Sheet环境介绍:** 熟悉两款主流电子表格软件的操作界面，掌握创建、保存和打开工作簿的方法。 * **数据处理与格式化:** 学习数据录入、单元格格式设置（包括日期和数字格式）、处理多工作表等技巧。 * **公式与函数入门:** 掌握基础的公式和函数使用，进行数据计算和逻辑判断。 * **工作表管理:** 学习如何重命名、插入、移动和引用工作表。 * **数据可视化:** 学习创建图表、图形以及使用SmartArt来直观展示数据。 * **数据分析:** 掌握数据排序、筛选以及使用数据透视表（Pivot Table）和数据透视图（Pivot Chart）进行高级数据分析。 **课程优势:** * **实用性强:** 教授行业内最常用的两款电子表格工具，助力职业发展。 * **循序渐进:** 从基础概念到高级功能，帮助学习者系统性地掌握知识。 * **广泛兼容:** Excel部分的教学内容兼容2010及以上所有版本。 通过本课程的学习，您将能够自信地应对工作中的数据处理需求，并为更深入的数据分析打下坚实基础。
Develop your Data Analysis Skills, learn how to create, manipulate, visualize and analyze data with Microsoft Excel & Google SheetSpreadsheet is one of the top office productive tools used in the business world today, it's also one of the top in-demand skills for jobs, professional or career excellence. This course is designed to take you from a beginner to an intermediate level when it comes to spreadsheet software.You will learn the environment of the top 2 spreadsheet software that is often used in the workspace today, with insights and skills on these top 2 spreadsheet software you will be able to deal with every other spreadsheet tool that comes your way.This course is divided into 2 major modules:1. Microsoft Excel SpreadsheetIn this module, you will learn how to organize, manipulate and analyze data with Microsoft Excel. The lectures in the Microsoft excel module are created with Microsoft Excel 2013 version, but with any version of Microsoft office from 2010 to the latest version will be able to follow through this course.2. Google SheetIn this Module, you will learn how to organize, manipulate and analyze data with Google Sheet.More Concepts and guides delivered in this course:Understanding the environment of Microsoft Excel and Google SheetHow to create, save, and open a workbook.Data entry, cell formatting, working with multiple worksheets andDiscover how to format dates and numbers.Discover the essentials of using formulas and functions.How to rename, insert, move, and reference an Excel worksheet.Discover how to create charts and graphsLearn practical methods to sort and filter your dataLearn visualize data with chart and SmartArtDiscover how to analyze data with a Pivot table and pivot chartAnd more
