Excel Shortcuts for Consultants

[@FirmLearning]

Check out the ASUS VivoBook S14 (S435) designed on the Intel® Evo™ platform here: viraln.co/IntelEvoFLYT

[@FirmLearning]

Download the Excel worksheet from the video for you to work along: link.firmlearning.com/shortcuts

[@wannabedal-adx458]

Cntl and Shift + Space to highlight columns and rows and Cntl + / - to insert and delete a column or row were probably the top shortcuts I learned here. I also like Cntl + 1 to bring up the formatting dialog. Thanks Heinrich

[@FirmLearning]

Super happy to hear this was helpful. Appreciate it - thanks for watching! Best, Heinrich

[@judyl.7811]

4:10 highlight table: ctrl +A 4:40 moving with tables: ctrl +Arrows 5:30 select all arrows: Shift + Ctrl + arrow 6:10 open formatting pane: Ctrl +1 7:00 highlight row: shift + space highlight column: ctrl + space 7:40 to show the work while using cursor, can use the highlighting trick. 8:00 insert above a new row or column: ctrl + + (also with cursor) 8:40 delete a row or column: ctrl + - 11:00 !!! perform a formula for a long column: ctrl + V. 11:45 highlight the formula in a cell: press F2 12:35 put into values than formula: select and copy all, and paste value 13:10 pasting value: or ctrl + V + V. 14:15 fixed and relative references 15:30 evaluate the formula: F9. Back again: ctrl +Z

[@TheEnrique1206]

These are all shortcuts I learned when I started working, took me some time to learn them all and more but I wish I knew them in HS and college. Thanks for the solid content!

[@FirmLearning]

Happy to hear you can confirm these are helpful. Appreciate you watching! :) Best! Heinrich

[@ScottishJazzman]

Heinrich, I always love your videos. Your insights into consulting are really illuminating, but these “technical top tips” are both illuminating and helpful!

[@FirmLearning]

Super happy to hear that, thanks! Best, Heinrich

[@brunorivarolla]

Very simple, but relevant, new excel users sure will love this.

[@FirmLearning]

Very much hope so :) Thanks for watching Bruno! Best, Heinrich

[@Gorlenius]

This is for sure helpful, thank you for sharing Heinrich!

[@FirmLearning]

Thank you for watching, appreciate it! Best, Heinrich

[@romanbaczynski8656]

Wow. Really useful tips to help speed up work in excel. Great that you responded to viewer comments. Thanks 👏

[@FirmLearning]

Hi Roman, thank you, super happy to hear the video was helpful. Thanks for watching! Best, Heinrich

[@aleksanderwiniarczyk3484]

Awesome video! Excel shortcuts are my thing, so I can also recommend alternative way to populate content with formula downwards or to the right. Ctrl + D will populate the range with the content of first cell at the top. Ctrl + R will populate the range with first cell on the left.

[@FirmLearning]

Nice ones as well, thanks for sharing Aleksander! :) Best, Heinrich

[@ningkang1949]

Very helpful, thanks a lot ~ wish to see more videos like this such as pivot tables~

[@FirmLearning]

Hi Ning, yes Pivot tables are definitely also a great topic. Stay tuned for future videos! :) Best, Heinrich

[@VladArnoldner]

I would like to learn more about pivot tables

[@FirmLearning]

Hi Vladimir, thanks for the comment. Yes good one, was already thinking about doing a future Excel video on Pivot tables. Indeed they are super helpful! Stay tuned :) Heinrich

[@VladArnoldner]

@@FirmLearning Danke Schön! :)

[@ching-chunkao4738]

Love the video! Very helpful. Hope there will be a PPT shortcuts sharing next time :)

[@FirmLearning]

Good idea as well, thanks Ching-Chun. Stay tuned! Best, Heinrich

[@MrNamelessGermany]

Another quick way to copy values is actually just to paste them (Ctrl+V) then directly after hit Ctrl so that the little context menu for pasting options opens, then move two times down and hit enter. Literally takes less than a second :) Works the same with other special paste modes (formatting only, transpose etc.)

[@FirmLearning]

Hi Babo, yes this indeed sounds like a great option as well :) Thanks for sharing! Best, Heinrich

[@yamani999]

Indeed, although I find faster to press Ctrl to open the context menu, and then pressing V (shortcut for Value). Saves you a couple of clicks

[@katerynazinovska2295]

Thanks for a very resourceful video! For the avg. price, there must be even faster way (not sure if it works on Windows tho, I am a Mac user), by calculating the first row, then just double click the small square in the bottom right corner of the cell with the avr price you got and it will automatically count all the cells below by same formula till end of existing table.

[@FirmLearning]

Hi Kateryna, sure this works, though in general you want to avoid using the mouse :) Thanks for watching! Best, Heinrich

[@Up_wa_rd]

Do you also have a "cheat sheet" with an overview of the shortcuts? Or is the proper way to just get a tattoo with them?

[@FirmLearning]

After some time you just know them by heart. To get there, my cheat sheet is Google ;) Best, Heinrich

[@Experte13]

Hey Heinrich, I really liked your power-point course and it was tremendously helpful :) I have watched all your videos about excel and I am wonderig if you have any plans to launch an excel course?

[@FirmLearning]

Hi Joshua, thanks for your kind comment and taking the course. Indeed thinking about this but no release date yet. Stay tuned :) Best, Heinrich

