How to use Advanced Formulas and Functions

  1. article Completed

    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 my experience of training more than 3,000 students in various online & physical training programs, the following 9 areas form the core of advanced Excel skills. This is a great way to learn advanced excel skills.

    Edit Remove Move
  2. video Completed

    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 IF function to put one of two things into a cell or formulas 2. Logical Formula comes out to be TRUE or FALSE 3.<br><br>This is a great way to learn more using a tutorial video! Great formula tricks to help you!

    Edit Remove Move
  3. video Completed

    Excel Functions & Defined Names

    The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. <br>&nbsp;1. Topics Covered In Video: <br>2. Functions: 3. SUM (add) 4. COUNT (Count Numbers) 5. COUNTA (Count non-blank cells) 6. MIN (minimum value) 7. MAX (maximum value) 8.<br><br>This goes over basic excel functions.

    Edit Remove Move
  4. video Completed

    SUMIFS & COUNTIFS

    SUMIFS blows SUMPRODUCT away when it comes to calculating Speed. See how the Excel 2007 formulas SUMIFS and COUNTIFS and AVERAGEIFS are much faster than SUMPRODUCT and SUM array formulas. Learn how to speed up slow calculating spreadsheets with formulas that calculate faster.

    Edit Remove Move
  5. video Completed

    Array Formulas Basics

    Topics for this video: <br>1)Learn about the basics of array formulas 2)Entering array formulas with Ctrl + Shift + Enter 3)Array syntax 4)Operations on ranges and arrays instead of cells or individual values 5)Create array formulas in single cells and save space in spreadsheet 6)Array formula

    Edit Remove Move
  6. video Completed

    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 to help you better understand sum product.

    Edit Remove Move
  7. link Completed

    Excel Data Validation

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

    Edit Remove Move

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