Excel Obstacle Course 1st Video

How to use Excel keyboard shortcuts. Learn through a fun game! My method uses finger muscle memory for results that stick with you!
Do work in half the time through free practice. Download by clicking the link here!
github.com/Excelobstaclecours...
Two things:
1) Make sure that you don't have any other Excel sheets open when you open this.
2) Download is necessary, it only works on Excel Desktop, not Excel Online or Google Sheets, etc.
Content is FREE but consider buying me a coffee below…
ko-fi.com/excelobstaclecourse

[@parkersuzuki6416]

When I type an X in the green box I receive an error for circular references, how do I fix this?

[@ExcelObstacleCourse]

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.

[@EvanBurger_Spatial-Economist]

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. :-)

[@josepharocha-cw7tz]

This is excellent. A lot of clear and concise information in a short amount of time.

[@ExcelObstacleCourse]

Great to hear!

[@tylerhoffman9856]

This was totally just shared with me this morning. I've already done the intro obstacle course. Love it.

[@ExcelObstacleCourse]

Nice! Thanks for the feedback and stay tuned for more!

[@wellenrausch2324]

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

[@ExcelObstacleCourse]

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.

[@maaatteo6175]

Oh mein gott was für ein Zufall dass genaz vor 6h ein deutscher es kommentiert…. Danke dir!! 😂

[@sambrooks160]

This was super helpful getting me up to speed on Excel. Thank you!

[@ExcelObstacleCourse]

My pleasure!

[@counterstrike1110]

thank you for this resource!

[@powerkuzuluk4018]

Very nice class keep it up Your understanding way is very unique 👌

[@ExcelObstacleCourse]

Thank you for the kind words! Be sure to subscribe, I will keep the videos coming.

[@yewweenyo7537]

Came from tiktok. Have tried the first practice, thank you so much.

[@ExcelObstacleCourse]

Awesome!

[@ologistika]

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.

[@ExcelObstacleCourse]

Keep working on that time! Post your best one! Also thanks for the feedback!

[@lynns4919]

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!

[@ExcelObstacleCourse]

Awesome! Thanks for sharing and keep me updated with your progress!

[@lynns4919]

Today, my time was 7:36!

[@ExcelObstacleCourse]

@@lynns4919 great improvement!!

[@MatthiasGreiffenberger]

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.

[@ExcelObstacleCourse]

Thanks for the feedback Matthias!

[@Ahmet_358]

great job

[@ExcelObstacleCourse]

Thank you!

[@simulationsecrets6540]

🔥

[@ExcelObstacleCourse]

😊😊😊😊😊

[@podzolispogzol1014]

Is there a speedrunning community/worldrecords list for these? I believe that sub 20s is possible

[@ExcelObstacleCourse]

Post your best time! I’ll be sure to compile leaderboards when enough people do.

[@podzolispogzol1014]

My best time is 30.3s

[@ExcelObstacleCourse]

Great time!!

[@ExcelObstacleCourse]

@@podzolispogzol1014 any suggestions where to set up a community and leaderboard? Thinking discord but I don’t know much about it.

[@jr-bo9kj]

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

[@ExcelObstacleCourse]

Yes alt and = are correct. I will review the materials. Do I verbalize it incorrectly in the video too?

[@liampankratz7069]

Is there one that works on mac? got pretty close just by trail and error b ut cant sort descending

[@ExcelObstacleCourse]

Excel Obstacle Course for Mac! kzbin.info/www/bejne/gpSzaZWZYrRsiqs

[@ExcelObstacleCourse]

Excel Obstacle Course for Mac 2! kzbin.info/www/bejne/pqTWlmOAh6pgjaM

[@ExcelObstacleCourse]

Got 2 of them!

[@elisamier2885]

when i do the copy down excercise, it copies only the A, in all the cells, what am i doing wrong? :(

[@ExcelObstacleCourse]

kzbin.info/www/bejne/epO2oKOJgqynqMUsi=IGdFX0dh79Jlak5u

[@ExcelObstacleCourse]

Someone else had a similar problem? See if this video helps and let me know

[@lecorbusier4018]

I cannot access the git link, can you tell mw how to access?

[@ExcelObstacleCourse]

www.dropbox.com/scl/fi/o9wm3s21kx0a27wlf83bd/Excel-Obstacle-Course-XTimer.xlsx?rlkey=soag2q6koe7kqbnffsqwntmuc&dl=0

[@ExcelObstacleCourse]

Try this link and tell me if it works.

[@sanjainehru326]

the given link cannot be reached can you share me a new link.

[@ExcelObstacleCourse]

www.dropbox.com/scl/fi/o9wm3s21kx0a27wlf83bd/Excel-Obstacle-Course-XTimer.xlsx?rlkey=soag2q6koe7kqbnffsqwntmuc&dl=0

[@ExcelObstacleCourse]

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.

[@aditsud5354]

Do these shortcuts work on Mac? Unfortunately I don’t have access to a windows computer.

[@ExcelObstacleCourse]

I have 2 Mac videos out there. Here is the first one. Excel Obstacle Course for Mac! kzbin.info/www/bejne/gpSzaZWZYrRsiqs

[@aditsud5354]

@@ExcelObstacleCourse thanks a lot really appreciate your help in my journey to master excel!