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
Mike Girvin, ExcelIsFun
Mynda Treacy, My Online Training Hub
Oz du Soleil
Believe me, you will learn something new and cool from watching these videos. You can also VOTE for your favorite entry here.