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!
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.
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.
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.
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.
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.
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.
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 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.
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.
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!
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.
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.