|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/google-sheets-online-training/
课程评论：没有评论
**课程名称：** Google Sheets 认证培训 **课程概述：** 本课程由 Uplatz 提供，旨在帮助学员全面掌握 Google Sheets 的使用。Google Sheets 是 Google 办公套件中的电子表格应用程序，专为敏捷型组织设计，集成了 AI 功能，能够提供有价值的见解以支持有意义的业务决策。其云原生架构支持随时随地与任何人进行协作，并且与 Microsoft Office 等外部系统兼容，消除了处理多数据源的摩擦。基于 Google 的基础设施，Sheets 提供了创建出色电子表格的灵活性，同时保障信息安全。 与 Microsoft Excel 相比，Google Sheets 正被越来越多的公司采用，其主要优势在于能够与多人共享，并且免费、浏览器即可使用，无需安装软件或购买许可。 本课程适合零基础学员，将引导您了解 Google Sheets 的基础知识，并通过实践情境创建和管理电子表格。您将深入学习各项核心功能，理解它们如何以交互式和图形化的方式协同工作。课程详细演示了函数的使用、数据透视表的构建、图表的创建、格式设置、筛选、排序、AI 驱动的动态函数以及实时数据分析等。 **核心课程主题：** * Google Sheets 介绍 * 创建新表格、命名表格、上传 Excel 文件 * 编辑单元格、自动填充、格式设置（单元格、文本、数字） * 基础公式与函数（求和、公式复制） * 数据排序与筛选 * 文件管理（打开、移动、保存，添加/删除/重命名工作表） * 基本格式设置（数字、日期、字体、颜色、格式刷） * 公式进阶（算术运算、运算符优先级、绝对引用、跨工作表计算） * 打印设置（打印区域、适应页面、PDF 打印、打印所有工作表） * 表格共享（选择共享对象、限制编辑、阻止下载与打印） **课程大纲（部分）：** * 菜单选项详解（文件、编辑、视图、插入、格式、数据等） * 数据输入与筛选 * 函数：数值函数、文本函数、日期函数 * 图表与条件格式 * 数据透视表 * 保存、共享与协作 **课程目标：** * 熟练导航 Google Sheets * 掌握数据和信息的显示方式调整 * 快速轻松地编写公式 * 创建强大的计算 * 利用图表可视化数据 * 使用数据工具（排序、分组、筛选） * 学习 Google Sheets 的快捷键、技巧和窍门
A warm welcome to the Google Sheets course by Uplatz.Google Sheets is the spreadsheet application software available within Google's cloud-based office suite. Google Sheets has been designed with the needs of agile organizations in mind. AI features mean you can tap into the right insights to make meaningful business decisions. A cloud-based architecture enables you to collaborate with anyone, anytime, anywhere. Compatibility with external systems, including Microsoft Office, removes the friction of working with multiple data sources. Based on Google's infrastructure, Sheets provides the flexibility to create amazing spreadsheets while helping to keep your information secure.Google sheets is being used by more and more companies instead of Microsoft Excel. There are many advantages to using Google Sheets the main one being the ability to share a sheet with multiple users. It is free to use and works in a browser! So there is no need to install anything on your machine neither to buy any license.This Google Sheets training course by Uplatz will get you used to Google sheets and be able to create and manage it in practical situations even if you have never used spreadsheets before. The Google Sheets course will introduce you to the basics of creating spreadsheets using the free Google Sheets application. This course will teach you some of the essential features of Google Sheets and how they can be used to work together in an interactive and graphical way. You will be able to take a deep-dive into all the features and options available in Google Sheets. This Google Sheets training provides detailed demonstration on how to use functions, build pivot tables, charts, formatting, filtering, sorting, AI-based and dynamic functions, analyze data on the fly, and more in Google Sheets.Course Topics at high-levelAn Introduction to Google SheetsCreate a new Google SheetName a SpreadsheetUpload an Existing Excel SpreadsheetEdit CellsUse Auto-fillFormat CellsFormat Text and NumbersBasic Formulas and FunctionsUse the Sum functionCreate and Copy Formula using Auto-fillSort and Filter dataFinding your way around Google SheetsOpening FilesMove data from Excel Files to Google Sheets and vice-versaWhat about saving files?File ManagementAdding/Deleting WorksheetsRenaming WorksheetsBasic FormattingFormatting NumbersDealing with DatesChanging the TypefaceAdding more fontsAdding ColorsFormat PainterFormulas in Google SheetsBasic ArithmeticOperator PreferenceAbsolute ReferencesUsing FunctionsCalculating between WorksheetsPrinting Google SheetsSelecting a print areaFitting everything onto a pageCreating a PDFPrinting all sheetsSharing a Google SheetChoosing people to share withRestricting EditingPreventing others from downloaded and printingGoogle Sheets course curriculumIntroductionMenu Options - FileMenu Options - EditMenu Options - ViewMenu Options - InsertMenu Options - FormatMenu Options - Data and moreEntering Data and FilteringFunctions - Numeric FunctionFunctions - Text FunctionFunctions - Data FunctionsCharts and Conditional FormattingPivot TablesSaving, Sharing, CollaborationCourse ObjectivesLearn how to navigate around Google SheetsLearn how to adjust the way data and information are displayedLearn how to write formulas quickly and easilyLearn how to create powerful calculationsLearn how to visually represent your data with charts and graphsLearn how to use data tools like sorting, subtotaling, and filteringLearn Google sheets shortcuts, tips, tricks
