Skip to main content
Project

Use data effectively with organized spreadsheets

In this project, you’ll help a clothing retailer that has not developed good practices in storing and structuring their data. You’ll develop Excel sheets that store the company’s data in an organized manner, helping the company derive insights on revenues and profits that are currently being missed.

Excel        90 Minutes        1.5 CPD Credits
TRY FOR FREEEXPLORE OUR LIBRARY

Project Steps Involved

1. Emperor Clothes can’t analyze their data
2. Format the spreadsheet correctly
3. Set correct data types
4. Find and fix formula errors
5. Calculate revenues, costs, and profits
6. Identify popular lines with Pivot Tables and Charts

Prerequisite Courses

Essentials

Data Manipulation and Formatting

Data Analysis

Pivot Tables

Essentials

Formulas and Functions

Essentials

Text, Time, and Dates

Learning Certificates

Showcase Your Skills

Each time you complete a course exam, you earn a certificate that demonstrates your proficiency in that subject matter. We are proud to be able to say that Kubicle certificates are recognized by the most respected employers from around the world.

When you earn internationally-recognized certificates, you increase confidence. And when you enhance your ability, speed and accuracy, you increase your employability.

What Our Students Say

We don’t aim to satisfy, we aim to delight

Boost Your Career

Work smarter with full access to every course