10 Advanced Excel Functions with Downloadable Reference Guide

Use these 10 advanced Excel functions to tackle common tasks that are not represented by any one function. You’ll have to combine functions or create complex formulas to do them. Please follow along with the free downloadable reference guide. You are welcome and encouraged to copy and distribute this guide.

Download the free reference guide AdvancedFunctions.xlsx at www.seletraining.com

Don't miss the companion video "20 Essential Excel Functions" at

Contents
1. NESTED IF 1:14
2. INDEX-MATCH 2:07
3. EXTRACT DOMAIN 3:18
4. CHOOSE RANDOM 4:13
5. COUNT WORDS 5:16
6. MOST FREQUENT 6:56
7. OFFSET-SUM 8:38
8. SUM n ROWS 10:54
9. LAST VALUE 12:23
10. INDIRECT-MATCH 14:53

Advanced Excel Functions,Excel Formulas and Functions,Excel Tutorial,Excel 2016,Excel 2019,Excel Skills,Sele Training,Excel Introduction,Excel Reference Guide,Beginners Guide to Excel,Excel Tips & Tricks,NESTED IF,INDEX-MATCH,EXTRACT DOMAIN,CHOOSE RANDOM,COUNT WORDS,MOST FREQUENT,OFFSET-SUM,SUM n ROWS,LAST VALUE,INDIRECT-MATCH,