Julian David Prieto Alape
Member since 2026
Member since 2026
完成在 Google 試算表使用函式、公式及圖表技能徽章中階課程, 即可證明您具備下列技能:運用函式分析資料、使用圖表呈現資料、設定資料格式,以及搜尋、 驗證與顯示資料。
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 Drive is Google’s cloud-based file storage service. Google Drive lets you keep all your work in one place, view different file formats without the need for additional software, and access your files from any device. In this course, you will learn how to navigate your Google Drive. You will learn how to upload files and folders and how to work across file types. You will also learn how you can easily view, arrange, organize, modify, and remove files in Google Drive. Google Drive includes shared drives. You can use shared drives to store, search, and access files with a team. You will learn how to create a new shared drive, add and manage members, and manage the shared drive content. Google Workspace is synonymous with collaboration and sharing. You will explore the sharing options available to you in Google Drive, and you will learn about the various collaborator roles and permissions that can be assigned. You’ll also explore ways to ensure consistency and save time…
完成「實現雲端協作與生產力工作流」課程,即可獲得入門級技能徽章。本課程將介紹 Google 的協作平台, 帶您瞭解如何使用 Gmail、日曆、Meet、雲端硬碟、試算表和 AppSheet。
In this video, you'll learn to use Gemini in Google Sheets for advanced data analysis. You'll learn how to create data visualizations, like a scatter plot, using a simple prompt. You'll also learn how to ask Gemini to analyze your data for strategic insights and recommendations, such as how to save money.
In this video, you'll learn to use Gemini in Google Sheets to automatically generate organized trackers from unstructured data. You'll learn how to write a prompt that references other Google Drive files using the "@" symbol. You'll also see how Gemini builds a fully formatted, color-coded table with drop-down menus based on the data in your notes, saving you significant manual effort.
這部影片說明如何使用 Gmail 內建 Gemini 管理 Google 日曆,包括在側邊面板詢問行程,以及一鍵將在電子郵件中偵測到的活動新增至日曆。
In this video, you'll learn to use Gemini in Google Slides to build polished presentations efficiently. You'll see how to create slides by referencing content directly from your Google Drive files using the "@" symbol. You'll also learn to generate custom, professional images from a simple text prompt to visually enhance your presentation.
這部影片說明如何使用 Google 試算表的「問問 Gemini」功能,透過簡單的自然語言指令,排序、篩選、醒目顯示及歸納資料。
In this video, you'll learn to use the =AI() function in Google Sheets to automate your work. You'll see how to generate text like slogans, summarize paragraphs of customer feedback, and categorize data by classifying inquiries and analyzing sentiment.
In this video, you'll learn to create "what if" scenarios using AI's reasoning. You'll see how to set a "before" scene with a person holding a cake, prompt an action by asking "what would happen if they tripped?", and let the AI generate the plausible "after" image of the cake falling.
這部影片介紹一項技巧,說明如何分別生成主體和場景,再使用最終提示詞將兩者融合成新圖片,藉此建立「混搭」圖片。
這部影片說明如何在 Gemini 應用程式中使用多輪遞進編輯功能,一步步建構場景,以及如何透過「重混」功能,將某個物件的風格轉移到另一個物件。
這部影片說明如何使用 Gemini 應用程式的新功能,創作保留本人樣貌的創意肖像,以及如何將多張相片合成一個全新的場景。
In this video, you'll learn to use NotebookLM to manage a large-scale research project. You'll see how to upload all your documents to get summaries, ask deeper strategic questions to find key insights, and use the audio feature to listen to your findings on the go.
In this video, you'll learn to use NotebookLM to analyze raw data and find compelling stories. You'll see how to ground the AI in your specific documents, prompt it to generate newsworthy PR claims, and ask it to find hidden correlations between different data points to uncover new insights.
這部影片說明如何使用 AI 助理規劃大型團隊活動,包括腦力激盪、後勤安排,以及分析活動後意見回饋。
這部影片介紹使用 Gemini Deep Research 的專家級提示,包括如何指派角色、指定輸出格式,以及引導搜尋以進行全面的競爭分析。
這部影片將說明如何使用 Gemini Deep Research 和精細的提示詞,取得綜合比較報告,自信做出複雜的購買決策。
這部影片說明如何在 Gemini Canvas 使用簡單的文字提示詞,將資料轉換成引人入勝的動態長條圖競賽圖表。
這部影片說明如何在 Gemini Canvas 中使用描述性文字提示詞,生成複雜的動畫視覺藝術,例如動態排版。
這部影片將說明如何建構及使用自訂 Gem (可重複使用的 AI 助理),將任何筆記和文章集合,立即轉換為結構化的研讀指南。
這部影片說明如何將個人筆記上傳至 Gemini Canvas,並使用簡單的提示詞,建立包含各種題型的互動式測驗。
這部影片介紹如何運用 Gemini Deep Research 自動執行競爭分析,並在幾分鐘內生成詳盡報告,全方位掌握競爭對手的行銷廣告活動。
這部影片說明如何在 Gemini Canvas 使用簡單的文字提示詞,建構及自訂個人化天氣應用程式的可運作原型。
這部影片說明如何在 Gemini Canvas 使用簡單的文字提示詞,建構互動式 3D 太陽系模擬,並加入教育功能。
這部影片說明如何建立自訂個人「公用程式」應用程式 (例如番茄鐘計時器),只要在 Gemini Canvas 中輸入簡單提示詞,描述功能和設計即可。
這部影片說明如何使用 Gemini 的引導式學習功能。Gemini 是 AI 協作夥伴,可透過問題和互動式工具,幫助您深入理解。
這部影片說明如何在 Gemini Canvas 中使用簡單的提示詞,建構、自訂及分享可玩的遊戲,例如井字遊戲。
這部影片說明如何在 Gemini Canvas 中使用簡單的文字提示詞,打造一台具備自訂控制項和可彈奏鍵盤的全互動式音樂合成器。
這部影片將說明如何使用 Gemini Deep Research 和創意提示詞,將複雜資訊轉化為有趣的個人化分析,例如運動球探報告和對戰表。
這部影片將說明如何使用 Gemini Canvas 的「建立」選單,將大篇幅文字立即轉換成資訊圖表和網頁等視覺素材。
這部影片說明如何使用 Gemini Canvas,透過「直覺式程式開發」技術,將簡單的應用程式繪圖轉化為可運作的原型。
This video covers how NotebookLM's Reports feature dynamically suggests formats to help you create customized, trustworthy analyses of your documents with ease.
這部影片說明如何使用 Gemini Gem 建構個人化的「工作夥伴」代理,簡化基本意見回饋,讓會議更具策略性且更有效率。
這部影片將說明如何使用 Gemini Advanced 研究主題、製作簡報大綱,以及使用 Google 文件內建 Gemini 生成談話要點。
This video covers how to create a 'project notebook' in NotebookLM by adding all relevant sources to build a central, searchable knowledge hub for your team.
This video covers how to use NotebookLM for common marketing tasks like analyzing customer feedback, conducting market research, and generating content ideas.
This video covers how to use the Video Overviews feature in NotebookLM to automatically generate a short explainer video based on your source documents.
This video covers how to use the 'Discover Sources' feature in NotebookLM to find and import relevant web-based sources directly into your research project.
This video covers how to use the Mind Maps feature in NotebookLM to automatically create a visual representation of your sources, helping you understand connections and key concepts.
This video covers how to use NotebookLM as a personal research assistant by adding sources, asking questions, and generating new content formats based on your documents.
這部影片說明如何使用 Gmail 內建 Gemini 撰寫新郵件草稿、調整語氣、根據雲端硬碟檔案內容回覆,以及使用智慧回覆建議。
這部影片說明如何使用 Google 文件中的「幫我建立」功能。這項功能會參考雲端硬碟中其他檔案的內容,生成已設定格式的完整文件。
This video covers five key ways to use Google's AI tools, including Gemini in Workspace, the Gemini app, and NotebookLM, to enhance your daily productivity.
這部影片說明如何使用 Gmail 內建 Gemini 歸納電子郵件重點、尋找資訊及草擬回覆,更有效率地管理收件匣。
這部影片說明如何使用 Google 簡報內建 Gemini,自動生成會議回顧並草擬後續追蹤電子郵件,協助簡化會後流程並節省時間。
這部影片將說明如何運用 Google 試算表中的 Gemini 進階 AI 功能,在幾分鐘內輕鬆提取資料並生成洞察,完全不需要任何技術或程式設計背景。
這部影片將說明如何運用 Gemini Gem,以主管獨特的口吻撰寫真實自然的社群媒體貼文。瞭解如何運用寫作範例和明確指令訓練 Gem,克服擴大高階主管社群媒體影響力的難題。瞭解如何快速生成引人入勝的貼文,在節省時間的同時,強化思維領導力並確保真實性。
這部影片將說明如何建立自己的 Brevity Gem,將雜亂的筆記或長篇文件轉化為簡潔明瞭的內容提要,方便高階主管查看。
這部影片說明如何使用 Gemini 和 Apps Script,在 Google Workspace 中自動執行手動工作。您將學習如何提示 Gemini 生成 Apps Script 程式碼,在 Google 試算表中針對未標示為「完成」的工作,自動草擬電子郵件提醒。即使幾乎沒有技術專業知識,也能自動化工作流程,省下時間處理更重要的工作,不必再手動後續追蹤。
This video covers how you can leverage Notebook LM to "eat the frog" on your to-do list by automating complex tasks like summarizing legislation and mapping services, saving you hours of work.
這部影片將說明如何運用 Gemini 消除繁瑣的手動資料輸入作業。瞭解如何拍攝資料相片或螢幕截圖 (來自 PDF、紙本或圖片),並提示 Gemini 立即將資料轉換為結構化的 Google 試算表。瞭解這個簡單的訣竅,省下無數轉錄資料的時間,讓 Gemini 成為您的個人資料輸入助理。只要拍照、輸入提示,然後匯出即可!
這部影片將說明如何運用 AI 找出策略中的弱點和隱藏假設。您將學到「找出漏洞」法,也就是透過 AI 提示詞,輕鬆對計畫進行壓力測試,找出漏洞並強化策略思維。
This video will cover how to use NotebookLM to gather and analyze publicly available information, combine it with internal documents, and extract key competitive insights.
這部影片說明如何在 Google Workspace 中,打造個人化 Gemini 搜尋結果。可瞭解如何使用「@」符號,將文件和研究論文直接納入提示,取得更符合需求的 AI 輸出內容。
這部影片將說明如何使用 Gemini 重點摘要 Google Workspace 中的長篇文件,助您快速取得所需資訊並節省時間。您將瞭解如何使用 Gemini 摘要整份文件或所選文字,以及如何使用 雲端硬碟內建 Gemini 總結多個檔案。
這部影片介紹提示工程的基本概念,協助您與 AI 有效互動。學習簡單的框架 (角色、任務、情境、格式),撰寫清晰的提示詞,讓 Gemini in Google Workspace 更快提供更優質的結果。瞭解如何使用自然語言、具體說明需求,以及透過反覆調整來獲得最佳 AI 輔助。
這部影片將說明如何運用 Gemini 版 Google 文件的進階 AI 功能,發想點子、草擬各種行銷內容,並與團隊順暢協作。
This video covers how NotebookLM can revolutionize customer insight gathering from call or chat transcripts. You'll learn to upload PDF transcripts of hundreds of conversations (even multilingual ones!) and quickly extract key themes, trending topics, and actionable insights without listening for hours. Discover how to save findings, share notebooks, and even generate interactive podcast summaries of your data.
這部影片說明如何建立專屬的 Gemini Gem,運用進階 AI 功能自動處理重複性工作,大幅提升工作效率。
在本課程中,您將透過實際操作,瞭解如何在 Looker 應用進階 LookerML 概念。您將學習如何使用 Liquid 自訂和建立動態維度 和測量指標、建構動態 SQL 衍生資料表和自訂的原生衍生資料表, 並運用擴充參數將 LookML 程式碼模組化。
This course empowers you to develop scalable, performant LookML (Looker Modeling Language) models that provide your business users with the standardized, ready-to-use data that they need to answer their questions. Upon completing this course, you will be able to start building and maintaining LookML models to curate and manage data in your organization’s Looker instance.
本課程介紹 Gemini Enterprise,這個強大的平台結合 AI 代理、企業搜尋功能、Gemini Notebook 和智慧資料存取權,可協助組織解決營運難題。學員將透過實際案例和練習,瞭解 Gemini Enterprise 功能如何滿足實際業務需求、描述其架構,以及此平台如何管理不同職務的資料存取與隱私權事宜。
隨著企業持續擴大使用人工智慧和機器學習,以負責任的方式發展相關技術也日益重要。對許多企業來說,談論負責任的 AI 技術可能不難,如何付諸實行才是真正的挑戰。如要瞭解如何在機構中導入負責任的 AI 技術,本課程絕對能助您一臂之力。 您可以從中瞭解 Google Cloud 目前採取的策略、最佳做法和經驗談,協助貴機構奠定良好基礎,實踐負責任的 AI 技術。
這個入門微學習課程主要介紹「負責任的 AI 技術」和其重要性,以及 Google 如何在自家產品中導入這項技術。本課程也會說明 Google 的 7 個 AI 開發原則。
這是一堂入門級的微學習課程,旨在探討大型語言模型 (LLM) 的定義和用途,並說明如何調整提示來提高 LLM 成效。此外,也會介紹多項 Google 工具,協助您自行開發生成式 AI 應用程式。
這個入門微學習課程主要說明生成式 AI 的定義和使用方式,以及此 AI 與傳統機器學習方法的差異。本課程也會介紹各項 Google 工具,協助您開發自己的生成式 AI 應用程式。
「生成式 AI:不只是聊天機器人」是 Gen AI Leader 學習路徑的第一門課程,沒有先修條件。本課程旨在帶領您超越對聊天機器人的基本認識,探索生成式 AI 能為貴組織帶來的真正潛力。您將瞭解基礎模型和提示工程等概念,這些都是發揮生成式 AI 威力的關鍵。本課程也會引導您思考重要事項,協助您為貴組織制定成功的生成式 AI 策略。
在本課程中,您將實際操作 Looker 的 LookML。您將學習如何編寫 LookML 程式碼,建立新的維度和測量指標、建立衍生資料表並彙整至探索、篩選探索,以及在 LookML 中定義快取政策。
In this course, you learn how to do the kind of data exploration and analysis in Looker that would formerly be done primarily by SQL developers or analysts. Upon completion of this course, you will be able to leverage Looker's modern analytics platform to find and explore relevant content in your organization’s Looker instance, ask questions of your data, create new metrics as needed, and build and share visualizations and dashboards to facilitate data-driven decision making.
本課程介紹 AI 代理的基礎知識,並探討代理的實際應用價值。代理可為開發人員、架構師和技術決策者奠定基礎,協助他們從目標導向的自主行為角度來理解 AI 系統。
瞭解 AI 代理的概念,探索代理如何藉由自主行動及推論解決複雜問題。您將瞭解代理如何透過模型、工具和調度管理程序等技術架構,助您學習、規劃和實現目標。