Most Common Excel Formulas - Excel at Your Job

  • 0.0
1 hour on-demand video
$ 12.99

Brief Introduction

Get better and more efficient at work!

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

Requirements

  • Requirements
  • Basic Excel Knowledge - you know how to write a basic Excel formula such as Sum or multiplying two cells
$ 12.99
English
Available now
1 hour on-demand video
BrainyMoney and Son Han, CFA, CPA
Udemy
Share
Saved Course list
Cancel
Get Course Update
Computer Courses