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.
Tag: How to
Excel & Business Math 22: Rate Formula for Common Size Income Statement using Mixed Cell Reference
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
Excel & Business Math 21: Percent Formulas & Business Math Word Problems
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
Excel & Business Math 20: Percent Formulas for Part, Rate & Base (8 Example)
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
Excel & Business Math 19: Round a Percent using ROUND Function & Rate of Change Formula
Download Start Excel File: http://ift.tt/2nsIczl
Download pdf Notes: http://ift.tt/2DO3cvf
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to Round a Percent using ROUND Function & Change in Value Formula and Rate of Change Formula.
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:30) ROUND 2nd Argument Position for Number or Percent
3. (02:55) ROUND to Nearest Percent
4. (04:2) ROUND to Nearest Tenth of a Percent
5. (05:41) Stock Example
6. (06:07) “Change in Value” Formula
7. (07:34) “Rate of Change” Formula
8. (10:05) Reminder of how to interpret Ratios by keeping the Unit and the Number One in The Denominator
9. (13:38) ROUND to Nearest Hundredth of a Percent
10. (16:06) Summary
Next Video: 20 Excel & Business Math
Excel & Business Math 18 Percents & Percentage Number Formats (including Fractional Percents)
Download Start Excel File: http://ift.tt/2BCwF5q
Download pdf Notes: http://ift.tt/2nk98lE
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:37) What is Percent?
3. (01:30) Manually Format Number as Percent
4. (02:38) Patterns to notice when using Fractions for percents
5. (03:11) Think of Parts Of 100!
6. (04:44) Convert Percent back to a Number
7. (06:18) How to Recognize when a Percent is Less Than 1%
8. (07:36) Fractional Percents
9. (09:01) Business News & Fractional Percents
10. (10:15) When to use the word “Percent” or “Percentage”
11. (11:16) Epic Lesson on Percentage Number Format, including Fractional Percentage Number Formatting. Many Excel Examples of Formatting a Number as a Percent in Excel with Custom Number Formatting
12. (26:25) Conversions on paper and in Excel
13. (33:45) Entering Fractional Percent Amounts as Numbers and then add Fractional Percent Number Formatting
14. (37:00) Summary
Next Video: 19 Excel & Business Math
Excel & Business Math 17: Solve Fractional Business Math Problems using Excel
Download Start Excel File: http://ift.tt/2nhajlN
Download pdf Notes: http://ift.tt/2Bw5CbY
Download Video 11-17 Handwritten pdf Notes: http://ift.tt/2DZB0Tj
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to solve fractional business math 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. (00:30) Example 1: Fraction of Smokers Who Quit Smoking
3. (05:19) Example 2: Total Costs for Hair Dryer
4. (12:12) Summary
Next Video: 18 Excel & Business Math
Excel & Business Math 16: Fun With Adding & Subtracting Fractions & Least Common Denominator
Download Start Excel File: http://ift.tt/2rImrkq
Download pdf Notes: http://ift.tt/2Girprn
Download PowerPoint Fraction Drawings as seen in video: http://ift.tt/2rH6mLJ
Download Video 11-17 Handwritten pdf Notes: http://ift.tt/2DZB0Tj
Entire Class Web Site: http://ift.tt/2BjafuY
Web Site for Adding Unlike Fractions that shows 4 different Methods:
http://ift.tt/2GhnXgy
In this video learn how to add and subtract unlike functions, and have fun doing it with the “LCD Times One Method”.
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:32) Adding Like Fractions
3. (04:17) Steps for Adding Unlike Fractions and look at Least Common Denominator & “LCD Times One Method”
4. (12:46) On Paper Example 1: Add Unlike Fractions
5. (19:38) On Paper Example 2: Subtract Unlike Fractions DONE TO MUSIC
6. (22:55) On Paper Example 2: Subtract Mixed Numbers with Unlike Fractions
7. (26:30) Excel Example of adding Unlike Fractions and the LCM Function
8. (31:55) Summary
Next Video: 17 Excel & Business Math
Excel & Business Math 15: Multiplying and Dividing Fractions By Hand & In Excel
Download Start Excel File: http://ift.tt/2E8oD7c
Download pdf Notes: http://ift.tt/2DuzYNR
Download PowerPoint Fraction Drawings as seen in video: http://ift.tt/2E78Fdv
Download Video 11-17 Handwritten pdf Notes: http://ift.tt/2DZB0Tj
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to multiply and divide fractions by hand and in Excel.
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) Multiplying Fractions by hand
3. (01:37) Dividing Fractions by hand
4. (02:44) Dividing Fractions and Canceling Units
5. (06:43) Multiplying and Diving Fractions in Excel
6. (08:19) Summary
Next Video: 16 Excel & Business Math
Excel & Business Math 14: Convert Decimal To Fraction & Convert Fraction To Decimal
Download Start Excel File: http://ift.tt/2FcKslC
Download pdf Notes: http://ift.tt/2DF8okz
Download PowerPoint Fraction Drawings as seen in video: http://ift.tt/2Fa88Hh
Download Video 11-17 Handwritten pdf Notes: http://ift.tt/2DZB0Tj
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to Convert Decimal To Fraction & Convert Fraction To Decimal on paper and in Excel. Also see how to create a 1/16th Fraction to Decimal Conversion Table and do Page Setup so it prints out nicely.
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:34) Convert Decimal To Fraction with pen and paper
3. (05:00) Convert Fraction To Decimal with pen and paper
4. (06:11) Convert Decimal To Fraction with Excel
5. (09:31) Build a Fraction to Decimal Conversion Table
6. (14:15) Build a 1/16th Fraction to Decimal Conversion Table
7. (15:19) Create Text Formula
8. (17:12) Use Page Setup so it Prints Nicely
9. (20:21) Summary
Next Video: 15 Excel & Business Math
Excel & Business Math 13: Mixed Number to Improper Fraction, Improper Fraction to Mixed Number
Download Start Excel File: http://ift.tt/2E2X3s1
Download pdf Notes: http://ift.tt/2Dypygd
Download PowerPoint Fraction Drawings as seen in video: http://ift.tt/2E6V06s
Download Video 11-17 Handwritten pdf Notes: http://ift.tt/2DZB0Tj
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to convert Mixed Number to Improper Fraction and Improper Fraction to Mixed Number
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) Examples done by hand with a pen on paper
3. (05:39) Examples done in Excel, including QUOTIENT and MOD Functions and Custom Fraction Number Formatting
4. (14:04) Summary
Next Video: 14 Excel & Business Math
Excel & Business Math 12: Reducing Fractions, Prime Factors and Understanding & Calculating Ratios
Download Start Excel File: http://ift.tt/2G8nI7o
Download pdf Notes: http://ift.tt/2rwTQhX
Download Video 11-17 Handwritten pdf Notes: http://ift.tt/2DZB0Tj
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to reduce fractions in Excel and by hand. Also learn about rations and how to understand the meaning of ratios.
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:55) Factors
3. (01:39) Prime Numbers
4. (04:46) Reducing Fractions by hand
5. (07:37) Reducing Fractions in Excel
6. (20:50) Reducing Fractions and Keeping Units in Numerator and Denominator
7. (22:45) How to reduce by canceling 10s
8. (25:17) Calculating and Understanding Ratios
9. (33:15) How To Display Fraction That Is Not Reduced
10. (34:40) Summary
Next Video: 13 Excel & Business Math