Skip to main content
Project

Control costs with frequently changing data

In this project, you’ll help a trucking company who can conduct basic Excel analysis, but struggles to adapt when the data changes. You’ll develop Excel models that will update when new data arrives or existing data changes, helping the company adapt to changes in the factors affecting costs.

Excel        90 Minutes        1.5 CPD Credits
TRY FOR FREEEXPLORE OUR LIBRARY

Project Steps Involved

1. Rodent Logistics’ data analysis is too static
2. Tidy up text and numeric data
3. Calculate costs based on existing data
4. Identify inputs that contribute most to costs
5. Create search panels
6. Make formulas adaptable to new data
7. Create Pivot Tables and Charts

Prerequisite Courses

Essentials

Data Manipulation and Formatting

Data Analysis

Lookups and Database Functions

Essentials

Text, Time, and Dates

Essentials

Formulas and Functions

Data Analysis

Pivot Tables

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