4.2 Read 5 reviews
Overview
Context
In this Data Analysis in Excel course offered by Data Camp 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.
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.
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.
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.
What you'll learn:
- Apply What-If tools including Data Tables and Goal Seek
- Combine IF(), SUMIF(), SWITCH()
- Create calculated fields and descriptive statistics in PivotTables
- Identify how to forecast sales data using line graphs, the Forecast Sheet tool, and FORECAST.ETS(), FORECAST.ETS.CONFINT()
Programme Structure
Courses:
- Exploring data with PivotTables
- Intermediate Logical Functions
- What-if analysis
- Forecasting
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
You can apply for and start this programme anytime.
Language
English
Delivered
Online
Campus Location
- New York City, United States
Disciplines
Data Analytics View 179 other Short Courses in Data Analytics in United StatesWhat students do after studying
Join for free or log in to access our complete career info list.
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
- The course is ideal for anyone looking to enhance their data analysis skills using Excel. Whether you're a business analyst, a marketing professional, or just someone keen on making informed decisions based on data, this course offers valuable insights and skills.
- Excel is recommended. Ideally, you should have completed our Introduction to Excel course or possess equivalent foundational knowledge of Excel to comfortably navigate through this course.
- Introduction to Excel
Tuition Fees
Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions
Funding
Improve page content