Month: February 2018

Excel & Business Math 25: Percentage Formulas to Help Calculate a Budgeted Forecast for Next Year

Posted on by Annie D

Download Start Excel File: http://ift.tt/2EmtGR5
Download pdf Notes: http://ift.tt/2EXNyLl
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn how to use Excel Percentage Formulas to estimate next year Net Income Statement, create a Budgeted Forecast for Next Year.
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. (00:48) Formula 1: Rate = Part /Base: Expenses As a % of Revenue
3. (04:26) Formula 2: End = Begin*(1+ROC): This Year Revenue
4. (05:15) Formual3: Part = Rate * Base: Expenses As a % of This Year Rev
5. (06:47) Amazon Example all three formulas
6. (08:16) Summary

Next Video: 26 Excel & Business Math

View on YouTube

Excel & Business Math 24: COUNTIFS Function & Part/Base for Probabilities & Frequency Distributions

Posted on by Annie D

Download Start Excel File: http://ift.tt/2G3RUQv
Download pdf Notes: http://ift.tt/2H2WBuV
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn how to use the COUNTIFS Function and the Part / Base Formula (Rate Formula) to create a Frequency Distribution with Probabilities (Relative Frequencies) that we3 can use to estimate the likelihood of an event in the unknown future.
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:35) What is Probability?
3. (05:51) What is a Frequency Distribution?
4. (07:07) How to use COUNTIFS Function (to Count with a Specific Condition)
5. (12:00) Example 1: Create a Frequency Distribution to Calculate Probabilities of Getting a Certain Grade in Math Class
6. (16:11) Example 2: Create a Frequency Distribution to Calculate Probabilities of Getting a Certain Grade in English
7. (18:04) Example 3: Create a Frequency Distribution to Calculate Probabilities for # of Banquet Room Use
8. (20:42) Example 4: Create a Frequency Distribution to Calculate Probabilities for What Type of Item Will Be Purchased
9. (23:13) ) Summary

Next Video: 25 Excel & Business Math

View on YouTube

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

Posted on by Annie D

Download Start Excel File: http://ift.tt/2Bgnqvx
Download pdf Notes: http://ift.tt/2BL2myc
Entire Class Web Site: http://ift.tt/2BjafuY

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

View on YouTube

Excel Magic Trick 1476: SUMIFS to Add Expenses for Any Time Period (Adding with Three Conditions)

Posted on by Annie D

Download Files: Start Excel File: http://ift.tt/2E0kW6U
Entire page with all Excel Files for All Videos: http://ift.tt/1zHY6GI about how to
In this video learn how to use the SUMIFS function to add Expenses for a specified Date Range. This is an example of using SUMIFS to add with three conditions or criteria. See how to use Relative and Absolute Cell References. See how to use Comparative Operators and the Join Operator in a formula.

View on YouTube

Excel & Business Math 22: Rate Formula for Common Size Income Statement using Mixed Cell Reference

Posted on by Annie D

Download Start Excel File: http://ift.tt/2Fzn95F
Download pdf Notes: http://ift.tt/2E8zsZm
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to
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. (00:27) Format Income Statement
3. (01:39) Formulas for Income Statement
4. (06:16) Create Common Size Income Statement for Caterpillar Company using Rate Formula
5. (10:00) Create Common Size Income Statement for Amazon Company using Rate Formula & Mixed Cell Reference
6. (17:24) Summary

Next Video: ?? Excel & Business Math

View on YouTube

Excel & Business Math 21: Percent Formulas & Business Math Word Problems

Posted on by Annie D

Download Start Excel File: http://ift.tt/2Fzn95F
Download pdf Notes: http://ift.tt/2E8zsZm
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to
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. (00:26) Reminder of Formula Memorization Trick
3. (01:18) Word Problem Example 1
4. (08:05) Word Problem #2
5. (13:54) Summary

Next Video: 22 Excel & Business Math

View on YouTube

Excel & Business Math 20: Percent Formulas for Part, Rate & Base (8 Example)

Posted on by Annie D

Download Start Excel File: http://ift.tt/2Fzn95F
Download pdf Notes: http://ift.tt/2E8zsZm
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to use the three famous percent formulas for Part, Rate and Base. These formulas are universally used and when mastered can transform the way you make calculations and the way you can consume business news.
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:29) Percent Formula and Definition of Terms
3. (07:23) Introduction to 3 Different Versions of Percent Formula, including why they are TRUE and a Great Memorization Trick
4. (11:52) Example 1
5. (15:35) Example 2
6. (17:43) Example 3
7. (20:30) Example 4
8. (23:12) Example 5
9. (25:15) Example 6
10. (27:56) Example 7
11. (29:37) Example 8
12. (31:50) Summary

Next Video: 21 Excel & Business Math

View on YouTube