Google Sheets - Advanced Topics 日本語版 from Coursera

Google スプレッドシートの中級コースは、初級のコースで説明されたコンセプトを元に進められます。

このコースでは、Google スプレッドシートでテーマを適用してカスタマイズする方法を学習し、条件付き書式のオプションを確認します。

Google スプレッドシートの高度な数式と関数をいくつか学習します。関数を使用した数式を作成する方法を確認し、さらに Google スプレッドシート内のデータを参照して検証する方法を学びます。

スプレッドシートには、何百万という数、数式、テキストを入力しておくことができます。このようなデータは要約や可視化を行わないと、十全に活用することが難しい場合があります。このコースでは、グラフやピボットテーブルなど、Google スプレッドシートのデータ可視化オプションを確認します。

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

Screen reader support enabled.

Google スプレッドシートの中級コースは、初級のコースで説明されたコンセプトを元に進められます。

このコースでは、Google スプレッドシートでテーマを適用してカスタマイズする方法を学習し、条件付き書式のオプションを確認します。

What's inside

Syllabus

コースの概要

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

モジュール 1: Google スプレッドシートの高度な書式設定

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

高度な数式と関数

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

分析とレポート

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

Google フォームを使用したデータ入力

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

ビジネス上の課題

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

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Offers training in spreadsheet customization and advanced formatting options to help learners effectively present data

Develops ability to use formulas and functions, allowing learners to automate calculations and enhance data analysis

Provides knowledge of data visualization techniques, enabling learners to summarize and interpret large datasets

Introduces Google Forms and demonstrates its integration with Google Sheets for efficient data collection and analysis

Provides hands-on practice through business use cases that allow learners to apply their acquired skills

Taught by Google Cloud Training, an organization recognized for its expertise in cloud computing and data analysis

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Google Sheets - Advanced Topics 日本語版 with these activities:

スプレッドシートのヒントとコツを他の学生と共有する

Show steps

このセッションでは、スプレッドシートの使用に関するヒント、コツ、ベストプラクティスを他の学生と共有します。これにより、他の学生から学び、自分のスキルを向上させることができます。

Show steps

スプレッドシートの高度な機能やテクニックを共有する
スプレッドシートを使用する際のよくある問題について議論する
スプレッドシートのベストプラクティスについてフィードバックを提供する

Show all one activities

Career center

Learners who complete Google Sheets - Advanced Topics 日本語版 will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts use a variety of statistical and programming methods to assist businesses in making data-driven decisions. With the help of the Google Sheets - Advanced Topics course, learners will be able to gain the skills necessary to efficiently collect and analyze large datasets. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. This knowledge and skillset will provide a solid foundation for a career in Data Analytics.

See salaries and explore the career path for Data Analyst

Financial Analyst

Financial Analysts use financial data to make investment recommendations and guide business decisions. The Google Sheets - Advanced Topics course can provide Financial Analysts with the skills they need to effectively analyze financial data, create financial models, and present their findings to clients. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Financial Analysts who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Financial Analyst

Market Researcher

Market Researchers collect and analyze data about consumer behavior and market trends. The Google Sheets - Advanced Topics course can provide Market Researchers with the skills they need to effectively collect and analyze data, identify trends, and communicate their findings to stakeholders. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Market Researchers who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Market Researcher

Business Analyst

Business Analysts help organizations improve their performance by analyzing business processes and recommending solutions to problems. The Google Sheets - Advanced Topics course can provide Business Analysts with the skills they need to effectively analyze data, identify trends, and communicate their findings to stakeholders. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Business Analysts who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Business Analyst

Statistician

Statisticians collect, analyze, and interpret data to help businesses and organizations make informed decisions. The Google Sheets - Advanced Topics course can provide Statisticians with the skills they need to effectively analyze data, identify trends, and communicate their findings to stakeholders. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Statisticians who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Statistician

Operations Research Analyst

Operations Research Analysts use mathematical and analytical methods to improve the efficiency of business operations. The Google Sheets - Advanced Topics course can provide Operations Research Analysts with the skills they need to effectively analyze data, identify inefficiencies, and develop solutions to problems. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Operations Research Analysts who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Operations Research Analyst

Quantitative Analyst

Quantitative Analysts use mathematical and statistical models to analyze financial data and make investment recommendations. The Google Sheets - Advanced Topics course can provide Quantitative Analysts with the skills they need to effectively analyze financial data, create financial models, and present their findings to clients. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Quantitative Analysts who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Quantitative Analyst

Machine Learning Engineer

Machine Learning Engineers build and maintain machine learning models to solve business problems. The Google Sheets - Advanced Topics course can provide Machine Learning Engineers with the skills they need to effectively collect and analyze data, and develop and deploy machine learning models. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Machine Learning Engineers who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Machine Learning Engineer

Data Scientist

Data Scientists use a variety of statistical and programming methods to analyze data and solve business problems. The Google Sheets - Advanced Topics course can provide Data Scientists with the skills they need to effectively collect and analyze data, identify trends, and communicate their findings to stakeholders. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Data Scientists who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Data Scientist

Database Administrator

Database Administrators design and maintain databases. The Google Sheets - Advanced Topics course can provide Database Administrators with the skills they need to effectively analyze data and develop databases that meet the needs of users. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Database Administrators who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Database Administrator

Software Engineer

Software Engineers design, develop, and maintain software applications. The Google Sheets - Advanced Topics course can provide Software Engineers with the skills they need to effectively analyze data and develop software applications that meet the needs of users. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Software Engineers who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Software Engineer

Web Developer

Web Developers design and develop websites and web applications. The Google Sheets - Advanced Topics course can provide Web Developers with the skills they need to effectively analyze data and develop web applications that meet the needs of users. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Web Developers who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Web Developer

Data Engineer

Data Engineers design and maintain data pipelines and data warehouses. The Google Sheets - Advanced Topics course can provide Data Engineers with the skills they need to effectively analyze data and develop data pipelines and data warehouses that meet the needs of users. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Data Engineers who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Data Engineer

Business Intelligence Analyst

Business Intelligence Analysts use data to help businesses make informed decisions. The Google Sheets - Advanced Topics course can provide Business Intelligence Analysts with the skills they need to effectively analyze data, identify trends, and communicate their findings to stakeholders. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Business Intelligence Analysts who take this course will be able to work more efficiently and effectively.

See salaries and explore the career path for Business Intelligence Analyst

Information Systems Manager

Information Systems Managers plan and manage the implementation and use of information systems. The Google Sheets - Advanced Topics course may be useful for Information Systems Managers who want to learn more about data analysis and visualization techniques. The course covers topics such as advanced formula and function usage, data visualization techniques, and data validation techniques. Information Systems Managers who take this course may be able to work more efficiently and effectively.

See salaries and explore the career path for Information Systems Manager