Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Data Analysis in Excel

via DataCamp

Go to class Write review

Overview

Exploring PivotTables You will learn how to extract valuable insights and uncover secrets hidden within your data using the power of PivotTables.

Exploring 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. 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.

Syllabus

  • 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.
  • 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.
  • 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.

Taught by

Jen Bricker

Reviews

4.0 rating, based on 1 Class Central review

4.8 rating at DataCamp based on 5298 ratings

Start your review of Data Analysis in Excel

  • Profile image for A N
    A N
    2
    My MS Excel teacher was incredibly knowledgeable and patient. They were able to clearly explain complex concepts and provide examples to help us better understand. They also provided helpful tips and shortcuts that made working with Excel much more efficient. They were always available to answer questions and provide additional support. Overall, I greatly appreciated their expertise and dedication to helping us excel in our understanding of Excel.

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.