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
9 ай бұрын
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. :-)
@wellenrausch2324
9 ай бұрын
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
9 ай бұрын
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
9 ай бұрын
Oh mein gott was für ein Zufall dass genaz vor 6h ein deutscher es kommentiert…. Danke dir!! 😂
@Mg31337
4 ай бұрын
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
4 ай бұрын
Thanks for the feedback Matthias!
@AJ-fd3yj
3 ай бұрын
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.
@ExcelObstacleCourse
3 ай бұрын
Glad it was helpful!
@ologistika
10 ай бұрын
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
10 ай бұрын
Keep working on that time! Post your best one! Also thanks for the feedback!
@lynns4919
6 ай бұрын
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
6 ай бұрын
Awesome! Thanks for sharing and keep me updated with your progress!
@lynns4919
6 ай бұрын
Today, my time was 7:36!
@ExcelObstacleCourse
6 ай бұрын
@@lynns4919 great improvement!!
@tylerhoffman9856
9 ай бұрын
This was totally just shared with me this morning. I've already done the intro obstacle course. Love it.
@ExcelObstacleCourse
9 ай бұрын
Nice! Thanks for the feedback and stay tuned for more!
@sambrooks160
Жыл бұрын
This was super helpful getting me up to speed on Excel. Thank you!
@ExcelObstacleCourse
Жыл бұрын
My pleasure!
@TheFunnyEagle
3 ай бұрын
For the copy+paste as values. You can also hit Control+Alt+V.
@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
9 ай бұрын
Came from tiktok. Have tried the first practice, thank you so much.
@ExcelObstacleCourse
9 ай бұрын
Awesome!
@Notakitty
2 ай бұрын
This is life changing!!!!
@ExcelObstacleCourse
2 ай бұрын
Awesome 👏🏻 thank you!!
@bluedragon9366
Ай бұрын
thanks
@306erbii
2 ай бұрын
Love it!!!
@simulationsecrets6540
Жыл бұрын
🔥
@ExcelObstacleCourse
Жыл бұрын
😊😊😊😊😊
@Ahmet_358
Жыл бұрын
great job
@ExcelObstacleCourse
Жыл бұрын
Thank you!
@counterstrike1110
9 ай бұрын
thank you for this resource!
@liquiditywso9808
Ай бұрын
First attempt got 1:16. Glad im capable! [21] college
@ExcelObstacleCourse
Ай бұрын
Great time! Keep it up!👍
@liquiditywso9808
Ай бұрын
@@ExcelObstacleCourse just got 45 seconds!
@liquiditywso9808
Ай бұрын
@@ExcelObstacleCourse What is a good time to target for college students?
@ExcelObstacleCourse
Ай бұрын
@@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.
@liquiditywso9808
Ай бұрын
@@ExcelObstacleCourse did internships at banks and accounting firms where I got to learn a lot
@jr-bo9kj
10 ай бұрын
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
10 ай бұрын
Yes alt and = are correct. I will review the materials. Do I verbalize it incorrectly in the video too?
@podzolispogzol1014
6 ай бұрын
Is there a speedrunning community/worldrecords list for these? I believe that sub 20s is possible
@ExcelObstacleCourse
6 ай бұрын
Post your best time! I’ll be sure to compile leaderboards when enough people do.
@podzolispogzol1014
6 ай бұрын
My best time is 30.3s
@ExcelObstacleCourse
6 ай бұрын
Great time!!
@ExcelObstacleCourse
6 ай бұрын
@@podzolispogzol1014 any suggestions where to set up a community and leaderboard? Thinking discord but I don’t know much about it.
@skfan4512
18 күн бұрын
You are gamer in excel😂
@elisamier2885
9 ай бұрын
when i do the copy down excercise, it copies only the A, in all the cells, what am i doing wrong? :(
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.
@josepharocha-cw7tz
Жыл бұрын
This is excellent. A lot of clear and concise information in a short amount of time.
@ExcelObstacleCourse
Жыл бұрын
Great to hear!
@aditsud5354
5 ай бұрын
Do these shortcuts work on Mac? Unfortunately I don’t have access to a windows computer.
@ExcelObstacleCourse
5 ай бұрын
I have 2 Mac videos out there. Here is the first one. Excel Obstacle Course for Mac! kzitem.info/news/bejne/rZmGnpaZZoFqh34
@aditsud5354
5 ай бұрын
@@ExcelObstacleCourse thanks a lot really appreciate your help in my journey to master excel!
Пікірлер: 67