Introduction
  • Introduction to Excel Formulas and Functions
  • What is a Formula and What Can It DO for You?
  • What is a Function and How Does IT Help You?
  • The Anatomy of a Formula and What Each Part Does
Using Formulas
  • How to Easily Select Cells to Use in a Formula
  • The Importance of Absolute vs. Relative Cell References
The 7 Most Important Excel Functions
  • Using the AVERAGE and AVERAGEA Functions
  • Using the COUNT and COUNTA Functions
  • Using the IF Function
  • Using the SUMIF and SUMIFS Functions
  • Using the COUNTIF and COUNTIFS Functions
  • Using VLOOKUP
  • Using Left, Right and Mid to Sort Data
Other Valuable Excel Functions You Should Know
  • Using CONCATENATE to Combine Text
  • UPPER, LOWER, and PROPER
  • LEN - Length of Text
  • FIND and SEARCH
Conclusion - Thank You and Bonus
  • Conclusion
  • Learn More - Other Courses by Steve McDonald (bonus lecture)