20 Essential Excel Functions with Downloadable Reference Guide

Use these 20 essential Excel functions to do 95% of your work in Excel. I explain all 20 with examples of each function. 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 EssentialFunctions.xlsx at www.seletraining.com
https://img1.wsimg.com/blobby/go/b8e6...

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

Contents 0:00
1. SUM 1:00
2. AVERAGE 2:03
3. ROUND 2:46
4. IF 3:56
5. COUNTIF 5:19
6. SUMIF 7:08
7. RANK 8:47
8. TODAY 10:58
9. DATE 12:15
10. VLOOKUP 13:24
11. FIND 15:24
12. CONCATENATE 17:48
13. TRIM 19:13
14. LEN 19:43
15. LEFT & RIGHT 20:20
16. MID 21:00
17. UPPER & LOWER 22:02
18. MIN & MAX 22:43
19. AND & OR 23:50
20. IFERROR 25:26

#seletraining #excel #functions