Have you heard about the Excel Hash competition?
It is a contest initiated by Oz du Soleil at Excel On Fire. Six well-known Excel MVPs, including Oz himself, show you what they can do with four designated Excel features/functions, and more importantly – how, on their YouTube channels.
The four Excel Features/Functions are:
- MAX Function – A basic function, well… you think it is?
- FREQUENCY Function – A not-so-well-known function for counting number of values to a specific bin. Many people use COUNTIF(S) to do the same, because they don’t know about FREQUENCY
- Form Control – cool stuff to make your spreadsheet interactive (btw, I have many posts about it, check them out here)
- 3D Model – Something new in Excel 365
As you know, the true power of Excel never comes from a standalone function or feature. It comes from the ability of mixing function/feature together to do something great and impressive. Of course it requires out-of-the-box thinking from the people who use it. You will know what I am talking about after watching the six entries below.
The six contestants and their delicious dishes are:
Bill Jelen, aka Mr. Excel
Jon Acampora, Excel Campus
Leila Gharani
Mike Girvin, ExcelIsFun
Mynda Treacy, My Online Training Hub
Oz du Soleil
https://www.youtube.com/watch?v=D9g-l6NjkIM
Believe me, you will learn something new and cool from watching these videos. You can also VOTE for your favorite entry here.
Enjoy! 🙂