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

View on YouTube

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

View on YouTube

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

View on YouTube

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

View on YouTube

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

In this video learn all about Division, Fractions, Decimals, Percentages in Excel including Number Formatting and Formulas
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:46) Division, Fractions, Decimals, Percentages
3. (06:33) Rules For Percentages
4. (08:09) Examples of Division-Fraction-Decimal-Percentages
5. (10:30) Number Formatting for Decimals, Percentages & Fractions
6. (20:00) Percentage Number Formatting Pitfalls & Tricks
7. (24:25) Two Examples of Math with Percentages or Decimals
8. (30:50) Homework
9. (30:55) Summary

Next Video: Excel & Business Math 11

View on YouTube

Download Start Excel File: http://ift.tt/2my0RKo
Download pdf Notes: http://ift.tt/2r2Oive
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. (01:13) Whole Numbers, Integers & Decimals Words
3. (03:22) Write Number in English
4. (05:34) Math Operators & Order of Operations
5. (07:55) Adding in Excel – many important tricks for adding
6. (16:53) Subtracting in Excel– a few tricks for subtracting
7. (19:86) Check Work When Subtracting or Adding
8. (21:31) Multiplying in Excel– many important tricks for multiplying
9. (28:91) Money amounts that with be added – Use ROUND
10. (30:21) Dividing in Excel – many important tricks for dividing. See the QUOTIENT and MOD Functions
11. (39:40) Check Work When Multiplying or Dividing
12. (41:20) Exponents – how to calculate and write in Excel
13. (46:84) More ROUND Examples
14. (54:23) Summary

Next Video: Excel & Business Math 09

View on YouTube