How to use Advanced Formulas and Functions

  1. Advanced Excel Skills

    Now a days, many jobs require advanced Excel skills. Naturally, you are interested to know what are these Advanced Excel Skills? Based on...

  2. Excel IF Function Formula Made Easy

    The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Use I...

  3. Excel Functions & Defined Names

    The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. 1. Topics Covered In Video: 2. Fu...

  4. SUMIFS & COUNTIFS

    SUMIFS blows SUMPRODUCT away when it comes to calculating Speed. See how the Excel 2007 formulas SUMIFS and COUNTIFS and AVERAGEIFS are m...

  5. Array Formulas Basics

    Topics for this video: 1)Learn about the basics of array formulas 2)Entering array formulas with Ctrl + Shift + Enter 3)Array syntax 4)Op...

  6. SUMPRODUCT function 12 Examples

    Learn about the basics of SUMPRODUCT function and why some people use double negative and why other use times one. This is a great video ...

  7. Excel Data Validation

    This offers so many different videos about Excel Data Validation. I highly suggest looking through the suggested videos.

Continue learning by following more paths or create your own. Join for FREE

By clicking 'Get Started Free' you agree to our Terms of Service and Privacy Policy