Excel Basics - Complete Formula Lesson of Formula Types & Formula Elements With Examples

Overview

Dive into a comprehensive 43-minute video tutorial on Excel formulas, covering various formula types and elements through 12 practical examples. Learn to perform calculations, manipulate text, create logical tests, and analyze data using functions like SUM, ROUND, RIGHT, LEFT, and COUNTIFS. Master essential Excel skills for business applications, including calculating monthly expenses, determining employee bonuses, extracting data from cells, and assessing inventory reorder needs. Download accompanying files for hands-on practice and follow along with detailed explanations of each formula's purpose and structure.

Syllabus

) Introduction.
) Different Types of Formulas.
) Formula Elements – what you can out into a formula..
) Formula 01: Goal: Add calls made a service center last week.: =SUM(C23:C29) . Number Formula..
) Formula 02: Goal: Calculate Monthly Insurance Expense.: =C37/12. Number Formula..
) Formula 03: Goal: Calculate Deduction for Each Employee.: =ROUND(C46*$F$46,2) . Number Formula..
) Formula 04: Goal: Calculate Cost of Goods Sold (COGS) in Accounting: =(C58-D58)*E58. Number Formula..
) Formula 05: Goal: Join "Text " and an Item Number into One Cell.: ="Item # "&C70. Text Formula..
) Formula 06: Goal: Join First & Last Names into One Cell.: =C82&", "&B82. Text Formula..
) Formula 07: Goal: Extract State Abbreviation using the RIGHT Function: =RIGHT(B96,2) . Text Formula..
) Formula 08: Goal: Extract Product Number using the LEFT Function: =LEFT(B108,6) . Text Formula..
) Formula 09: Goal: Determine If Debits = Credits: =B127=C127. Logical Formula..
) Formula 10: Goal: Determine If Employee Gets a Bonus: =C135 Greater Than =$F$135. Logical Formula..
) Formula 11: Goal: Count how many of each product we sold: =COUNTIFS($B$148:$B$153,B156). Number Formula..
) Formula 12: Goal: Formula to determine whether we need to reorder?: =$D$173 Greater Than B166-C166. Logical Formula..
) Formula 13: Goal: Calculate Net Income: =C181-SUM(C182:C185) . Number Formula..
) Summary - Conclusion.