Courses
Excelで学ぶデータ分析
基本スキルレベル
更新 2025/12無料でコースを始める
含まれるものプレミアム or チーム
ExcelReporting3時間9 videos28 Exercises2,250 XP120K+達成証明書
数千社の学習者に愛用されています
2人以上をトレーニングしますか?
DataCamp for Businessを試すコースの説明
前提条件
Introduction to Excel1
Exploring data with PivotTables
You will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables. Additionally, you’ll learn how to use keyboard shortcuts to speed up your workflow.
2
Intermediate Logical Functions
You’ll identify your ideal customer profile using logical functions and create targeted marketing strategies. You’ll explore the concept of customer segmentation and gain the skills to maximize customer success, increase revenue and boost business growth. You’ll utilize functions such as Nested IFs, SWITCH, and COUNTIFS.
3
What-if analysis
You’ll master the art of scenario analysis using Excel’s built-in What-If Analysis tool. You’ll understand how different variables can impact your sales, perform sensitivity analysis and use it to make informed predictions to stay ahead in dynamic business environments.
4
Forecasting
You will unlock the power of forecasting to anticipate future trends and visualize this data for your stakeholders. You’ll leverage moving averages and trendlines to communicate your findings.
Excelで学ぶデータ分析
コース完了