Most Common Excel Formulas – Excel at Your Job

Coupon Details

Most Common Excel Formulas – Excel at Your Job, Get better and more efficient at work!

We will cover the following most common Excel formulas for intermediate users:

  1. Vlookup
  2. If Statements
  3. SumIF
  4. AverageIF
  5. CountIF
  6. TRIM
  7. Concatenate
  8. Left, Right, Mid
  9. Data Validation
  10. Removing Duplicates
  11. Conditional Formatting
  12. Data Filters

We also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells).┬áThis course is designed for Intermediate users as we do not cover basic formulas like addition, subtraction, etc…

success 100%