You are so funny, cute, carismatic. It's funny how you get so excited, euforic: "it's so brilliant". You say a lot the word brilliant and favorite. LOL. Thank you for your videos.
Hi Gasper, On ALT+DownArrow: you could have added that it also works to display the options in functions (subtotal, aggregate,…) - we’ve talked about that before. Furthermore: in Excel Tables it works in the entire column - no need to be adjacent. BTW: I don’t use the shortcuts for NOW() and TODAY() because their results are static, I prefer to use the functions. And finally, less than a year ago I switched back to using an Int’l QUERTY for the obvious reasons. ;-)
Hi Geert. These videos (except for Interviews and book reviews) are recorded two months in advance, so when we had that conversation, this video was already out the door :). But thanks for adding it here, as it will certainly help someone. And yeah, I hear you about tables. Oh, man... Once I record a video, I usually have about ten of these "oh, I should have also included..." ideas. And sometimes I will rerecord the entire thing, but the funny thing is, it's a never-ending thing :). So at some point, you say: "Happy travels video," and move on to the next one.
@@ExcelOlympics Recorded months in advance… aha. That explains it. I know what you mean and how that feels. You know I have an Excel-related YT channel myself (very dormant) and when preparing for a video I (used to) go through the entire scenario/script many many times - I encountered the very same feeling. And here is another question: do you have a multi-person video-workflow (based on your response)? I myself am just one guy who already spends way too much time working, so no time for making videos. But the holiday season is coming up, maybe I’ll make a few then (some specific exercises, level 300, I think). Oh yeah, did you select a winner for the PDF already? Would love to see a follow-up video on the Ken Pulse interview. :-) Cheers.
Believe it or not, there are no scripts. I do training sessions and conference sessions. These are just snippets of those transferred into TH-cam format. As far as "the Team" goes. Content-wise, it's just me. I do have a Video editor as I simply don't have the time. The only videos that I edit myself are the Interviews and Book Reviews videos. The winner of the book will be notified on Friday. I am still in the dark about how to make the process as smooth as it can be. I don't know TH-cam well enough to know if it offers a peer to peer communication without it being public. I really don't want any personal info to be shared publicly.
@@ExcelOlympics You can always click on the YT-account and hope to find an email address in the info section (that’s how I found yours). Or you can always ask the winner to send you an email on your public address. (Or you can ask another MVP) For me it is all me. So posting videos is going to be very rare. I prefer to spend (too much) time on work, and even helping people at work with their Excel problems (it is even an official secondary objective for me - I asked for that, and I got it).
Thank you for indulging me in the Brilliance Shoaib :). Now I would love to give you the shortcut but I'm not sure I understand your request. Could you elaborate, please?
@@ExcelOlympics like Cntrl + Shift +L to filter from header then I will select drop down . But sometim you chose any cell to filter it randomly . By pressing some short key pattern. I hope now you can understand my point of view. Otherwise I can email you.
@@shoaibrehman9988 I think you can filter like this by: 1. Going to the cell with the value you want to filter with, then; 2. SHIFT + F10 or Menú button with your keyboard 3. Then on the visible options of the menu button, check the letter that's underlined of each option. 4. For Filtering, I believe is F. Then you will open the submenu and then press V to filter from cell's value. Hope it works. 😁🙏
Hmm every k is brilliant. Thanks Gasper. I jump quickly to bigger things not those "small" things. Now I know that those small things are as life saving as the "bigger" ones. Terimakasih.
Hi tut. So if I say the shortcut is Ctrl + $, that in my case means I have to press Ctrl + Shift + 4... Could it be you need to add a combination also?
THANK YOU VERY MUCH!
Thanks Rita.
Thanks for sharing. 👍🙂
Don't mention it Davor.
have to agree with everyone: Brilliant. Thanks for the outstanding lesson.
Thanks RC.
I like the moving the columns shortcut. Sometimes I got so tired of inserting blank columns to move around columns.
Thanks Tut. Yes, this is a time-saver :)
You are so funny, cute, carismatic. It's funny how you get so excited, euforic: "it's so brilliant". You say a lot the word brilliant and favorite. LOL. Thank you for your videos.
Thank you for those kind words Tut. I say brilliant a lot, but just because it trully is brilliant :).
Long Live 🔥🔥 the SHIFT keystroke 🔥🔥🔥!
Oh yes 😀
Hi Gasper,
On ALT+DownArrow: you could have added that it also works to display the options in functions (subtotal, aggregate,…) - we’ve talked about that before. Furthermore: in Excel Tables it works in the entire column - no need to be adjacent.
BTW: I don’t use the shortcuts for NOW() and TODAY() because their results are static, I prefer to use the functions.
And finally, less than a year ago I switched back to using an Int’l QUERTY for the obvious reasons. ;-)
Hi Geert. These videos (except for Interviews and book reviews) are recorded two months in advance, so when we had that conversation, this video was already out the door :). But thanks for adding it here, as it will certainly help someone.
And yeah, I hear you about tables. Oh, man... Once I record a video, I usually have about ten of these "oh, I should have also included..." ideas. And sometimes I will rerecord the entire thing, but the funny thing is, it's a never-ending thing :). So at some point, you say: "Happy travels video," and move on to the next one.
@@ExcelOlympics Recorded months in advance… aha. That explains it.
I know what you mean and how that feels. You know I have an Excel-related YT channel myself (very dormant) and when preparing for a video I (used to) go through the entire scenario/script many many times - I encountered the very same feeling.
And here is another question: do you have a multi-person video-workflow (based on your response)? I myself am just one guy who already spends way too much time working, so no time for making videos. But the holiday season is coming up, maybe I’ll make a few then (some specific exercises, level 300, I think).
Oh yeah, did you select a winner for the PDF already? Would love to see a follow-up video on the Ken Pulse interview. :-)
Cheers.
Believe it or not, there are no scripts. I do training sessions and conference sessions. These are just snippets of those transferred into TH-cam format.
As far as "the Team" goes. Content-wise, it's just me. I do have a Video editor as I simply don't have the time. The only videos that I edit myself are the Interviews and Book Reviews videos.
The winner of the book will be notified on Friday. I am still in the dark about how to make the process as smooth as it can be. I don't know TH-cam well enough to know if it offers a peer to peer communication without it being public. I really don't want any personal info to be shared publicly.
@@ExcelOlympics You can always click on the YT-account and hope to find an email address in the info section (that’s how I found yours).
Or you can always ask the winner to send you an email on your public address. (Or you can ask another MVP)
For me it is all me. So posting videos is going to be very rare. I prefer to spend (too much) time on work, and even helping people at work with their Excel problems (it is even an official secondary objective for me - I asked for that, and I got it).
Simply Brilliant thanks for sharing with us.
Could you please add one more in any cell range any selected cell will filter.
Short key please.
Thank you for indulging me in the Brilliance Shoaib :). Now I would love to give you the shortcut but I'm not sure I understand your request. Could you elaborate, please?
@@ExcelOlympics like Cntrl + Shift +L to filter from header then I will select drop down . But sometim you chose any cell to filter it randomly . By pressing some short key pattern.
I hope now you can understand my point of view.
Otherwise I can email you.
@@shoaibrehman9988 I think you can filter like this by:
1. Going to the cell with the value you want to filter with, then;
2. SHIFT + F10 or Menú button with your keyboard
3. Then on the visible options of the menu button, check the letter that's underlined of each option.
4. For Filtering, I believe is F. Then you will open the submenu and then press V to filter from cell's value.
Hope it works. 😁🙏
Hmm every k is brilliant. Thanks Gasper. I jump quickly to bigger things not those "small" things. Now I know that those small things are as life saving as the "bigger" ones. Terimakasih.
Even more so as they are included everywhere and repeated multiple times.
I wonder why it's not working for me the shortcut formmating percent, dollar, etc. I am in USA, and I use the mini keyboard logitech.
Hi tut. So if I say the shortcut is Ctrl + $, that in my case means I have to press Ctrl + Shift + 4... Could it be you need to add a combination also?
You can enter current date AND time in the _same_ cell by typing CTRL + ; (semicolon) then SPACE then CTRL + : (colon).
True Paul. Thanks for adding that.