[{"id":"65736","title":"コースの概要","description":"

このモジュールではアジェンダについて説明します。また、On the Rise と本コースで扱うビジネス上の課題を受講者に紹介します。

","steps":[{"id":"448067","prompt":null,"isOptional":true,"activities":[{"id":"440812","href":"/course_sessions/25512664/video/440812?locale=ja","isLocked":false,"duration":147000,"title":"コースの概要","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448068","prompt":null,"isOptional":true,"activities":[{"id":"440813","href":"/course_sessions/25512664/video/440813?locale=ja","isLocked":false,"duration":78000,"title":"アジェンダ","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65737","title":"Google スプレッドシートの高度な書式設定","description":"

Google スプレッドシートをカスタマイズしてデータを利用する際に役立つ高度な書式設定オプションが多数あります。このモジュールでは、テーマと条件付き書式のオプションを適用する方法について説明します。

","steps":[{"id":"448069","prompt":null,"isOptional":true,"activities":[{"id":"440814","href":"/course_sessions/25512664/video/440814?locale=ja","isLocked":false,"duration":114000,"title":"Google スプレッドシートの高度な書式設定","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448070","prompt":null,"isOptional":true,"activities":[{"id":"440815","href":"/course_sessions/25512664/video/440815?locale=ja","isLocked":false,"duration":108000,"title":"条件付き書式","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448071","prompt":null,"isOptional":true,"activities":[{"id":"440816","href":"/course_sessions/25512664/video/440816?locale=ja","isLocked":false,"duration":13000,"title":"アクティビティ 1 についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448072","prompt":null,"isOptional":true,"activities":[{"id":"440817","href":"/course_sessions/25512664/documents/440817?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 1 条件付き書式を Google スプレッドシートに適用する","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448073","prompt":null,"isOptional":false,"activities":[{"id":"440818","href":"/course_sessions/25512664/quizzes/440818?locale=ja","isLocked":false,"duration":600000,"title":"理解度チェック","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65738","title":"高度な数式と関数","description":"

数式と関数を使用すると、速やかな計算が可能になり、より効果的にデータを利用できます。Google スプレッドシートでは、他のスプレッドシートアプリケーションにある数式を数多くサポートしています。このモジュールでは、数式の作成、関数の使用、データの参照および検証について見ていきます。また、データセットの操作時に名前付き範囲を利用する方法についても説明します。

","steps":[{"id":"448074","prompt":null,"isOptional":true,"activities":[{"id":"440819","href":"/course_sessions/25512664/video/440819?locale=ja","isLocked":false,"duration":166000,"title":"高度な数式と関数","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448075","prompt":null,"isOptional":true,"activities":[{"id":"440820","href":"/course_sessions/25512664/video/440820?locale=ja","isLocked":false,"duration":247000,"title":"IF および IFS を使用したデータ分析","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448076","prompt":null,"isOptional":true,"activities":[{"id":"440821","href":"/course_sessions/25512664/video/440821?locale=ja","isLocked":false,"duration":11000,"title":"アクティビティ 2 についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448077","prompt":null,"isOptional":true,"activities":[{"id":"440822","href":"/course_sessions/25512664/documents/440822?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 2 Google スプレッドシートで IFS 関数を使用する","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448078","prompt":null,"isOptional":true,"activities":[{"id":"440823","href":"/course_sessions/25512664/video/440823?locale=ja","isLocked":false,"duration":206000,"title":"データ検証と名前付き範囲","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448079","prompt":null,"isOptional":true,"activities":[{"id":"440824","href":"/course_sessions/25512664/video/440824?locale=ja","isLocked":false,"duration":12000,"title":"アクティビティ 3 についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448080","prompt":null,"isOptional":true,"activities":[{"id":"440825","href":"/course_sessions/25512664/documents/440825?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 3 データ検証規則を作成して、範囲に名前を付ける","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448081","prompt":null,"isOptional":false,"activities":[{"id":"440826","href":"/course_sessions/25512664/quizzes/440826?locale=ja","isLocked":false,"duration":900000,"title":"理解度チェック","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65739","title":"分析とレポート","description":"

スプレッドシートには、何百万という数、数式、テキストを入力しておくことができます。このようなデータは要約や可視化を行わないと、十全に活用することが難しい場合があります。特に、同僚、パートナー、見込み顧客、顧客にデータを提示する際には、要約や可視化が欠かせません。このモジュールでは、グラフやピボットテーブルなど、Google スプレッドシートのデータ可視化オプションについて見ていきます。Google Workspace のインテグレーションによって、Google ドキュメントと Google スライドでグラフやテーブルを簡単に共有できることを説明します。また、マクロを使用して反復的なタスクを自動化する方法も確認します。

","steps":[{"id":"448082","prompt":null,"isOptional":true,"activities":[{"id":"440827","href":"/course_sessions/25512664/video/440827?locale=ja","isLocked":false,"duration":78000,"title":"分析とレポート","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448083","prompt":null,"isOptional":true,"activities":[{"id":"440828","href":"/course_sessions/25512664/video/440828?locale=ja","isLocked":false,"duration":169000,"title":"グラフの探索","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448084","prompt":null,"isOptional":true,"activities":[{"id":"440829","href":"/course_sessions/25512664/video/440829?locale=ja","isLocked":false,"duration":7000,"title":"アクティビティ 4 についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448085","prompt":null,"isOptional":true,"activities":[{"id":"440830","href":"/course_sessions/25512664/documents/440830?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 4 Google スプレッドシートを使用してグラフを作成する","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448086","prompt":null,"isOptional":true,"activities":[{"id":"440831","href":"/course_sessions/25512664/video/440831?locale=ja","isLocked":false,"duration":48000,"title":"ピボットテーブル","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448087","prompt":null,"isOptional":true,"activities":[{"id":"440832","href":"/course_sessions/25512664/video/440832?locale=ja","isLocked":false,"duration":217000,"title":"ピボットテーブルを作成する","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448088","prompt":null,"isOptional":true,"activities":[{"id":"440833","href":"/course_sessions/25512664/video/440833?locale=ja","isLocked":false,"duration":9000,"title":"アクティビティ 5 についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448089","prompt":null,"isOptional":true,"activities":[{"id":"440834","href":"/course_sessions/25512664/documents/440834?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 5 既存のデータに基づいてピボットテーブルを作成する","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448090","prompt":null,"isOptional":true,"activities":[{"id":"440835","href":"/course_sessions/25512664/video/440835?locale=ja","isLocked":false,"duration":235000,"title":"Google スプレッドシートでのインテグレーションと公開","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448091","prompt":null,"isOptional":true,"activities":[{"id":"440836","href":"/course_sessions/25512664/video/440836?locale=ja","isLocked":false,"duration":9000,"title":"アクティビティ 6 についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448092","prompt":null,"isOptional":true,"activities":[{"id":"440837","href":"/course_sessions/25512664/documents/440837?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 6 公開オプションを確認する","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448093","prompt":null,"isOptional":true,"activities":[{"id":"440838","href":"/course_sessions/25512664/video/440838?locale=ja","isLocked":false,"duration":155000,"title":"マクロ","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448094","prompt":null,"isOptional":true,"activities":[{"id":"440839","href":"/course_sessions/25512664/video/440839?locale=ja","isLocked":false,"duration":76000,"title":"マクロを適用する","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448095","prompt":null,"isOptional":false,"activities":[{"id":"440840","href":"/course_sessions/25512664/quizzes/440840?locale=ja","isLocked":false,"duration":1500000,"title":"理解度チェック","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65740","title":"Google フォームを使用したデータ入力","description":"

Google フォームは、データを収集して迅速なデータ分析を可能にするオンラインアンケートです。このモジュールでは、フォームで収集したデータをスプレッドシートに接続する作業や、既存のスプレッドシートからフォームを作成する作業を通じて、Google フォームと Google スプレッドシートがどのように連携するのかを確認します。

","steps":[{"id":"448096","prompt":null,"isOptional":true,"activities":[{"id":"440841","href":"/course_sessions/25512664/video/440841?locale=ja","isLocked":false,"duration":228000,"title":"Google フォームを使用したデータ入力","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448097","prompt":null,"isOptional":true,"activities":[{"id":"440842","href":"/course_sessions/25512664/video/440842?locale=ja","isLocked":false,"duration":6000,"title":"アクティビティ 7 についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448098","prompt":null,"isOptional":true,"activities":[{"id":"440843","href":"/course_sessions/25512664/documents/440843?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 7 Google フォームを作成する","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448099","prompt":null,"isOptional":true,"activities":[{"id":"440844","href":"/course_sessions/25512664/video/440844?locale=ja","isLocked":false,"duration":220000,"title":"Google フォームの設定と共有","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448100","prompt":null,"isOptional":true,"activities":[{"id":"440845","href":"/course_sessions/25512664/video/440845?locale=ja","isLocked":false,"duration":13000,"title":"アクティビティ 8 についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448101","prompt":null,"isOptional":true,"activities":[{"id":"440846","href":"/course_sessions/25512664/documents/440846?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 8 Google フォームを共有する","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448102","prompt":null,"isOptional":true,"activities":[{"id":"440847","href":"/course_sessions/25512664/video/440847?locale=ja","isLocked":false,"duration":86000,"title":"フィードバックの管理","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448103","prompt":null,"isOptional":false,"activities":[{"id":"440848","href":"/course_sessions/25512664/quizzes/440848?locale=ja","isLocked":false,"duration":1200000,"title":"理解度チェック","description":null,"type":"quiz","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"65741","title":"ビジネス上の課題","description":"

このモジュールでは、架空の Google Workspace のお客様が抱えるビジネス上の課題を解決することを通じて、学習した知識を実践します。

","steps":[{"id":"448104","prompt":null,"isOptional":true,"activities":[{"id":"440849","href":"/course_sessions/25512664/video/440849?locale=ja","isLocked":false,"duration":86000,"title":"ビジネス上の課題の概要","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448105","prompt":null,"isOptional":true,"activities":[{"id":"440850","href":"/course_sessions/25512664/video/440850?locale=ja","isLocked":false,"duration":3000,"title":"ビジネス上の課題についての説明","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448106","prompt":null,"isOptional":true,"activities":[{"id":"440851","href":"/course_sessions/25512664/documents/440851?locale=ja","isLocked":false,"duration":1800000,"title":"アクティビティ 9 ビジネス上の課題","description":null,"type":"document","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false},{"id":"448107","prompt":null,"isOptional":true,"activities":[{"id":"440852","href":"/course_sessions/25512664/video/440852?locale=ja","isLocked":false,"duration":84000,"title":"まとめ","description":null,"type":"video","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":false},{"id":"next-steps","title":"次のステップ","description":null,"steps":[{"id":"badge-step","prompt":null,"isOptional":true,"activities":[{"id":"badge","href":null,"isLocked":true,"duration":null,"title":"コースバッジ","description":null,"type":"badge","isComplete":false,"inProgress":false,"score":null,"disabled":false}],"isComplete":false,"isTestedOut":false,"allActivitiesRequired":false}],"expanded":true}]

Google Sheets - Advanced Topics - 日本語版