Month: January 2018

Excel & Business Math 19: Round a Percent using ROUND Function & Rate of Change Formula

Posted on by Annie D

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

View on YouTube

Excel & Business Math 18 Percents & Percentage Number Formats (including Fractional Percents)

Posted on by Annie D

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

Excel & Business Math 17: Solve Fractional Business Math Problems using Excel

Posted on by Annie D

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

View on YouTube

Excel & Business Math 16: Fun With Adding & Subtracting Fractions & Least Common Denominator

Posted on by Annie D

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

Excel & Business Math 15: Multiplying and Dividing Fractions By Hand & In Excel

Posted on by Annie D

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

View on YouTube

Excel & Business Math 14: Convert Decimal To Fraction & Convert Fraction To Decimal

Posted on by Annie D

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

Excel & Business Math 13: Mixed Number to Improper Fraction, Improper Fraction to Mixed Number

Posted on by Annie D

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

View on YouTube

Excel & Business Math 12: Reducing Fractions, Prime Factors and Understanding & Calculating Ratios

Posted on by Annie D

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

Excel & Business Math 11: Types Of Fractions & Fraction Number Formatting

Posted on by Annie D

Download Start Excel File: http://ift.tt/2E0poiC
Download Video 11 pdf Notes: http://ift.tt/2DryqV0
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
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:00) Define fractions
3. (01:32) Types of Fractions: Proper fractions, Improper fractions, Mixed numbers, Like Fractions, Unlike Fractions
4. (02:54) Think of Fractions as Parts of the whole
5. (05:00) Example 1 for Built-in Fraction Number Formatting. Pizza Example
6. (07:30) Example 2: Fraction Formulas for when to hard code numerator and denominator into formula
7. (09:40) Example 3 for Fraction Custom Number Formatting to display the different types of fractions
8. (16:07) How to enter a Fraction as a label and not have it appear as a Date
9. (17:45) Example 4: Student Scores and how to display 350/400
10. (20:44) ) Summary

Next Video: 12 Excel & Business Math

View on YouTube

Excel & Business Math 10: Division, Fractions, Decimals, Percentages: Number Formatting & Formulas

Posted on by Annie D

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

Excel & Business Math 09: Five Steps to Solve Math Word Problems in Excel

Posted on by Annie D

Download Start Excel File: http://ift.tt/2DlvCfj
Download pdf Notes: http://ift.tt/2mEjwna
Download Word File for Word Problem Example #1 in Video: http://ift.tt/2Dp6sw4
Download Finished Excel file for Word Problem Example #1 in Video: http://ift.tt/2mEtg0s
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn how to use five steps to create Excel solutions for Excel 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. (01:20) Five Steps to Solve Math Word Problems in Excel:
3. (02:44) Formula Efficiency Rules from Video 07:
4. (03:03) Translating English words into math symbols
5. (05:40) Math Word Problem 01: Calculate Number of Seats in Theater Balcony. We Download Word File, Read Problem and create a new Excel file.
6. (19:46) FORMULATEXT Function to show formula.
7. (26:05) Terms used in Retail Stores and examples of formulas
8. (29:50) Math Word Problem 02: Retail Store Selling Boomerangs and we need to calculate Gross Profit
9. (32:38) Cell Reference in Formula Can Pull Number Formatting from the Formula Input Cells
10. (38:40) Math Word Problem 03: How Much Water Saved in One Year with New Toilet.
11. (45:05) Math Word Problem 04: Mad Dog Trucking Average Miles Driven Example.
12. (46:05) Discuss Division with Different Units in Numerator and Denominator
13. (51:18) Look at Homework Problems
14. (51:33) Summary

Next Video: 10 Excel & Business Math

View on YouTube

Excel & Business Math 08: Arithmetic Tips for Add, Subtract, Multiply, Divide, Exponents, Rounding

Posted on by Annie D

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