Most Common Excel Formulas - Excel at Your Job

Get better and more efficient at work!

Most Common Excel Formulas - Excel at Your Job
Most Common Excel Formulas - Excel at Your Job

Most Common Excel Formulas - Excel at Your Job udemy course free download

Get better and more efficient at work!

What you'll learn:

  • Students will know all intermediate-level Excel formulas and functions
  • Students will be significantly faster at their jobs when using Excel

Requirements:

  • Basic Excel Knowledge – you know how to write a basic Excel formula such as Sum or multiplying two cells

Description:

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

Who this course is for:

Course Details:

  • 1 hour on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of completion

Most Common Excel Formulas - Excel at Your Job udemy courses free download

Get better and more efficient at work!

Demo Link: https://www.udemy.com/course/most-common-excel-formulas/