Microsoft Excel Tutorial for Beginners - Full Course
video description
Date: 2022-03-14
Related videos
Comments and reviews: 10
Zachary
While I appreciate the attempt to utilize Excel for real world problems, I'm disappointed by the lack of completeness in your School Shopping Supplies problem. As Susan has three possible stories to shop from, I fully expected you to first determine which store would provide her the best price for each item before calculating total cost. Why would she need three lists of costs and three totals? Is she only planning to go to one store? Or is she going to go to all 3 stores and only buy the items at their lowest cost? And, will she be picking up items for Tim as well? If she is, why isn't she combining the two lists of item quantities needed before figuring costs? If Tim isn't going shopping, why do we need his total at all? Why not make this a real real world experience? Also, I'm surprised that you didn't use $F3 to figure the item cost for each store so that you didn't have to write a new formula in H3 and I3.
reply
While I appreciate the attempt to utilize Excel for real world problems, I'm disappointed by the lack of completeness in your School Shopping Supplies problem. As Susan has three possible stories to shop from, I fully expected you to first determine which store would provide her the best price for each item before calculating total cost. Why would she need three lists of costs and three totals? Is she only planning to go to one store? Or is she going to go to all 3 stores and only buy the items at their lowest cost? And, will she be picking up items for Tim as well? If she is, why isn't she combining the two lists of item quantities needed before figuring costs? If Tim isn't going shopping, why do we need his total at all? Why not make this a real real world experience? Also, I'm surprised that you didn't use $F3 to figure the item cost for each store so that you didn't have to write a new formula in H3 and I3.
reply
Dani
I'm about 30 minutes in and I gotta admit, you are brilliant at organizing what you want to teach. You've managed to organize even zooming in and out at specific intervals to teach all those small aspects of the program. Really cool! I never knew excel was so intuitive either.
reply
I'm about 30 minutes in and I gotta admit, you are brilliant at organizing what you want to teach. You've managed to organize even zooming in and out at specific intervals to teach all those small aspects of the program. Really cool! I never knew excel was so intuitive either.
reply
Mugdho
1:42:44 Can anybody tell me what's wrong with this formula?
=if(F2>22,100-F2+22,22-F2) it gives right answers to '00 and before like '99 , '98 . but for example when Year is 06 it gives answer like 116 instead of just 16. what did I do wrong???
reply
1:42:44 Can anybody tell me what's wrong with this formula?
=if(F2>22,100-F2+22,22-F2) it gives right answers to '00 and before like '99 , '98 . but for example when Year is 06 it gives answer like 116 instead of just 16. what did I do wrong???
reply
Emilie
Hi Professor Sluiter, Thank you for your course. I really enjoy it. I am at the Sales Report part, but I did not find the template you mentioned. I went on the link, but I do not see it. Could you help me to locate it? Thank you for your time. E
reply
Hi Professor Sluiter, Thank you for your course. I really enjoy it. I am at the Sales Report part, but I did not find the template you mentioned. I went on the link, but I do not see it. Could you help me to locate it? Thank you for your time. E
reply
Muhammad
I have to compare two cells in same row. e.g-
A1 cell contains text as -Apple, Banana, Graphes- -
B1 cell contains only -Apple, Graphes- -
C1 cell where I want to right see that missing text -Banana-
reply
I have to compare two cells in same row. e.g-
A1 cell contains text as -Apple, Banana, Graphes- -
B1 cell contains only -Apple, Graphes- -
C1 cell where I want to right see that missing text -Banana-
reply
scoobydoo316us
When I did PIVOT TABLE mine still had everything. WHy is yours only a few of the people. Like you had an -IF- going on. Did I miss something. I watched a couple times. Very confused.
reply
When I did PIVOT TABLE mine still had everything. WHy is yours only a few of the people. Like you had an -IF- going on. Did I miss something. I watched a couple times. Very confused.
reply
Naoton
48:42 less than feature don't work on my pc it shows red all are fail i tried changing the value it doesn't work how can i fix it.
-Edit It works after i deleted and rewrite the cell
reply
48:42 less than feature don't work on my pc it shows red all are fail i tried changing the value it doesn't work how can i fix it.
-Edit It works after i deleted and rewrite the cell
reply
Dwight
By far the best Excel tutorial I have seen for beginners. Complete, basic, to the point and very useful in real life situations. Great course! Thank you, Shad Sluiter, for sharing!
reply
By far the best Excel tutorial I have seen for beginners. Complete, basic, to the point and very useful in real life situations. Great course! Thank you, Shad Sluiter, for sharing!
reply
Nneka
hello Sir, thank you so much for this. is there a way i can see the solutions to the task you dropped towards the end of the tutorial, I want to know if I got any of them right.
reply
hello Sir, thank you so much for this. is there a way i can see the solutions to the task you dropped towards the end of the tutorial, I want to know if I got any of them right.
reply
Omar
Thank you very much. I do really like the approach of taking tasks instead of knowing what each button does without implementing it into proper context. Thank you!
reply
Thank you very much. I do really like the approach of taking tasks instead of knowing what each button does without implementing it into proper context. Thank you!
reply
Add a review, comment
Other channel videos
