Highline College Busn 216 Class: Computer Applications taught by Michael Girvin.
\nDownload Excel Start & Finished File: http:\/\/ift.tt\/2iZNLH6
\nDownload Full Written Notes: http:\/\/ift.tt\/2z9Fzrs
\nClass web page link: http:\/\/ift.tt\/2kPyedk
\nTopics in this video:
\n1. (00:01) Introduction
\n2. (00:30) Different Types of Formulas
\n3. (02:07) Formula Elements \u2013 what you can out into a formula.
\n4. (04:55) Formula 01: Goal: Add calls made a service center last week.: =SUM(C23:C29) . Number Formula.
\n5. (05:53) Formula 02: Goal: Calculate Monthly Insurance Expense.: =C37\/12. Number Formula.
\n6. (06:25) Formula 03: Goal: Calculate Deduction for Each Employee.: =ROUND(C46*$F$46,2) . Number Formula.
\n7. (09:31) Formula 04: Goal: Calculate Cost of Goods Sold (COGS) in Accounting: =(C58-D58)*E58. Number Formula.
\n8. (13:17) Formula 05: Goal: Join “Text ” and an Item Number into One Cell.: =”Item # “&C70. Text Formula.
\n9. (17:02) Formula 06: Goal: Join First & Last Names into One Cell.: =C82&”, “&B82. Text Formula.
\n10. (20:43) Formula 07: Goal: Extract State Abbreviation using the RIGHT Function: =RIGHT(B96,2) . Text Formula.
\n11. (24:01) Formula 08: Goal: Extract Product Number using the LEFT Function: =LEFT(B108,6) . Text Formula.
\n12. (26:00) Formula 09: Goal: Determine If Debits = Credits: =B127=C127. Logical Formula.
\n13. (30:00) Formula 10: Goal: Determine If Employee Gets a Bonus: =C135 Greater Than =$F$135. Logical Formula.
\n14. (33:35) Formula 11: Goal: Count how many of each product we sold: =COUNTIFS($B$148:$B$153,B156). Number Formula.
\n15. (35:15) Formula 12: Goal: Formula to determine whether we need to reorder?: =$D$173 Greater Than B166-C166. Logical Formula.
\n16. (41:00) Formula 13: Goal: Calculate Net Income: =C181-SUM(C182:C185) . Number Formula.
\n17. (42:30) Summary – Conclusion<\/p>\n