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 https://youtu.be/8P4-jOoYBjo

Support me with your Amazon purchases, click here: https://amzn.to/2Kxp533

Contents 0:00
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

#seletraining #excel #functions

Видео 10 Advanced Excel Functions with Downloadable Reference Guide канала Sele Training