Member since 2023
Google Sheets - Advanced Topics
Earned Jan 29, 2024 EST
[DEPRECATED] Google Sheets
Earned Jan 26, 2024 EST
Google Meet 內建 Gemini
Earned Jan 19, 2024 EST
Google 試算表內建 Gemini
Earned Jan 19, 2024 EST
Google 簡報內建 Gemini
Earned Jan 19, 2024 EST
Google 文件內建 Gemini
Earned Jan 19, 2024 EST
Gmail 內建 Gemini
Earned Dec 7, 2023 EST
Google Workspace with Gemini：AI 工作流程的基礎
Earned Dec 7, 2023 EST
This course builds on some of the concepts covered in the earlier Google Sheets course. In this course, you will learn how to apply and customize themes In Google Sheets, and explore conditional formatting options. You will learn about some of Google Sheets’ advanced formulas and functions. You will explore how to create formulas using functions, and you will also learn how to reference and validate your data in a Google Sheet. Spreadsheets can hold millions of numbers, formulas, and text. Making sense of all of that data can be difficult without a summary or visualization. This course explores the data visualization options in Google Sheets, such as charts and pivot tables. Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. You will explore how Forms and Sheets work together by connecting collected Form data to a spreadsheet, or by creating a Form from an existing spreadsheet.
In this course we will introduce you to Google Sheets, Google’s cloud-based spreadsheet software, included with Google Workspace. With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required. Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically. You will learn how to open Google Sheets, create a blank spreadsheet, and create a spreadsheet from a template. You will add, import, sort, filter and format your data using Google Sheets and learn how to work across different file types. Formulas and functions allow you to make quick calculations and better use your data. We will look at creating a basic formula, using functions, and referencing data. You will also learn how to add a chart to your spreadsheet. Google Sheets spreadsheets are easy to share. We will look at the different ways you can share with others. We will also discuss how to track changes…
本課程將介紹如何使用 Google Meet 內建 Gemini，提升視訊協作體驗。內容包括如何自動做筆記、使用即時文字和語音翻譯、私下補上錯過的討論內容，以及立即提升音訊和視訊品質。
本課程將說明如何使用 Google 試算表內建 Gemini，自動整理資料及處理複雜數字。瞭解如何從原始文字建立表格、使用自然語言自動填入資料、依需求生成原生試算表公式，以及快速擷取高階洞察資訊或製作圖表，完全不需要具備進階試算表專業知識。
本課程將介紹如何使用 Google 簡報內建 Gemini，將概念轉化為吸睛的簡報。瞭解如何透過單一提示詞或現有來源文件生成結構化簡報、使用自動設計強化功能調整投影片版面配置、建立自訂向量圖形和相片，以及動態製作投影片文案和精確的演講者備忘稿。
本課程將說明如何使用 Google 文件內建 Gemini 簡化寫作和內容創作流程。瞭解如何從頭撰寫文件、使用互動式工具調整寫作語氣和提升清晰度、總結複雜檔案，以及將長篇文字順暢轉換為結構化資產，供其他 Google Workspace 應用程式使用。
本課程將說明如何使用 Gmail 內建 Gemini，提升電子郵件管理效率。瞭解如何直接在收件匣中總結冗長的討論串、使用自然語言擷取資訊、草擬專業回覆，以及制定溝通策略。
客戶能透過 Gemini for Google Workspace 在 Google Workspace 使用生成式 AI 功能。本學習路徑會介紹 Gemini 的主要功能，並說明如何在 Google Workspace 善用這些功能，提高生產力和效率。