Fixing Common Excel Errors - Part 1: DIV/0, N/A, & NAME?
Вставка
- Опубліковано 16 лип 2024
- Learn strategies for fixing three of the most common Excel error messages: DIV/0! and N/A! and NAME?. These errors are annoying and make your spreadsheets look terrible. This video will show ways to fix them. This is Part 1 in a three part series on fixing Excel errors. Here's the practice file for the video: bit.ly/fixingexcelpart1 Here's Part 2 of this series: • Fixing Common Excel Er... My entire playlist of Excel tutorials: bit.ly/tech4excel ***Consider supporting Technology for Teachers and Students on Patreon***: / technologyforteachersa...
- Навчання та стиль
GREAT explanation!
Thank you!
I meant where & How that I can locate the Download option to copy from your into mine workbook, thanks again!
Your videos are super helpful. Thank you so much!!
This is so wonderful. Thank you so much!
5:38 what does H8, 3 and false mean in the v lookup formula
i can't download the practice xcel file.
do you have any other way of downloading the practice file?
thanks.
I have seen some excel files t hat will have a shaded note within the cell that describes what needs to be input into that cell. E.g., it may say Enter Name, or it may say Enter Start Date. How do I do that. It disappears when I start to enter the data it asks for.
Thank you ❤
What is the little green triangle in the corner of the cell??
could you please tell me how to do i record in excel but when i make the filtre i find the names written with many different way the thing which make difficult to make my statistcs at the end please help me many thanks.
Thank you
This is one of the best
i cant download the file?
I am unable to download the practice file. By clicking it's taking me to a new tab and then it's closing. Can u suggest how to download the practice file?
Thank God there's youtube and the ever so generous bloggers like you sir that took a time to do this very helpful.... Keep up the good work and I am looking forward for more lessons.🤓👍
Ծ
Ծաղկի
Thanks
Please kindly let me know how to download your spreadsheets into mine and thanks!
Why can't I open the practice file?
Hi, anyone getting n/a error when copying data from excel work book?
I can't download the practice file .Please help
i like Excel it is so fun!
Thank you so much for adding the spread sheets to work from. Excellent.
the link doesn't work
Thank you very much. I've learned a lot by watching your amazing videos. More power.
I absolutely loved this fantastic, I really liked this and found it so useful - thank you!
I've enjoyed your videos and your teaching style. Thank you for them. In this video, you mentioned that you created another video on, How to name cells in Excel. Which video is that information included in? Thanks again.
Great stuff! Thank you for the valuable content :)
The link to the spreadsheets does not work
Have you tried copying and pasting it into your browser? That typically works: bit.ly/fixingexcelpart1
Love you!
No more untidy workbook, thank you so much, so easy to follow and understand.
⭐️⭐️⭐️⭐️⭐️
Thank you :-)
##
i cant download the practice file :
Too late to the game thano you sir
Po########
Wrong! Iferror doesn’t tell you the real error- div/0 is not an error, it’s a tip that there is a division by 0, Iferror hides it so you cannot fix this kind of issues. ISNA is the real deal!
Excel sucks
I used to feel that way. But now I know more about how to make it work, and see all that it can do, HOW DARE YOU SAY THAT??????
@@CyberBuki I am so sorry
@@kaliprotection8942 LOL!!!
God so love the world hebgave his only begotten son so that whoswver believe in him shall not perish but have everlasting life