Percent change | CSE 148 – Excel Exam 1

Still feeling nervous for your exam? Check out the Excel Cram Kit (Exam 1) for practice modules that emulate the difficulty that you'll face on your exam. Each module includes a thorough step-by-step explanation where I walk you through the entire problem solving process!

Percent change explained

For a second, imagine yourself as a kid again. You get an allowance each week and store it in your piggy bank.

Being the intelligent child that you are, you want to track how your weekly allowance is fluctuating. However, instead of just seeing the +/- in dollars, you want to see what percent your allowance is growing/shrinking.

The percent change formula enables us to monitor the changing of values over time.

Coding Percent change

Given the above situation, let's figure out how they calculated the percent change for each of the weekly allowances.

First, here is the formula for percent change:

=(new value - old value) / old value

Given this formula, let's start by calculating the percent change in allowance for Week 2.

Because Week 1 has no old value, only the new value of that week. We must have a new and old value to compute percent change.

The new value for Week 2 is Week 2's allowance, stored in cell B3.

=(B3 - old value) / old value

The old value is Week 1's allowance, stored in cell B2.

=(B3 - B2) / B2

When we plug this into our spreadsheet, we get the following result:

Perfect! To compute the percent change for the following weeks, just copy the formula to the rest of the weeks!

Practice problem

Given the following financial portfolio, determine the percent change in portfolio value from year to year.

=(B3-B2)/B2

This formula is then copied through each of the remaining values in the "Percent change" column.

Excel (Exam 1) Follow-along Guide

It's no secret you retain info better when you write it down. That's why I created the Excel (Exam 1) Follow-along Guide for you!

As you come upon key concepts highlighted in yellow, like this sentence here, you can fill-in-the-blanks on your Follow-along Guide so that you remember all the important stuff for later!

You can obtain the Excel (Exam 1) Follow-along Guide for FREE by entering your email below!

Next, let's learn how to create Excel charts to display data!

Free Resources

Each exam concept broken down in simple, real-world examples!

ToolsExcel (Exam 1) Follow-along Guide
LessonYEAR, MONTH, DAY
LessonSUM & AutoSUM
LessonRelative vs. Absolute Cell References
LessonRANK
LessonCOUNT
LessonROUND
LessonWEEKDAY vs. WORKDAY
LessonVLOOKUP
LessonPMT
LessonIF
LessonPercent change
LessonExcel charts
LessonImporting text files

Practice Problems

Step-by-step walkthrough for each of the questions you need to be ready for!

"I bought this Cram Kit the night before my exam, and it helped me tremendously. It provides step-by-step explanations for all the units covered in class."

Matt Lamanna
Oct. 24, 2021

Rating: 5 out of 5.

Leave a Comment