Joseph Yeates – CFI Education – Fundamentals of Data Analysis in Excel – Case Study

Description

Joseph Yeates – CFI Education – Fundamentals of Data Analysis in Excel – Case Study download, Joseph Yeates – CFI Education – Fundamentals of Data Analysis in Excel – Case Study review, Joseph Yeates – CFI Education – Fundamentals of Data Analysis in Excel – Case Study free
Joseph Yeates – CFI Education – Fundamentals of Data Analysis in Excel – Case Study
Fundamentals of Data Analysis in Excel – Case Study
Put your data analysis skills to the test by taking on seven challenges across a wide range of areas in Excel.
● Construct data using a variety of functions and formulas
● Present data with a mixture of formatting and structures
● Visualize data with Excel Charts
Overview
Data Analysis in Excel Case Study Overview
This case study takes you deep into Excel data analysis through seven challenges. Each challenge has different tasks that progressively increase in difficulty. It’s a hands-on way to practice your Excel skills—solving problems you might face in real-world scenarios. For each challenge, you’ll get a unique dataset. Your job is to transform, analyze, or visualize that data in different ways using Excel. Each challenge consists of a mix of tasks, which require various Excel tools and methods. This isn’t just about learning Excel functions. It’s about using them to solve real-world problems. Join in, get better at Excel, and be ready for the tasks you might face in your career.
Data Analysis in Excel Case Study Learning Objectives
By the end of the practice lab, you should be able to:

Transform data with conditional formulas, Lookup functions, and SUMPRODUCT
Analyze data to highlight insights with conditional formatting, Excel Tables, and Dynamic Arrays
Visualize data effectively by creating and formatting Excel Charts

Who Should Take This Case Study?
This Excel Case Study is perfect for those who want to put their knowledge about Data Analysis in Excel into practice with selected, real-life scenarios. This makes the case study a great follow-up to BIDA’s Fundamentals of Data Analysis in Excel.
What you’ll learn
Case Study Introduction

Excel Case Study – Introduction
Looking Up Data

Looking Up Data – Overview

Looking Up Data Task 1 – Review

Looking Up Data Task 2 – Review

Looking Up Data Task 3 – Review

Looking Up Data Task 4 – Review
Conditional Formulas

Conditional Formulas – Overview

Conditional Formulas Task 1 & 2 – Review

Conditional Formulas Task 3 & 4 – Review
Conditional Formatting

Conditional Formatting – Overview

Conditional Formatting – Review
SUMPRODUCT

SUMPRODUCT – Overview

SUMPRODUCT Task 1 – Review

SUMPRODUCT Task 2 – Review

SUMPRODUCT Task 3 – Review
Excel Tables

Excel Tables – Overview

Excel Tables – Review
Dynamic Arrays

Dynamic Arrays – Overview

Dynamic Arrays – Review
Visualizing Data

Visualizing Data – Overview

Visualizing Data Task 1 – Review

Visualizing Data Task 2 – Review

Visualizing Data Task 3 Data – Review

Visualizing Data Task 3 Chart – Review
Case Study Wrap-Up

Download Completed Files

Excel Case Study – Wrap-Up
Qualified Assessment

Qualified Assessment