[@dariuskonig8762]

Hallo Heinrich, thanks once again for the informative content! Given that I'll be starting my first Consulting internship in August, your videos are the perfect preparation for an optimal first impression there. Are you thinking about making a full Excel online course? I'd be interested in that. LG, Darius

[@FirmLearning]

Hi Darius, that sounds great, hope you will have a great experience at the internship! Yes indeed thinking about it but will probably still take some time until it is completed (a bit swamped with my "regular" work at the moment..). Thanks for being a regular viewer and supporting the channel :) All the best, Heinrich

[@m20001]

Great content!

[@FirmLearning]

Great to hear - thank you Max! Best, Heinrich

[@Y2H893]

Hi Heinrich, what bag are you using in the video?

[@ZDY66666]

hello, can you do a formulas video? And other than vlookup or hlookup or indexmatch or various IFs (showing nested IFs would be cool! Use it all the time in my projects altho pivot tables more most part can do similar things). Very curious to what other more niche formulas you'd be sharing

[@FirmLearning]

Hi, yes great idea! Might do more about this in future videos! :) Best, Heinrich

[@manuelboth6496]

Thanks Heinrich, again very helpful! What was the shortcut for entering the formula so fast?

[@FirmLearning]

Hi Manuel, thanks for watching! You mean the formula towards the end of the video when I demonstrated F9? No shortcut for that, just cut out a few seconds from the video to not bore you with me typing ;) Best! Heinrich

[@manuelboth6496]

@@FirmLearning Yes. In that case... the cutting was too good for my eyes ;)

[@kadichidu4171]

Please make more videos on excel

[@idontdotravelhoney]

Great video Heinrich 🙌🏻... What's the scope of Tableau and Power BI in consultancy compared to excel?

[@FirmLearning]

Hi Apurva, it is sometimes used (personally saw Tableau more often than PowerBI), though as most clients do not use it, Excel is still the lowest common denominator which is therefore still most frequently used! Best, Heinrich

[@hunterakb]

If you want to build dashboards with large sets of data, visualization tools like these comes in handy

[@gretagilardi4209]

Hi Heinrich, have you ever thought about creating a course on Excel similar to what you have for PPT ? I would really appreciate it! Thank for the video btw :)

[@FirmLearning]

Yes, might indeed do this in the future :) Stay tuned! Best, Heinrich

[@_truthart]

Could you please add a downloadable cheat sheet with the list of shortcuts?

[@pooclan1758]

What computer is he using?

[@xorolow1]

Number formatting works way more smooth with shift + Control + ! Or $

[@FirmLearning]

Yes good one as well! Best, Heinrich

[@syntx6643]

Hey Heinrich, sehr interessantes Video! Diese Art von Video gefällt mir besonders. Was ich mich seit längerem Frage, muss man nach dem leave bei McK wieder kommen? (Man verdient ja noch Geld während des leaves) Allgemein das Thema leave wäre mal ein Videovorschlag von mir :) Grüße

[@FirmLearning]

Hi, das hängt davon ab was genau du machst. Die Details der Regelungen sind auch je Land unterschiedlich. Wenn du umfangreichen finanziellen Support in Anspruch nimmst musst du für einige Zeit wieder kommen, aber deutlich kürzer als in den meisten Programmen von Banken oder so. LG, Heinrich

[@syntx6643]

@@FirmLearning Ah okay. Das hilft mir schon mal weiter. Nett, dass du noch geantwortet hast. Du hast bestimmt wenig Zeit, bei zwei Jobs und ner Familie. VG und dir ein schönes Wochenende!

[@josephzenteno8293]

Awesome thank you

[@FirmLearning]

Thank YOU for watching Joseph! Best, Heinrich

[@keinnamee9807]

Which notebook did he use?

[@FirmLearning]

;) Thanks for watching! Best, Heinrich

[@Up_wa_rd]

>reviews a high-end laptop >personal highlight: yellow marked enter key 🤣👌

[@FirmLearning]

;) Something different compared to all the others available on the market. Thanks for watching!! Best, Heinrich

[@sdfasdfasdfsadfafsdfasdf9926]

Personal question but what's your net worth?

[@FirmLearning]

🤓

[@ajb229]

I knew several of these so perhaps I’m not such an Excel novice as I thought

[@FirmLearning]

Trust you are already quite an advanced user Alistair :) Best! Heinrich

[@huskidusk]

ctr shift space

[@FirmLearning]

Thank you! :)

[@huskidusk]

ctr shift and L

[@FirmLearning]

Thanks for sharing these Oskar!!

[@Markus85Rock]

Sie ständigen Einblendungrn nerven leider. Irgendwie wird man komplett rausgerissen. Ansonsten super content. Danke. Finde Bediener gut das du die shortcuts in der Anwendung zeigst.

[@FirmLearning]

Hi Markus, danke für das Feedback! Werde weiter daran arbeiten da eine gute Balance zu finden zwischen den Inhalten und gelegentlichen Werbeeinblendungen. Vielen Dank dir fürs Zuschauen! LG, Heinrich

[@huskidusk]

alt n v p enter

[@FirmLearning]

Thank you! :)

[@huskidusk]

Alt w f r

[@FirmLearning]

Thank you! :)

[@joon769]

He iz noob

[@FirmLearning]

;) Thanks for watching.