Data Analytics with Excel

Course Content

Course Overview

Welcome to the Course

From Data to Insights

Getting Started

Data Cleaning with Excel

Data Cleaning with AI

Data Analysis and Visualization with Pivot Tables

Generating a Dashboard

Capstone Project(s)
Here you will demonstrate your knowledge and skills by solving a real-world problem. You must work on 2 projects to qualify for a certificate.

Next Steps

Add this certificate to your resume to demonstrate your skills & increase your chances of getting noticed.

Student Ratings & Reviews

5.0

Total 1 Rating

1 Rating

0 Rating

chukwunedum Ossai

1 month ago

great experience

Let's Share & Learn

Reach Out

Course Content

Course Overview

Welcome to the Course

From Data to Insights

Analytics Triggers

Who recognizes the need for analytics?

Getting Started

Introduction to the Project

Getting Organized

Intoduction to Excel

Data Cleaning with Excel

Reading and Importing Data into Excel

Exoloring the data to detect anomalies

Dealing with Missing Values

Handling Missing Values with Excel

Review of the requirments

Handling Type Issues – Harmonizing currency

From numeric to categorical

Data Cleaning with AI

Data Cleaning with ChatGPT

Google AI Studio

Data Analysis and Visualization with Pivot Tables

Analyzing and visualizing data with Pivot Tables

Generating a Dashboard

Creating a dashboard

Making the dashboard interactive

Final cosmetics

Capstone Project(s)
Here you will demonstrate your knowledge and skills by solving a real-world problem. You must work on 2 projects to qualify for a certificate.

Capstone Project 1

Capstone Project 2

Next Steps

Congratulations

Course Evaluation Survey

Earn a certificate

Let's Share & Learn

Reach Out

Course Content

Course Overview

Welcome to the Course

From Data to Insights

Analytics Triggers

Who recognizes the need for analytics?

Getting Started

Introduction to the Project

Getting Organized

Intoduction to Excel

Data Cleaning with Excel

Reading and Importing Data into Excel

Exoloring the data to detect anomalies

Dealing with Missing Values

Handling Missing Values with Excel

Review of the requirments

Handling Type Issues – Harmonizing currency

From numeric to categorical

Data Cleaning with AI

Data Cleaning with ChatGPT

Google AI Studio

Data Analysis and Visualization with Pivot Tables

Analyzing and visualizing data with Pivot Tables

Generating a Dashboard

Creating a dashboard

Making the dashboard interactive

Final cosmetics

Capstone Project(s) Here you will demonstrate your knowledge and skills by solving a real-world problem. You must work on 2 projects to qualify for a certificate.

Capstone Project 1

Capstone Project 2

Next Steps

Congratulations

Course Evaluation Survey

Earn a certificate

Student Ratings & Reviews

Capstone Project(s)
Here you will demonstrate your knowledge and skills by solving a real-world problem. You must work on 2 projects to qualify for a certificate.