Top 10 Most Commonly Used Excel Formulas

BrainyMoney ., A Love for Personal Finance

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Videos (1h 10m)
    • 01 Excel Intro

      1:53
    • 02 Course Overview

      2:11
    • 03 What we will not cover

      0:37
    • 04 Excel File Explanation

      2:41
    • 05 Vlookup

      7:58
    • 06 If Statements

      6:45
    • 07 Sumif

      6:10
    • 08 Average If

      3:45
    • 09 Count If

      4:37
    • 10 TRIM

      5:14
    • 11 Concatenate

      4:22
    • 12 LEFT, MID, RIGHT

      8:08
    • 13 Nested Formulas

      3:23
    • 14 Data Validation

      5:50
    • 15 Remove Duplicates

      2:44
    • 16 Conditional Formatting and Data Filter

      2:17
    • 17 - Excel Outro

      1:47

About This Class

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

9

Students

--

Projects

BrainyMoney .

A Love for Personal Finance

Son started BrainyMoney - www.brainymoney.com - to help everyone educate themselves on finance and have as many life options as possible.

Son Han received his B.B.A. and Masters degrees from The University of Texas at Austin in 2008. His teaching interests include finance and accounting. He has taught over 7 years at a college in Houston. He is a Certified Public Accountant in the state of Texas and a Chartered Financial Analyst. He has formerly been the CFO of a natural gas company an...

See full profile