Data Analysis using Excel
- Offered byDataCamp
Data Analysis using Excel at DataCamp Overview
Duration | 3 hours |
Mode of learning | Online |
Credential | Certificate |
Data Analysis using Excel at DataCamp Highlights
- Earn a certificate after completion
Data Analysis using Excel at DataCamp Course details
- You will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables
- You’ll learn how to use keyboard shortcuts to speed up your workflow
- 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 will unlock the power of forecasting to anticipate future trends and visualize this data for your stakeholders
- Excel is the world’s most popular data analysis tool
- Strong Excel skills can open new career paths, make you more employable in various industries, and save hours in your daily tasks
- In this course, you’ll develop employable data analyst skills, starting with the Excel basics, what it can do, and the data analysis steps you should follow
- Learner will even work with real-world Kickstarter data to use your new-found Excel skills to analyze what makes a successful project
- In this course learner will learn how to prepare data by extracting text, preparing date data, and which Excel formulas can help
- Learner will learn to use ‘the most important function in Excel’, VLOOKUP, to combine data from different sources before testing your understanding in hands-on exercises
Data Analysis using Excel at DataCamp Curriculum
Exploring data with PivotTables
Introduction to data analysis
Which steps should I take?
Exploratory data analysis in PivotTables
Navigating with keyboard shortcuts
Getting started with PivotTables
Calculated fields in PivotTables
Custom grouping in PivotTables
Slicing data in PivotTables
Intermediate Logical Functions
Diving deeper with logical functions
IF versus SWITCH
Intermediate logical functions in Excel
Swapping values with SWITCH
Nesting logical functions
Using COUNTIF and SUMIF
COUNTIFS and SUMIFS
What-if analysis
What if...
What if this or that?
What-if analysis in Excel
Manual scenario creation
Using Goal Seek
What-if analysis with Scenario Manager
Sensitivity analysis with Data Tables
Forecasting
The truth about forecasting
Forecasting techniques in Excel
Moving averages
Trendline forecasts
Forecast Sheet
Other courses offered by DataCamp
Student Forum
Anything you would want to ask experts?