From the course: Excel 2016 Essential Training
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Creating a percentage-change formula
From the course: Excel 2016 Essential Training
Creating a percentage-change formula
- In this worksheet called YTD and Percent Increase, we need to calculate the percent of increase of our profits from month to month or possibly the overhead or possibly sales. And is increase really the right word here? Maybe it isn't, so let's do some editing. It's going to be a change. I'm going to double-click in cell A6. I'm going to double-click right on the word Increase, and once editing has begun, I'm going to double-click again and simply put in the word Change. Now maybe I'm an optimist, and that's why I put in increase, but, on the one hand, we want our profits to increase but maybe not our overheard. Nevertheless, we've got our entry there. Now, percent change for January is not going to be meaningful because we have no previous number to compare it with, but looking into February here in cell C6, we need to calculate percent change. Now, it might have been a long time since you've done this. Probably something you learned back in the 8th grade or high school. How do we…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.