How To Fix Common Excel Formula Errors
12.1 هزار بار بازدید -
3 سال پیش
-
This step-by-step tutorial shows you
This step-by-step tutorial shows you how to fix common Excel formula errors. You will learn how to fix formulas like VLOOKUP, SUM when they return errors like #value, #na, #div/0, #num, #ref, #name, and #null. The video ends with 7 simple steps for handling any error Excel throws your way.
RESOURCES
📈 Practice workbook used in this video
https://1drv.ms/x/s!Ak3WDHJodVlziFlgL...
🎥 How to download the practice workbook
How To Download An Office 365 Excel W...
⌚️ Timestamps
0:00 Introduction, time stamps, practice data
0:35 #VALUE error, data formatted as text
1:42 #VALUE error dates formatted as text
2:26 #VALUE error refer to #VALUE error
3:23 #VALUE error inconsistent ranges
3:52, #VALUE error closed workbook
4:17, #VALUE error VLOOKUP
4:41 #NA error, value does not exist
5:25 #NA error data stored as text
6:07 #NA error hidden spaces
7:03 #DIV/0 error, 0 or blank in cell
7:42 #NAME error, misspelled formula
7:56 #NAME error misspelled range
8:10 #NAME error missing quotes
8:32 #NAME error misspelled name range
8:50 #REF error, deleted cell, sheet, workbook
9:35 #REF error relative references
10:17 #REF error, invalid reference
10:47 #NUM error, invalid number
11:19 #NUM error number too large
11:38 #NUM error financial formulas, IRR, rate
12:04 #NULL error missing colon, comma, operator
12:42 #NULL intersect operator
13:05 7 simple steps for error handling
14:05 Thank you
👍 If you learned something please give this video a thumbs up
🔔 Subscribe to my channel
https://bit.ly/2QCjwXg
🛒 Support me with your Amazon purchases
https://amzn.to/2SJ0P5c
Disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
RESOURCES
📈 Practice workbook used in this video
https://1drv.ms/x/s!Ak3WDHJodVlziFlgL...
🎥 How to download the practice workbook
How To Download An Office 365 Excel W...
⌚️ Timestamps
0:00 Introduction, time stamps, practice data
0:35 #VALUE error, data formatted as text
1:42 #VALUE error dates formatted as text
2:26 #VALUE error refer to #VALUE error
3:23 #VALUE error inconsistent ranges
3:52, #VALUE error closed workbook
4:17, #VALUE error VLOOKUP
4:41 #NA error, value does not exist
5:25 #NA error data stored as text
6:07 #NA error hidden spaces
7:03 #DIV/0 error, 0 or blank in cell
7:42 #NAME error, misspelled formula
7:56 #NAME error misspelled range
8:10 #NAME error missing quotes
8:32 #NAME error misspelled name range
8:50 #REF error, deleted cell, sheet, workbook
9:35 #REF error relative references
10:17 #REF error, invalid reference
10:47 #NUM error, invalid number
11:19 #NUM error number too large
11:38 #NUM error financial formulas, IRR, rate
12:04 #NULL error missing colon, comma, operator
12:42 #NULL intersect operator
13:05 7 simple steps for error handling
14:05 Thank you
👍 If you learned something please give this video a thumbs up
🔔 Subscribe to my channel
https://bit.ly/2QCjwXg
🛒 Support me with your Amazon purchases
https://amzn.to/2SJ0P5c
Disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.
3 سال پیش
در تاریخ 1400/05/26 منتشر شده
است.
12,105
بـار بازدید شده