Hot Key Excellence VLOG

Excel Macros

With Excel VBA you can automate tasks in Excel by writing so called macros.

Learn how to create a simple macro in this video – it’s easier than you think!

Advanced Functions

We cover Advanced Excel functions in this video.

Learn more about: CHOOSE, OFFSET, LOOKUPs, MATCH, INDEX, INDIRECT.

Enjoy the easy and simple way we explain it to you, and fly in Excel with us.

Intermediate Formulas and Functions

In this video we cover the following Excel functions, knowing which would help you to reduce time spent in Excel on so many frequent tasks.

Learn more about: AVERAGE, MEDIAN, MIN, MAX, SMALL, LARGE, COUNTs, ROUNDs, PRODUCT, SUMPRODUCT.

Enjoy the easy and simple way we explain it to you.

Additional Shortcuts for Ribbon Navigation

Insert pivot table, trace dependents or precedents of the formula in the given cell, and more – find all the Excel tricks in this video we crafted for you.

Alt W – View on Excel Ribbon

How to hide or freeze Excel rows or columns with a couple of clicks? Easy – watch here – and you’ll learn even more than that.

Alt A – Data on Excel Ribbon

Do you know how to group, sort or filter mouse-free in Excel? Yes, it’s possible and there are very easy and logical shortcuts for it, when using Ribbon Navigation. Learn more in the video below.

Print and Page Layout

Everyone knows the print button, but do you know how to adjust the print area the best way for you? Do you know how to do it in couple clicks with no mouse? Learn Excel printing tricks in our video below.

Excel Shortcuts for Font, Alignment, Border, and more (“Home” Ribbon)

Most frequently used Excel actions are on the “Home” Ribbon. Knowing where to find them quickly and efficiently will be a dramatic time-saver for you, especially when doing it mouse-free. Learn more in our video below.

Quick Access Toolbar and More Ribbon Navigation Tricks

Quick Access Toolbar is the space on the Excel Ribbon, where you can save the most often used by you commands, so it would be much easier and quicker to find and access them. Learn more Excel Ribbon Navigation tricks in our video below.

Excel Shortcuts for the Advanced Formatting

80% of time in Excel people spend on navigating and formatting, not on doing analysis / modeling itself. Learn in this video how to save tons of time in Excel with simple formatting shortcuts and and tricks.

Excel Shortcuts for the Advanced Copy-Paste

Ctrl+C / Ctrl+V knows everyone, right? But do you know you can copy and paste column width? Or make calculation with Paste Special option in Excel to convert numbers from millions to thousands and back? Learn advanced Copy and Paste tricks – we promise, it will save you so much time in Excel!

Excel Shortcuts for Navigating and Highlighting

80% of time in Excel people spend on navigating and formatting, not on doing analysis / modeling itself. Learn in this video how to save tons of time in Excel with simple navigating and highlighting shortcuts and and tricks.

Excel Shortcuts For Beginners

Learn Excel the right way from the very beginning – mouse-free. This will make you 10X faster and more efficient in Excel. Start your journey with this video from Hot Key Excellence team.