# How to use Advanced Formulas and Functions

1. article Completed

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 &amp; 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
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
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
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
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
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