Look Who it Was Random video

Excel - Tutorial: How to Reduce Prices by 35% - Two Methods! - Episode 966

1,037 views · Published 9 March 2009 · 3:08 · Indexed 29 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Tutorial: How to Reduce Prices by 35% - Two Methods!

Welcome back to the MrExcel netcast! In this episode, we're going to tackle a common problem faced by many Excel users - how to reduce a column of prices by a certain percentage. I'm Bill Jelen, and I'll be showing you my method for solving this problem.

First, we start with a massive amount of data that needs to be analyzed. In order to do this efficiently, we'll be using a pivot table. So let's fire one up and see if we can solve this problem.

I'm here at Highline Community College in Seattle with my friend and Excel expert, Mike "Excel is Fun" Girvin. Mike received a question on YouTube this morning about reducing prices by 35%, and we're going to show you two different ways to do it - my way and Mike's way. Let's see which one works best for you.

My method involves using a simple formula to get 65% and then copying and pasting it as values over the original prices. This is a quick and easy way to reduce the prices without affecting the original data. However, there is no audit trail to go back and check the calculations, so it's important to double check the results.

Now, let's take a look at Mike's method. He also uses a formula to get 65%, but instead of pasting it over the original prices, he creates a new column and uses a simple formula to calculate the reduced prices. This method allows for an audit trail and is a great option for those who want to keep track of their calculations.

Whichever method you choose, reducing prices by 35% is now a breeze in Excel. Thanks for watching this episode of the MrExcel netcast. Don't forget to subscribe to our channel for more Excel tips and tricks. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Another dual podcast as Bill Jelen and Mike Gel Girvin show you multiple ways to reduce a range by 35%. Shot in Seattle, Washington. Episode 966 shows you how.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Table of Contents:
(00:00) Reduce Prices by a Percentage 
(00:20) First solution 
(01:28) Second solution 
(02:41) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Checking results in Excel
Copying and pasting values in Excel
Creating new columns in Excel
Dueling Excel methods for reducing prices
Locking cells in Excel formulas
Multiplying values in Excel
Netcast from MrExcel
Reducing prices by 35% in Excel
Removing formats in Excel
Using formulas and functions in Excel
Using the fill handle in Excel
YouTube video on analyzing data with pivot tables

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152257/

More from this channel