Excel & Business Math 23: Important Formulas for Increase Decrease Problems (8 Awesome Examples)

In this video learn about all the formulas for Increase and Decrease, or Percentage Increase Problems.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Topics in Video:
1. (00:01) Introduction
2. (01:27) What is an Increase Decrease Problem
3. (03:33) How to solve an Increase Problem with the Table Method, Diagram Method and an example of every possible formula for an Increase Problem.
4. (23:33) How to solve a Decrease Problem with the Table Method, Diagram Method and an example of every possible formula for an Increase Problem.
5. (34:19) Example 1: Stock Market Drop on Feb 5, 2018 and make formulas
6. (42:21) Example 2: Using Yahoo Finance to get Stock Data and make formulas
7. (45:34) Example 3: Farmland Value Example
8. (49:52) Example 4: Markdown and Markup Examples
9. (52:30) Example 5: GE Company Sales Example
10. (55:07) Stock Example with a Portfolio of Different Stocks
11. (58:21) Summary

Next Video: 24 Excel & Business Math

[excelisfun]

Opps. At the 01:00:01 minute mark I mistakenly say that the next video, video #24 will be about Bank Reconciliation. This is incorrect. The next video is about Percentage Formulas and Probability and the COUNTIFS Function. The Bank Reconciliation videos is not until video #27.

[LeilaGharani]

So much gold in this video! I really like how you summarized the terms, together with their corresponding formulas. Thank you.

[chrisgray]

Those formulas are a great help. Thank you, Sir.

[ismailismaili]

Mr. Mike you made it so easy i think with you every single human can work in stocks and Banking things, thank you so so much

[evangoldschlag]

I've been watching all of your math and business videos trying to find out how to create a formula to reduce a value on the first of every month. I can't seem to figure it out. Is there a way to do this? Ie) 10, 000 less 1, 000 on the first of every month until you're at 0.

[jennifervilott]

ok all you excel people, I need some help....Desperate for help. Have a spreadsheet in which complaints have been given numerical value. How do I get the actual text value to come up in a new column?

Complaint
1 Broken Tube (pre-meal)
2 Broken Tube (post-meal 1st hr)
3 Broken Tube (post-meal 2nd hr)
4 Broken Tube (post-meal 3rd hr)
5 Broken Tube (post-meal 4th hr)
6 Patient Nausea
7 Missing Spirulina/Egg
8 Missing Mixing Cup
9 Missing Straws
10 Missing Utensils
11 Missing Crackers
12 Missing Water Cup
13 Missing Test Req Form
14 Unpleasant Taste
15 Patient Vomited
16 Prescription/Medicine Interaction
17 Data Transfer Issue
18 Gastro Intestinal Issues (burping)
19 Broken tube return shipment (Multiple)
20 Barcode Mismatch
21 Missing Return Label
22 Missing Breath Tube
23 Discrepency In Reporting

So that if a line item notes for instance that complaint number 22 was issued (cell K2), then in cell K3 Missing Breath Tube would show... and exclude all others.

[darshanjain]

Hey Hi, Nice video... I just want to know do you mind if i put your video on my website and help you to increase views ?