Month: January 2018

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