### DESCRIPTION

Topics in this video:

**(00:01)** Introduction

**(00:30)** Different Types of Formulas

**(02:07)** Formula Elements – what you can out into a formula.

**(04:55)** Formula 01: Goal: Add calls made a service centre last week.: =SUM(C23:C29) . Number Formula.

**(05:53)** Formula 02: Goal: Calculate Monthly Insurance Expense.: =C37/12. Number Formula.

**(06:25)** Formula 03: Goal: Calculate Deduction for Each Employee.: =ROUND(C46*$F$46,2) . Number Formula.

**(09:31)** Formula 04: Goal: Calculate Cost of Goods Sold (COGS) in Accounting: =(C58-D58)*E58. Number Formula.

**(13:17)** Formula 05: Goal: Join “Text ” and an Item Number into One Cell.: =”Item # “&C70. Text Formula.

**(17:02)** Formula 06: Goal: Join First & Last Names into One Cell.: =C82&”, “&B82. Text Formula.

**(20:43)** Formula 07: Goal: Extract State Abbreviation using the RIGHT Function: =RIGHT(B96,2) . Text Formula.

**(24:01)** Formula 08: Goal: Extract Product Number using the LEFT Function: =LEFT(B108,6) . Text Formula.

**(26:00)** Formula 09: Goal: Determine If Debits = Credits: =B127=C127. Logical Formula.

**(30:00)** Formula 10: Goal: Determine If Employee Gets a Bonus: =C135 Greater Than =$F$135. Logical Formula.

**(33:35)** Formula 11: Goal: Count how many of each product we sold: =COUNTIFS($B$148:$B$153,B156). Number Formula.

**(35:15)** Formula 12: Goal: Formula to determine whether we need to reorder?: =$D$173 Greater Than B166-C166. Logical Formula.

**(41:00)** Formula 13: Goal: Calculate Net Income: =C181-SUM(C182:C185) . Number Formula.

**(42:30)** Summary – Conclusion

### NOTES

### WORKBOOKS

Download “Office 2016 Video 24” EB12-FormulaElements.xlsm – Downloaded 12 times – 79 KB

## Leave a Reply

You must be logged in to post a comment.