# Office 2016 24

## Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples

### 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