Download Files: Start Excel File: http://ift.tt/2FaY1mx
Entire page with all Excel Files for All Videos: http://ift.tt/1zHY6GI about how to
In this video learn how to use the COUNTIFS and AND Functions to create a Logical Formula that will deliver a TRUE when the Event Key is a Duplicate AND the Task Column equals “Special”.
Tag: Productivity
Excel & Business Math 28: IF Function, IS Functions & Building a Check Register Other IF Tricks too
Download Start Excel File: http://ift.tt/2C1u5ea
Download pdf Notes: http://ift.tt/2ByEwVd
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to build a check Register using the IF Function and the ISBLANK Function
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:08) Double Vertical Borders for Checkbook Register
3. (03:16) Data Validation to ONLY allow an X in the Reconciliation Column
4. (04:38) Conditional Formatting with Logical Formula and Mixed Cell Refence to format the row yellow when the item has been reconciled
5. (08:20) Checkbook Balance Formula
6. (11:07) First look at the IS Function: ISNUMBER
7. (14:07) First look at the IF Function
8. (15:20) Checkbook Balance Formula #1 using IF Function, ISNUMBER Function and a Zero Length Text String.
9. (16:37) First look at “Show Nothing”, Double Quote, Double Quote, Zero Length Text String.
10. (18:06) Test IF Function. Use Formula Evaluator to see how the IF Function puts One of Two Things in the cell.
11. (21:00) Checkbook Balance Formula #2 using IF Function, ISBLANK Function and a Zero Length Text String
12. (24:48) Difference between using ISNUMBER or ISBLANK for the Logical Test.
13. (25:38) ISFORMULA & FORMULATEXT to show formula when formula is entered into a cell.
14. (28:35) Test to see if Zero Length Text String is in cell using the ISBLANK, ISTEXT and LEN Functions
15. (30:44) Summary
Next Video: 29 Excel & Business Math
Excel & Business Math 27: Bank Reconciliation Made Easy
Excel & Business Math 27: Bank Reconciliation Made Easy
Download Start Excel File: http://ift.tt/2Bxb4zg
Download pdf Notes: http://ift.tt/2o0wqgO
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn about checks and Bank Reconciliation. Learn about the concepts of why and how we perform bank reconciliation. Also learn about how to show two worksheets from the same workbook side-by-side. Also learn hoe to create Conditional Formatting and data Validation to format or highlight a row in a checkbook register.
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. Parts of a Checks
3. Types of Endorsements
4. Bank Services & Fees
5. Bank Reconciliation Example 1: Make sure both sides are actually Equal.
6. Bank Reconciliation Example 2: Make sure both sides are actually Equal and enter the bank statement entries that are not in our records, into our records
7. Bank Reconciliation Example 3: Bank Reconciliation with a Bank Reconciliation Form
8. How to show two worksheets from the same workbook side-by-side: View, New Window, Arrange All
9. How to use Conditional Formatting and Data Validation to format or highlight row that has an “X” for “item has been reconciled”.
10. () Summary
Next Video: 28 Excel & Business Math
Excel & Business Math 26: Is Rate of Change Same for Increase by $10 and Decrease by $10?
Download Start Excel File: http://ift.tt/2EChEpR
Download pdf Notes: http://ift.tt/2swOsfi
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn about how the Rate of Change for a $10 increase and $10 decrease are different.
Excel & Business Math Class (Busn 135) taught by Michael Girvin at Highline College / Mike Girvin at excelisfun Channel at YouTube Channel.
Next Video: 27 Excel & Business Math
Excel & Business Math 25: Percentage Formulas to Help Calculate a Budgeted Forecast for Next Year
Download Start Excel File: http://ift.tt/2EmtGR5
Download pdf Notes: http://ift.tt/2EXNyLl
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to use Excel Percentage Formulas to estimate next year Net Income Statement, create a Budgeted Forecast for Next Year.
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:48) Formula 1: Rate = Part /Base: Expenses As a % of Revenue
3. (04:26) Formula 2: End = Begin*(1+ROC): This Year Revenue
4. (05:15) Formual3: Part = Rate * Base: Expenses As a % of This Year Rev
5. (06:47) Amazon Example all three formulas
6. (08:16) Summary
Next Video: 26 Excel & Business Math
Excel & Business Math 24: COUNTIFS Function & Part/Base for Probabilities & Frequency Distributions
Download Start Excel File: http://ift.tt/2G3RUQv
Download pdf Notes: http://ift.tt/2H2WBuV
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn how to use the COUNTIFS Function and the Part / Base Formula (Rate Formula) to create a Frequency Distribution with Probabilities (Relative Frequencies) that we3 can use to estimate the likelihood of an event in the unknown future.
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:35) What is Probability?
3. (05:51) What is a Frequency Distribution?
4. (07:07) How to use COUNTIFS Function (to Count with a Specific Condition)
5. (12:00) Example 1: Create a Frequency Distribution to Calculate Probabilities of Getting a Certain Grade in Math Class
6. (16:11) Example 2: Create a Frequency Distribution to Calculate Probabilities of Getting a Certain Grade in English
7. (18:04) Example 3: Create a Frequency Distribution to Calculate Probabilities for # of Banquet Room Use
8. (20:42) Example 4: Create a Frequency Distribution to Calculate Probabilities for What Type of Item Will Be Purchased
9. (23:13) ) Summary
Next Video: 25 Excel & Business Math
Excel & Business Math 23: Important Formulas for Increase Decrease Problems (8 Awesome Examples)
Download Start Excel File: http://ift.tt/2Bgnqvx
Download pdf Notes: http://ift.tt/2BL2myc
Entire Class Web Site: http://ift.tt/2BjafuY
In this video learn about all the formulas for Increase and Decrease, or Percentage Increase 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:27) What is an Increase Decrease Problem
3. (03:33) How to solve an Increase Problem with the Table Method, Diagram Method and an example of every possible formula for an Increase Problem.
4. (23:33) How to solve a Decrease Problem with the Table Method, Diagram Method and an example of every possible formula for an Increase Problem.
5. (34:19) Example 1: Stock Market Drop on Feb 5, 2018 and make formulas
6. (42:21) Example 2: Using Yahoo Finance to get Stock Data and make formulas
7. (45:34) Example 3: Farmland Value Example
8. (49:52) Example 4: Markdown and Markup Examples
9. (52:30) Example 5: GE Company Sales Example
10. (55:07) Stock Example with a Portfolio of Different Stocks
11. (58:21) Summary
Next Video: 24 Excel & Business Math
Excel Magic Trick 1476: SUMIFS to Add Expenses for Any Time Period (Adding with Three Conditions)
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.
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