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.
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!
Given the following financial portfolio, determine the percent change in portfolio value from year to year.
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!
Each exam concept broken down in simple, real-world examples!
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."
Oct. 24, 2021