First try closing it and all other spreadsheets you have open. Then reopen only the obstacle course. If this does not work go to File -> Options -> Formulas -> Enable iterative calculations -> Click OK.
The "right click" button is also called the "context menu" button. When right clicking you open the context menu. If you do not have that button on the keyboard, an alternative would be to use shift + F10. :-)
Oh boy, that was frustrating :D This doesn't work with the German version of Excel! I guess it's the same for every version that's not the standard English version. In case anyone is interested (or frustrated as me): Str (Ctr) + U for "Copy Down" Alt + Shift + 0 for "Totals" (maybe this issue is not only for the German version, but generally?) Alt, then V, then S, then Enter for "Sorting" And for "Copy and Paste Values" you start the same but then click "Ü" instead of "S" and "W" instead of "V" Maybe I helped someone this way :D
This is great for you to share! Thank you! Sorry it was not the same, but if more people comment I can come up with international versions for each locale.
That was enjoyable and well executed. However, you could enhance the efficiency of the copy-paste process by using the 'Paste Values' shortcut (Ctrl+Alt+V) directly on the 'Value Sheet.' Additionally, on the 'Copy Right' sheet, you can select all content more quickly using Ctrl+A.
I have worked in QM and Reporting for close to a decade and never thought of this. SO HAPPY To learn something new! thank you so much, I have subscribed almost immedately after seeing your channel's title and am hyped (typed, ugh, bad dad jokes emerge!) to start.
Surprisingly I already knew everything :D Time was still bad though, read through everything. My 2 suggestions would be to make the Sheet-switching shortcut page the first challenge and instead of using mouse when an user's keyboard doesn't have the right-click key, they can use Shift+F10 to stay fully mouseless.
1st time got a score of 25:24.4 I had keyboard issues. I cannot pgup or pgdn between pages. I will keep practicing to better my score. Thanks for the fun way to learn Excel!
@@liquiditywso9808 honestly it’s all about personal best. I find that around 40-50 seconds is a good goal overall. If you can do in 1:16 and you’re just in college you are way ahead of most ppl.
on worksheet Totals it says to use ALT and + to get the sums. I tried it and it didn't work, google search says it's actually ALT and =, I tried that and it worked as expected. might be typo in your file
Please tell me if this link works for you. You will have to download once you get there. If this doesn't work you should review your browser, router or other firewall limitations.
When I type an X in the green box I receive an error for circular references, how do I fix this?
First try closing it and all other spreadsheets you have open. Then reopen only the obstacle course.
If this does not work go to File -> Options -> Formulas -> Enable iterative calculations -> Click OK.
The "right click" button is also called the "context menu" button. When right clicking you open the context menu. If you do not have that button on the keyboard, an alternative would be to use shift + F10. :-)
Oh boy, that was frustrating :D This doesn't work with the German version of Excel! I guess it's the same for every version that's not the standard English version.
In case anyone is interested (or frustrated as me):
Str (Ctr) + U for "Copy Down"
Alt + Shift + 0 for "Totals" (maybe this issue is not only for the German version, but generally?)
Alt, then V, then S, then Enter for "Sorting"
And for "Copy and Paste Values" you start the same but then click "Ü" instead of "S" and "W" instead of "V"
Maybe I helped someone this way :D
This is great for you to share! Thank you! Sorry it was not the same, but if more people comment I can come up with international versions for each locale.
Oh mein gott was für ein Zufall dass genaz vor 6h ein deutscher es kommentiert….
Danke dir!! 😂
That was enjoyable and well executed. However, you could enhance the efficiency of the copy-paste process by using the 'Paste Values' shortcut (Ctrl+Alt+V) directly on the 'Value Sheet.' Additionally, on the 'Copy Right' sheet, you can select all content more quickly using Ctrl+A.
Thanks for the feedback Matthias!
I have worked in QM and Reporting for close to a decade and never thought of this. SO HAPPY To learn something new! thank you so much, I have subscribed almost immedately after seeing your channel's title and am hyped (typed, ugh, bad dad jokes emerge!) to start.
Glad it was helpful!
Surprisingly I already knew everything :D Time was still bad though, read through everything.
My 2 suggestions would be to make the Sheet-switching shortcut page the first challenge and instead of using mouse when an user's keyboard doesn't have the right-click key, they can use Shift+F10 to stay fully mouseless.
Keep working on that time! Post your best one! Also thanks for the feedback!
1st time got a score of 25:24.4 I had keyboard issues. I cannot pgup or pgdn between pages. I will keep practicing to better my score. Thanks for the fun way to learn Excel!
Awesome! Thanks for sharing and keep me updated with your progress!
Today, my time was 7:36!
@@lynns4919 great improvement!!
Very nice class keep it up Your understanding way is very unique 👌
Thank you for the kind words! Be sure to subscribe, I will keep the videos coming.
This was totally just shared with me this morning. I've already done the intro obstacle course. Love it.
Nice! Thanks for the feedback and stay tuned for more!
Came from tiktok. Have tried the first practice, thank you so much.
Awesome!
This is life changing!!!!
Awesome 👏🏻 thank you!!
This was super helpful getting me up to speed on Excel. Thank you!
My pleasure!
For the copy+paste as values. You can also hit Control+Alt+V.
You are gamer in excel😂
Love it!!!
🔥
😊😊😊😊😊
thanks
First attempt got 1:16. Glad im capable! [21] college
Great time! Keep it up!👍
@@ExcelObstacleCourse just got 45 seconds!
@@ExcelObstacleCourse What is a good time to target for college students?
@@liquiditywso9808 honestly it’s all about personal best. I find that around 40-50 seconds is a good goal overall. If you can do in 1:16 and you’re just in college you are way ahead of most ppl.
@@ExcelObstacleCourse did internships at banks and accounting firms where I got to learn a lot
great job
Thank you!
thank you for this resource!
on worksheet Totals it says to use ALT and + to get the sums. I tried it and it didn't work, google search says it's actually ALT and =, I tried that and it worked as expected. might be typo in your file
Yes alt and = are correct. I will review the materials. Do I verbalize it incorrectly in the video too?
Is there a speedrunning community/worldrecords list for these? I believe that sub 20s is possible
Post your best time! I’ll be sure to compile leaderboards when enough people do.
My best time is 30.3s
Great time!!
@@podzolispogzol1014 any suggestions where to set up a community and leaderboard? Thinking discord but I don’t know much about it.
when i do the copy down excercise, it copies only the A, in all the cells, what am i doing wrong? :(
th-cam.com/video/DbSopSMGtrc/w-d-xo.htmlsi=IGdFX0dh79Jlak5u
Someone else had a similar problem? See if this video helps and let me know
Is there one that works on mac? got pretty close just by trail and error b ut cant sort descending
Excel Obstacle Course for Mac!
th-cam.com/video/LcP8bc-O9TI/w-d-xo.html
Excel Obstacle Course for Mac 2!
th-cam.com/video/psse0JRE-WA/w-d-xo.html
Got 2 of them!
I cannot access the git link, can you tell mw how to access?
www.dropbox.com/scl/fi/o9wm3s21kx0a27wlf83bd/Excel-Obstacle-Course-XTimer.xlsx?rlkey=soag2q6koe7kqbnffsqwntmuc&dl=0
Try this link and tell me if it works.
This is excellent. A lot of clear and concise information in a short amount of time.
Great to hear!
the given link cannot be reached can you share me a new link.
www.dropbox.com/scl/fi/o9wm3s21kx0a27wlf83bd/Excel-Obstacle-Course-XTimer.xlsx?rlkey=soag2q6koe7kqbnffsqwntmuc&dl=0
Please tell me if this link works for you. You will have to download once you get there. If this doesn't work you should review your browser, router or other firewall limitations.
Do these shortcuts work on Mac? Unfortunately I don’t have access to a windows computer.
I have 2 Mac videos out there. Here is the first one.
Excel Obstacle Course for Mac!
th-cam.com/video/LcP8bc-O9TI/w-d-xo.html
@@ExcelObstacleCourse thanks a lot really appreciate your help in my journey to master excel!