do you know where i can do a practise test for excel 97 and 2003. the one i need to syudy for has a screen as you have shown and it tells us to do differnet things to sheet. i need it to rate my accuracy thanks
@plutity dude you need to learn not to require math wizzes to be elocution wizzes (Einstein mumbled, as does Woody Allen -- multimilliondollar speaker; this lecturer speaks clearly, if a little fast . . . you can pause and replay as need) and not to split infinitives ("to also learn"). :) Respect the virtues (Excel sense) being exhibited.
Hey dude..nice video.I have a question. I try to find the evaluation using an IF typing this: =IF(B4>75000,EXCELLENT,IF(B4>50000,GOOD,IF(B4>25000,FAIR,POOR)))
This is great! Is it possible for me to obtain the Word file associated with this? Are these the typical questions used when employment agencies administer the Microsoft Excel tests? if not, can you recommend one of your other videos I can refer to?
This is great. But I am not able to find the question for the quiz. I am only able to download the actual spreadsheet. How can I get the questions? Thank you so much for your help!
This was amaaaazing. Thank you so much. You saved me about £100 on a 'refresher' course. srsly cool of you to do this. I hope you're little one with the cough got better quickly. :-) subscribed!
Thanks, but can you please put the Excel Test instructions back online? I was able to download the test workbook, but it appears that the test instructions are not on your site anymore? Thanks, looking forward to taking your test.
You should check the last col. (Salesperson's evaluation) - there is a mistake (time 16:48 - Total salary:$ 54000 = Excellent, Evaluation Criteria said that Excell. >75000)
No sorry for the misunderstanding, but I meant the Excel file itself, so that I can practice. I can already watch the video so there's no need to use Vdownloader. I need the xls. file. Thanks
Great tutorial...thank you!
817dottz 1 month ago
Where is the question paper??
samryzi 1 month ago
Could you or anyone send me the Document with the Instructions??
JFabree 2 months ago
anyone know, whats the highest score on the excel practice test ?
Animeprincess15ify 3 months ago
My maths teacher is making us do an excel test using your video
MeshMovies 5 months ago
Comment removed
Hikaru227 4 months ago
@MeshMovies Studying Youtube Videos isn't too bad :)
Hikaru227 4 months ago
This was so very helpful in brusing up on my Excel! Thanks so much for making this video!
lylanya 6 months ago
I'm already certified in Word. But Excel looks so difficult. And I still have PowerPoint, Outlook and Access. Thanx for this.
falloutfans95 7 months ago
How do we know that the column index number is 2? :/
MzSiddiqui 7 months ago
thank you very much mr. joshwaxman!!!!
doraskypalencia 7 months ago
I just wanted to brush up on excel, this was very helpful. Thank you!
StephieLarura 8 months ago
why doesn't anyone who makes these videos have a normal fucking voice!
kalaniman1movies 8 months ago
Wonderful Explanation...
ganajo31 8 months ago
do you know where i can do a practise test for excel 97 and 2003. the one i need to syudy for has a screen as you have shown and it tells us to do differnet things to sheet. i need it to rate my accuracy thanks
sharonhall17 9 months ago
thanks, very helpfullllll
fabrah80 11 months ago
thank, very helpfullllll
fabrah80 11 months ago
How do I see the new excel practice data and instructions for 2007
Excel1949 11 months ago
"off the top"
notausertoday 1 year ago
@plutity dude you need to learn not to require math wizzes to be elocution wizzes (Einstein mumbled, as does Woody Allen -- multimilliondollar speaker; this lecturer speaks clearly, if a little fast . . . you can pause and replay as need) and not to split infinitives ("to also learn"). :) Respect the virtues (Excel sense) being exhibited.
JudgeJulieLit 1 year ago
you need quotes around "FAIR", "EXCELLENT", and "POOR"
joshwaxman 1 year ago 4
This has been flagged as spam show
Great video....thank you Josh
cdsalanova 1 year ago
Hey dude..nice video.I have a question. I try to find the evaluation using an IF typing this: =IF(B4>75000,EXCELLENT,IF(B4>50000,GOOD,IF(B4>25000,FAIR,POOR)))
However its not working. Do you know why?
tsesken 1 year ago
Thanks for sharing, was really helpful, wasn't able to find the word file though, there seems to only be the worksheet here
jaygal78 1 year ago
Amazing.
stnpetrica1 1 year ago
@plutity
Dude, you need to also learn how to spell properly (no offense)
smithars24 1 year ago
This is great! Is it possible for me to obtain the Word file associated with this? Are these the typical questions used when employment agencies administer the Microsoft Excel tests? if not, can you recommend one of your other videos I can refer to?
Many thanks!
108veyron 1 year ago
@108veyron
did you get the word file associated with this practice test?
SuperRobinsont 1 year ago
This is great. But I am not able to find the question for the quiz. I am only able to download the actual spreadsheet. How can I get the questions? Thank you so much for your help!
Catherine
cathoujoop 1 year ago
thanks heaps dude you're amazing
froggstomp 1 year ago
DUDE!! you saved my life with this sample. Thanks sooooo much!
WrightswCrayons 2 years ago
whats wrong with the audio?
hansonkewl06 2 years ago
Comment removed
SmokeyKurt 2 years ago
thanks. i'll try to be more careful in the next version (for excel 2007)
josh
joshwaxman 2 years ago
Josh at 16:48, you put B18 instead of E18 resulting in incorrect Salesperson's Evaluations
s8eep 2 years ago
This was amaaaazing. Thank you so much. You saved me about £100 on a 'refresher' course. srsly cool of you to do this. I hope you're little one with the cough got better quickly. :-) subscribed!
alanna4858 2 years ago
i updated the description with the url for downloading it.
joshwaxman 2 years ago
@joshwaxman is it the same with microsoft excel 2010 bro? tnx
Man20Pac 1 year ago
how do you dload test workbook?
spaghappy 2 years ago
myeaaaaaaaah
stupid im a llama
bzezima 2 years ago
Thanks, but can you please put the Excel Test instructions back online? I was able to download the test workbook, but it appears that the test instructions are not on your site anymore? Thanks, looking forward to taking your test.
freezelanded 2 years ago
Thank you thank you thank you!!
bopgirl 3 years ago
Thank you for posting this. It was very helpful in helping me brush up on excel.
cmv555 3 years ago
Thank you very much.
Agultihitina 3 years ago
on the same website, but under Syllabi on the sidebar, scroll down until you see the link for it.
joshwaxman 3 years ago
Where can I download the Word instructions? I downloaded the workbook...but can't find instruction...Thanks.
VinnyGracieScotty 3 years ago
hehe s
ajphoenix91 3 years ago
You should check the last col. (Salesperson's evaluation) - there is a mistake (time 16:48 - Total salary:$ 54000 = Excellent, Evaluation Criteria said that Excell. >75000)
smumin160 3 years ago
Well spotted, the formula should have been
=VLOOKUP(E18,$E$25:$F$28,2)
s8eep 2 years ago
You are quite a mench
easyandyy 3 years ago
Wow! Thank you very much! I learned a lot. :D
ddgrm71 3 years ago
excelent but not visible
03335757975 3 years ago
This comment has received too many negative votes show
nerdd
xMelisaaa 3 years ago
this is very useful, thanks
bankydoi 3 years ago 2
thanks a lot!!! i have in interview in about an hour. i forgot to study about this. this surely is a big help!
lnclemente 3 years ago
where do i download the excel file?
dtrtw 3 years ago
this is an attempt to reply
joshwaxman 3 years ago
it looks like it does not like web addresses. do a google search for cs12 svitak and follow the top link.
joshwaxman 3 years ago
This comment has received too many negative votes show
not even slightly as funny as "The SPREADSHEET" on Youtube!
scorp3420 4 years ago
Where can I download this file? Thanks in advance
redsea91 4 years ago
Use Vdownloader software, you can extract this video out of youtube
serzantas 4 years ago
No sorry for the misunderstanding, but I meant the Excel file itself, so that I can practice. I can already watch the video so there's no need to use Vdownloader. I need the xls. file. Thanks
redsea91 4 years ago
really informative
s2g78v9k168 5 years ago
Now that my Excel knowledge is refreshed, do you have any microsoft word practice tests or tutorials? I can really use one.
DjBonzai 5 years ago