Tag: How to

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

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:54) Math Operators & Order of Operations
5. (08:15) Adding in Excel – many important tricks for adding
6. (17:13) Subtracting in Excel– a few tricks for subtracting
7. (20:06) Check Work When Subtracting or Adding
8. (21:51) Multiplying in Excel– many important tricks for multiplying
9. (29:11) Money amounts that with be added – Use ROUND
10. (30:41) Dividing in Excel – many important tricks for dividing. See the QUOTIENT and MOD Functions
11. (40:00) Check Work When Multiplying or Dividing
12. (41:40) Exponents – how to calculate and write in Excel
13. (47:04) More ROUND Examples
14. (54:43) Summary

Next Video: Excel & Business Math 09

View on YouTube

Excel & Business Math 07: Style Formatting Format Painter, Mini Toolbar, Styles, Clear Format & More

Posted on by Annie D

Download Start Excel File: http://ift.tt/2CXejB6
Download pdf Notes: http://ift.tt/2mblH18
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:55) Add Color to Sheet Tab in Excel Workbook
3. (02:00) Show Hide Gridlines
4. (02:23) Width of Screen Determines What Buttons Look Like in Ribbon Tabs
5. (03:48) Style Formatting like: Fill, Font, Border, Indent
6. (04:30) Formatting for an Accounting Net Income
7. (06:53) Center Across Selection as an alternative to Merge & Center
8. (07:19) Format Cells Dialog Box for All Formatting Options
9. (08:29) Format Painter Button to Copy and Paste Formatting Only!
10. (09:59) Right-click a cell to get the Mini Toolbar with common Formatting Options.
11. (21:07) Styles: Use when you use the same set of Formatting Elements Over and Over
12. (22:21) Clear Formatting
13. (23:12) Summary

Next Video: Excel & Business Math 08

View on YouTube

Excel & Business Math 06: All About Excel Formulas (17 Examples) for Business Math Class

Posted on by Annie D

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

In this video learn all about Excel Formulas. 20 amazing examples that show all the different types of formulas and the different formula elements that go into formulas. Also get a Formula Check List Sheet that showcases all the types you need to create efficient formula every time : )
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:49) Math Order of Operations and First Five Formula Examples
3. (06:350 See how to use Evaluate Formula feature in Excel to step through and see how Excel calculates your formula, step by step.
4. (11:03) Comparative Operators and Two Examples of Logical Formulas
5. (17:52) Different Phrases for Comparative Operators; A Complete List to help you figure out what Comparative Operator to use in your formula.
6. (21:18) Look at Formula Check List Sheet that has a checklist of tips for creating Efficient Formulas.
7. (23:03) 10 Formula Examples that illustrate all the different types of formulas and the different formula elements that go into formulas for this Business Math Class. Review of Excel’s Golden Rule, Review of When you MUST use ROUND Function
8. (38:16) Learn when to use Double Click to Copy a Formula Down a Column and when to manually copy the formula down
9. (39:56) Two Important tips about SUM Function. Tip 1: Don’t use Plus Symbol. Tip 2: Don’t wrap SUM Function around math calculation.
10. (43:16) Important Tip about how to use F2 Key if Arrow Keys will not put Cell References in Formulas.
11. (45:44) Summary

Next Video: Excel & Business Math 07

View on YouTube

Excel & Business Math 05: Number Formatting & When You MUST Use ROUND Function

Posted on by Annie D

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

In this video learn how about the benefits of Number Formatting, How Formulas do NOT “see” Number Formatting, and how to use the ROUND Function to avoid calculations errors.
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:39) What does Number Formatting do? Learn about Number Formatting as Façade
3. (03:10) Formulas do not “see” Number Format. Learn about how formula results may be misleading because of Number Formatting.
4. (04:58) Learn How Number Formatting can save a lot of time with Data Entry
5. (06:57) Learn about the important General Number Formatting as an Eraser. Also learn about Currency and Accounting Number Formatting
6. (11:18) Example of Error in a Payroll example when we do NOT use the ROUND Function
7. (14:50) Round Numbers by Hand. Rule for Standard Rounding Rule.
8. (18:07) Excel’s Built-in ROUND Function. Learn how to use it and When you MUST use it.
9. (24:55) Examples from Video #3. See an example of how to apply our three-step rule for when the ROUND Function is required. This is the Insurance Discount Example.
10. (28:53) Second example of how to apply our three-step rule for when the ROUND Function is required. This is the Payroll Deduction Example.
11. (31:13) Summary

Next Video: Excel & Business Math 04

View on YouTube

Excel & Business Math 04: Excel Built-in Functions, Data Types and Keyboards are Fast!

Posted on by Annie D

Download Start Excel File: http://ift.tt/2EDcI1b
Download pdf Notes: http://ift.tt/2DUJSbv
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn about three important Excel facts to help build smart Excel Solutions: Data Types and Default Alignment to help track down errors, Excel Built-in Functions, and Keyboard shortcuts to do things quickly 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. Data Types and Default Alignment
3. Define Aggregate Calculations
4. Look at the Excel Built-in Functions: COUNT, COUNTA, SUM, MAX, MIN and AVERAGE
5. How to enter multiple ranges into an Aggregate Excel Built-in Function
6. Keyboard Shourtcuts for Speed
7. () Summary

Next Video: 05 Excel & Business Math

View on YouTube

Excel Magic Trick 1475: Power Query, Formula, Flash Fill: “1-PSD/AFX-12” into “12-AFX/PSD-1”

Posted on by Annie D

Download Files: Start Excel File: http://ift.tt/2q2E39T
Download Files: Finished Excel File: http://ift.tt/2EnqTHt
Entire page with all Excel Files for All Videos: http://ift.tt/1zHY6GI about how to
In this video learn how to rearrange a product code using Excel Spreadsheet Functions and Power Query Functions. Also see that Flash Fill does not seem to work. Learn the Power Query equivalent for LEFT, RIGHT and MID Functions.
Topics:
Topics:
1. (00:11) Introduction
2. (01:36) See an example of Flash Fill and how it does not seem to work
3. (03:04) See Excel Spreadsheet Formula that uses the Functions MID, RIGHT and LEFT.
4. (06:07) See Power Query (M Code Functions) Custom Column Formula that uses the Functions Text.End, Text.Middle and Text.Start.
5. (10:33) Summary

View on YouTube

Excel & Business Math 03: Excel’s Golden Rule: Formula Inputs, What If Analysis and Excel Models

Posted on by Annie D

Download Excel File: http://ift.tt/2lifvF5
Download pdf Notes: http://ift.tt/2loU9VI
Entire Class Web Site: http://ift.tt/2BjafuY

In this video learn how to apply Excel’s Golden Rule to build efficient Excel Formula Solutions & Excel Models.
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:22) Excel’s Golden Rule
3. (02:17) What If Analysis (First Discussion)
4. (02:49) What is an Excel Model
5. (03:13) Example #1: Build Student Extra Credit Score Table
6. (07:08) What If Analysis Example
7. (08:01) Example #2: Build Month Expense Multi-step Calculation Table
8. (17:29) Excel Model Example
9. (20:19) Example #3: Create a Payroll Table
10. (25:15) Why Excel’s Golden Rule is so Important
11. (29:25) Summary

Next Video: Excel & Business Math 04:

View on YouTube